that's why - although not mandatory - it is best to keep disk-layout equal at db instances involved in db mirroring.

If you need to add a data file in a...

Here's an ( oldfashioned ) alternative so you can compare performance depending of the % of your set that needs to be updated.

Run it over a big set of data...

the described scenario is other people activated an IPS system.

There is only little you can do if they don't inform if such thing would cause issues for your db-server or...

Thank you for the feedback.

Knowing where to look is a good start for any assessment .

have a look at "grouping sets" in books online

or at

Technet and Technet too

This is what I always use :

if OBJECT_ID('tempdb..#tmp_Restores') is null

begin

SELECT @@servername as ServerName

, r.command as [CMD_Type]

, r.start_time

, r.percent_complete

, dateadd(second, r.estimated_completion_time...

one of the worst practices is converting a datetime any other data type. Let alone to integer format DDMMYYYY !!!

It just looses all date characteristics and functions one can...

Great article, David.

have a look at Roberts blog : http://www.sqlsoldier.com/wp/sqlserver/breakingdowntempdbcontention

that is if you're looking for contention issues.

Anther place to start can be :

http://www.sqlservercentral.com/Forums/FindPost1050355.aspx

How about:

select @dt [date as is]

, dateadd(yy, -1,@dt) [date-1Y]

, dateadd(wk, datediff(wk, 0, dateadd(yy, -1,@dt)), 0) ...

dwain.c (7/4/2012)

ALZDBA (6/29/2012)

dwain.c (6/28/2012)

Please don't laugh! ...

to change the login mode option, your sqlinstance needed to restart - which happened because of your crash - so when exactly the registry value has been set .......

You can test this using the attached simple script and compare the generated plans and consumptions :w00t:

The last result set will contain the execution plans ... if they reside in...

1) Keep...

just extract it and run the msi.