Automatically Indexing Millions of Databases in Microsoft Azure SQL Database

Automated SQL Server Indexing at massive scale Read more →

SQL Server Performance Tuning

How can I improve my SQL performance ? Find Loads of SQL Server Performance Tuning articles Read more →

How to use Database Tuning Advisor via command line

Question: Is it possible to use SQL Server Database Tuning Advisor through the command line? Answer: On a server with SQL Server installed you can start the SQL Server Database Tuning Advisor In the command line type "dta".That will return something like : Microsoft (R) SQL Server Microsoft SQL Server Database Engine Tuning Advisor command line utility Version 14.0.800.90 ((SQL_Main).170711-1339) Copyright (c) 2015 Microsoft. All rights reserved. Additionally - you can use : dta -? and that will give you extra usage details along with descriptions per switch Usage: DTA.EXE [-S ServerName[\Instance]] [-U LoginId] [-P Password] [-E] [-d DatabaseName] [-D... Read more →

Most important SQL Server wait types

Before I discuss the most important wait type list , I want to say that really there is no definitive list of most important sql wait types. Understanding what is normal and the context of the wait type is essential when discussing wait types. For example , you may see the sql wait type WRITELOG as high on the list of waits on a SQL Server. This may or may not be important depending on the "normal" behaviour. Benchmarking your systems is a great way of understanding the patterns your systems. Based on monitoring and analysing various SQL Server performance... Read more →

Type Conversion may affect cardinality estimate in query plan

Type Conversion may affect cardinality estimate in query plan is a warning found on Execution Plans. This may negatively impact the correct index usage. Cardinality is a critical part of how indexes are used. Data type matching has many benefits. It’s a practise often neglected in database design but which can have a number of long term consequences for query access and database performance One long term cost of neglecting data type matching is it can lead to more memory required. When data types are matched , this leads to less bytes requires , leading to less data pages in... Read more →