SQL Server Education (by the geeks, for the geeks)
Hi Friends, This blog is the continuation of my previous blog on Use of Covering Indexes here is the link… Today here I will explain Adding non key columns in the …
sql_server_covering_index_2: Adding Non Key Columns Read MoreHi Friends, Today, here I just want to explain ‘what is SQL Server Covering Index?’ as well as ‘why we use Covering Indexes?’ What is Covering Index? “Covering Index is a …
SQL Server Covering Index 1 Read MoreHi Friends, Today, I just want to explain about a new type of Index, which introduce in SQL Server 2008 (SQL Server Filtered Indexes). What is Filtered Index? Filtered Index is …
SQL Server Filtered Indexes Read MoreHi Friends, Today here, I am explaining the Use of Recompile Clause in SQL Server Stored Procedures. We use stored procedures in sql server to get the benefit of reusability. Some …
SQL Server Stored Procedures – Use of Recompile Clause Read Moresql server identify long running queries It is always a big challenge to maintain application’s performance optimum. Increasing data on regular basis is often the cause for performance degrades. In most …
SQL Server Identify Long Running Queries Read More