Last week I was delivering a performance workshop to 10 people from different customers and one of them raised the following question: “Say that I’ve launched Profiler, pointed it to a given instance of SQL and set everything up to collect...

If you want to leverage the ability provided by SQL Server Database Engine Tuning Advisor to evaluate what would be the benefit of creating indexed views as an additional physical structure, you can select either of the two tuning options available for...

Beginning with SQL Server 2008 you can set the database engine to automatically audit at several levels . All the tools and processes required to easily and successfully configure such flexible and comprehensive level of auditing , so that your system...

Fuzzy Grouping is a component which, when used as part of a data flow in an SSIS (SQL Server Integration Services) package, enables you to identify groups of records in a table where each record in the group potentially corresponds to the same real-world...

You may have faced situations where you’d have wished you could avoid a run-away query consuming most or all CPU or memory shared resources of the server resources, or avoid the execution of unpredictable workload, or simply prioritize workloads so that...