Like you mentioned, create an alert:

Location in management studio: SQL SERVER->SQL Server Agent->Alerts

* GENERAL TAB*

type : SQL server performance condition alert

object: SQL Server: General statistics

counter: processes blocked

alert if rises above...

As been told, the errorlog is no database table. Query the registry (use xp_regread) for the location of the errorlog.

You can also use this construction to copy the errorlogfile into...

If you truncate the table, SQL marks the table as empty/reusable. All...

Start reading Books Online ("BOL" is the abbreviation you'll see on Forums) and search for the DBCC command, especially CHECKDB

Yeah, I know that discussion.

Make sure you know the benefits of asynchronously update stats before calling them.

Good luck

What? Not enabling auto_create_stats is asking for a performance showstopper. (I don't think I'll have to tell you why)

Determine the overhead and time you'll have to spend on determine which...

Here comes the Microsoft answer: "Upgrade to MSSQL 2008, start using the MERGE statement" :D:D

Hey, another W van Dijk! 🙂

Post this question in the T-SQL forum

Had the same issue, try this script for fixing collation in your tables:

------------------------------------------------------------

-- LM_ChangeCollation - Change collation in all tables

-- made by Luis Monteiro - ljmonteiro@eurociber.pt

-- modified by wilfred...

If you run sp_updatestats SQL tells you which statistics were updated. The algoritm SQL uses is documented on the internet, maybe somebody can provide the link?

Also check:

- SQL version (equal ?)

- physical drive design, location of datafiles/logfiles

- statistics

- index fragmentation

You're mixing snapshot backups (performed by NetApp Snapmanager) with SQL database snapshots.

This is a totally different concept.

When we are talking about snapshots, what do you mean? When your system administrator...

This in not true for user databases (read the article, it's true for system databases). Upgrading to...

indexes rebuild?

Correct, indexes are not recreated after a restore. The indexpages are part of the backup and they are...