(Tim Chapman) In this blog post I’ll (re)introduce you to a really neat tool to use alongside of SQL Server and use this tool to show you how SQL Server is handling IO under the covers. We will view the IOs as they occur, and then tie the IO back to the pages that we pull into the buffer pool.

(Manish Sharma) In this article we will learn about the advanced version of “sp_who” named “sp_who2” system Stored Procedure. This sp_who2 provides more information about the current user and process compared to the sp_who system Stored Procedure.

(SQLDenis) Sometimes you have to insert a bunch of data and you can’t use BCP or another bulk load method. When you do single row inserts, SQL Server wraps these inserts inside an implicit transaction.

(VidhyaSagar) I wrote multiple articles on heterogeneous linked server which helped user to connect to Sybase , SQL Server & MySQL RDBMS platforms. However I missed creating Oracle linked server , many users responded to write an article on this so I decided to complete it.

(Kun Lee) We have quite a lot of SQL Server jobs and as a production DBA I only want to get notifications when jobs fail. I get enough emails already and getting more emails will not help me work on the real problems. However, sometimes business owners want to get notifications for their jobs.

(Dinesh Asanka) A Filtered Index is a new index type introduced in SQL Server 2008. In simple terms, rather than adding a non-clustered index to the entire table, you can add an index to a filtered data set.

(Bob Pearson) Sometimes you have a need to rebuild all indexes on a table. This could be because of an ETL process, or other data loading process that renders the indexes out of date.

(Pinal Dave) “Don’t use functions in the WHERE clause, they reduce performance.”

(Rohatash Kumar) In this article, I would like to show the utility of Getdate functions in SQL Server. So let’s have a look at a practical example of how to use the getdate function with a different query to find the date and time in SQL Server 2012. The example is developed in SQL Server 2012 using

(Jason Strate) As I’ve worked with clients on performance tuning through index improvements, one of the common areas that I discuss with them are duplicate indexes. The problem with duplicate indexes is that they are pointless and redundant. All they provide is an additional physical copy of the i