This is a setting that DBA are advised to place at the start of the stored procedure. What this setting does? Let us run an sample code for this. US...

This is a setting that DBA are advised to place at the start of the stored procedure. What this setting does? Let us run an sample code for this. USE AdventureWorks GO SELECT * FROM Person.Address SET NOCOUNT ON SELECT * FROM Person.Addre...

Having discussed about indexes into some level, now it is time to discuss new index type which came along with SQL Server 2008, filtered index. In filtered index, you can define index to th...

Having discussed about indexes into some level, now it is time to discuss new index type which came along with SQL Server 2008, filtered index. In filtered index, you can define index to the filter portion of your data. For example, you can create a no...

How many objects/features you have in SQL Server? It will range from simple Table, View to CDC, Encryption. Let us says that you were asked to create a server trigger. Do note that DDL tri...

How many objects/features you have in SQL Server? It will range from simple Table, View to CDC, Encryption. Let us says that you were asked to create a server trigger. Do note that DDL triggers do not have a user interface support in SQL Server Manage...

We are in the process of discussing usage of indexes in SQL Server. Today it is time to discuss another type of index. As we did in the previous occasions, let us compare following two quer...

We are in the process of discussing usage of indexes in SQL Server. Today it is time to discuss another type of index. As we did in the previous occasions, let us compare following two queries. SELECT ProductID, SalesOrderID, SalesOrderDetailID FR...

sp_helpindex is another key word you can add as a short cut...

sp_helpindex is another key word you can add as a short cut...