Now thanks to SQL Server 2005/2008, query execution and analyzing is too very much easy. We can do this using reporting services but lets take a bit more convenient way to find out how a query is ...

Are you a Senior Sql Server DBA or novice looking for a Daily Sql Server Health Check? As a Senior dba for over 15 years I have compile a few scripts I use on a daily basis to check the health of my ...

PowerShell check to see if SQL Server backups are not running correctly - sqlkitty/CheckSQLServerBackups ...

How can understanding wait statistics improve query performance in SQL Server? Understanding wait statistics allows the data professional to tune individual queries or, if necessary, to tune ...

Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database.

In the second blog post above, you’ll see there is a SQL Server Agent job ‘DYNPERF_COLLECT_AOS_CONFIG’, which collects the last 14 days of Windows event logs from each of the AOS servers, in addition ...

We introduce novel techniques that help significantly reduce the set of statistics that need to be created without sacrificing the quality of query plans generated. We discuss how these techniques can ...