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.

2015-03-05

7,574 reads

Blogs

Introducing system-versioned ledger tables

By

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

Daily Coping 15 Sep 2021

By

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

My upcoming Online Trainings and Speaking Engagements

By

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

Read the latest Blogs

Forums

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

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers