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.

arch .. you posted in a SQL2008 forum, hence the refs to it.

Anthony already provided the link to your solution 😉

/* SQL Server 2000 - sa password changes */

USE Master

GO

SELECT...

just as a side dish ... why is column datekey not a date column ?

May avoid conversions to take advantage of date functions.

( maybe that's all been covered in your...

Did you check this article http://www.sqlservercentral.com/articles/Security/87159/

or this thread : http://www.sqlservercentral.com/Forums/Topic988899-149-1.aspx