Check our collection of high-quality articles, on a variety of SQL Server Performance topics. The collection is being regularly updated with new articles.
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…