Check our collection of high-quality articles, on a variety of SQL Server Performance topics. The collection is being regularly updated with new articles.
A few days ago, on March 21st, I participated as an invited speaker at Microsoft Conference 2014 that took place in Nicosia, Cyprus. My session was on SQL Server 2014 and specifically about what’s new in this release of SQL Server. My session’s agenda was on the following areas of new features on SQL Server: … Read more…
In one of my previous articles, I talked about Index Fragmentation in SQL Server in terms of how to track it and how to resolve it. In this post, we are going to see how to rebuild all the indexes of a database in SQL Server. The techniques explained in that post provided ways of … Read more…
As its names implies, the tempdb database contains temporary data that is created during SQL Server operations, therefore, the tempdb growth is one significant issue that needs to be properly managed in SQL Server. Temporary data stored in tempdb system database Temporary data stored in temdb may include: temporary user objects (i.e. temporary tables, cursors), … Read more…
At some time today, I had to compare the indices of various database tables. To this end, I needed a fast way of getting index information for specific tables. In SQL Server, there is a system stored procedure (stored in the master database) called sp_helpindex. The syntax for using it is the following: EXEC sp_helpindex … Read more…