Database Engine Tuning Advisor

Getting Starting with Database Engine Tuning Advisor in SQL Server – Part 1

  • Article

There are different techniques to optimize the performance of SQL Server queries but wouldn’t it be great if we had some recommendations before we started planning or optimizing queries so that we didn’t have to start from the scratch every time? This is where you can use the Database Engine Tuning Advisor utility to get recommendations based on your workload.


7,574 reads


Introducing system-versioned ledger tables


As long-time readers of this blog know, I’m a big fan of temporal tables,...

Daily Coping 15 Sep 2021


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

My upcoming Online Trainings and Speaking Engagements


Over the next few weeks I have again some online training and speaking engagements...

Read the latest Blogs


Database Encryption Keys

By Phil Parkin

I'm a developer rather than a DBA, so please excuse the straightforward question! If...

Subselect / Group by - Error multiple values

By bent

Hi there! I need to update n attribute in the table "rm_request" by summing...

Query with a column containing JSON text

By Roust_m

Hi I have a table MyFiles with columns Id, FileName, FolderName, KeyPairs. The last...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers