It works if you specify NULL, If you specify nothing( Single Quotes with a space) it enters the default Jan 01 1900.

Run the script like this

create table ##test

(myddd datetime...

I tried the same query with just 10 levels in the CASE statement and it works fine. When I add one more level to the the CASE statement I get...

This code was written by our business user, He has ask me(DBA) to trouble shoot the error. I believe his reasoning behind the group by is that if you use...

The code is below...Our business user is trying to run this from a server name MIS. It selects the data below from a linked server name POS. There is...

I have another stored procedure that I thought I might try to run the sp_recompile against to see if it would improve the performance. It normally takes 15 hrs to...

Andy

I tried it on the Store procedure but no luck so I ran sp_recompile against the tables that the query calls and it worked. It brought the query down from...

Steve, worked great! Thanks for the info.

Greg

Andy,

I have my database log shipping to two servers one on site that is restore up to 5min of the live production and one off-site with a delay incase user...

If you are backing up VLDB you should not be using backupexec but SQL native backup with multiple drives. I have a 30GB database that can be backup in...

Yes see the BOL DBCC commands below called

DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE.

hope this helps...

DBCC FREEPROCCACHE

Removes all elements from the procedure cache.

Syntax

DBCC FREEPROCCACHE

Remarks

Use DBCC FREEPROCCACHE to clear the procedure cache. Freeing...

I would recommend log shipping for the reason of having a delay in the time you want the logs restore to the database. The data would be copied and ...

Hi I was looking for the same solution and have tried the exec master.dbo.xp_cmdshell "del c:\dts_diag\sp_diagnostic_PO_13.xls" but when I run the PKG again it says it can't find the .xls...