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


Why I Support Code Automation Tools Like ORMs


I know I’m a weirdo. I’ve always been a weirdo. When I was a...

#PowershellBasics: Run a file and pass it a parameter.


I realized in my last #PowershellBasics post that I was talking about running a...

SQL Undercover TV – Instant File Initialisation


Adrian has a look at the performance benefits of instant file initialisation Below is...

Read the latest Blogs


Add two rows to a view

By Ken at work

I'm creating a view of individuals in a department. That is easy. Select p.PREmp,...

query to check the duplicates

By mcfarlandparkway

i have a table, where a column ABC holds value 123 , based on...

Why my reg matching returns nothing?

By PasLe Choix

I want to do some match on a dataset that contains location value and...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

DBCC Meaning

See possible answers