Over the years, the job of a Database Administrator (DBA) has become more complex and strategic, from just managing databases to a much bigger...
Adapting to the Evolving Role of the DBA with SQL DM
read more
Pinal Dave
Columnstore Index for SQL Server
Introduction When we talk about SQL Server indexes, we are usually discussing the rowstore clustered or non-clustered index. However, along with...
Filtered Indexes and Performance
Introduction During a recent SQL Server Performance Tuning consultation, I was asked a fascinating question by a Senior DBA working with me from the...
Troubleshooting Over-Indexing for Performance
Introduction I have now warned several times against the mindset that suggests indexing is a silver bullet for SQL Server performance. In the...
Troubleshooting Under-Indexing for Performance
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Beginning Indexes for SQL Server Performance
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
3 Critical Tasks DBAs Wish They Had More Time to Complete
People are constantly asking me what to do to make money. My answer is, “I spend time with people who have trouble with SQL Server Performance...