If you are using Encrypted Stored Procedure you not see them in Activity Monitor

I am confident that you may know few and you may know many. I am now interested to read what all of you have to offer on this subject. I encourage all of you to go through complete series and write your own on the subject

Wait Stat Analysis is very crucial for optimizing databases, but it is often overlooked due to lack of understanding. We perform advanced resource Wait Statistics Analysis and provide you with suggestions to optimize your database server. We train your DBA to make them skillful enough so they can pe...

One of the most prominent limitations of the View it is that it does not support COUNT(*); however, it can support COUNT_BIG(*) operator. In the following case, you see that if View has COUNT (*) in it already, it cannot have a clustered index on it. On the other hand, a similar index would be creat...

A Simple Solution to Ancient Problem

A Direct Answer to Famous Question!

"Deleted records aren’t deleted. Look, they’re right there!” There is interesting conversation on the subject going on. If you are doing this, this one is for you -

A very simple article containing advices and suggestions about how a most responsible job owner can take vacation without any worry.

I strongly suggest that you bookmark this post as this post can be used in future when you might want to write why SQL Server is better than any other RDBMS application.

This article is an interesting story of Shrinking the Database. Do you Shrink your database - learn the story today!

If any row has any value changed, this function can be used to figure out if the values are changed in the rows. However, if the row is changed from A to B and once again changed back to A, the BINARY_CHECKSUM cannot be used to detect the changes. Let us see quick example of the of same. Learn th...

Did you know computed columns are computed at run time? Yes or No? If yes, you know the answer of following question: Is it better with performance or not? If no, go on and read it...

This blog post is for all the Oracle developers who keep on asking for the lack of “dual” table in SQL Server. Here is a quick note about DUAL table, in an easy question-and-answer format.

Self Join has always been an note-worthy case. It is interesting to ask questions on self join in a room full of developers. I often ask – if there are three kind of joins, i.e.- Inner Join, Outer Join and Cross Join; what type of join is Self Join? The usual answer is that it is an Inner Join. In...