Database Engine Tuning Advisor

External Article

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

Technical Article

RE: SQL 2000 - SET TRANSACTION ISOLATION LEVEL

  • Reply

I use SET TRANSACTION ISOLATION LEVEL in all my reporting where the data does not have to be up to the minute (which is most reports most of the time, if you think about it. You could also use WITH (NOLOCK) query hints on the individual tables, which amounts to the same thing, but can […]

2004-06-30

Technical Article

RE: best way to send email from SQL Server 2000?

  • Reply

Go to http://www.sqldev.net/xp/xpsmtp.htm for a SQL Mail alternative.  I am using SQL Mail on several servers.  I haven't had problems getting it configured -- but then we are on Exchange.  But, I find that SQL Mail is not always reliable.  If the Exchange server goes down for maintenance, I sometimes have to reboot the SQL Server […]

2004-06-24

Blogs

InvalidAbfsRestOperationException in Azure Synapse notebook

By

Problem The first issue that developers in my team noticed was when they tried...

What do we want to achieve by encrypting our data?

By

On the face of it, this is a very obvious question with a very...

Daily Coping 5 Dec 2022

By

Today’s coping tip is to look for new reasons to be hopeful, even in...

Read the latest Blogs

Forums

log shipping restore from primary server backup directory

By sqlfriend

To understand the concept of transaction log shipping, in below case, will it work:...

Optimization for Single Table with Thousands of Concurrent Updates

By keith.west-982594

I have a table with 5 million records and each record requires a "Value"...

Pivot not working, pivot without aggregate functions.

By sbhagyalakshmi95

Hi Team,   Can you please help me to get data pivot data. my...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers