Viewing 5 posts - 271 through 275 (of 275 total)
Leave the SET NOCOUNT ON active for the entire procedure...
At the end of your procedure you reverse course by SET NOCOUNT OFF....this will give you the typical '55 records updated'...
January 15, 2004 at 3:31 am
If he thinks his "database performance headache" will be any less than his "difficult-to-use-database headache" then his 'limited database knowledge' will prove not to be the aspirin he wants.
3 properly designed...
January 15, 2004 at 3:19 am
I'd advise replacing the WITH RECOMPILE with a periodic and scheduled sp_recompile.
The WITH RECOMPILE option may have taken effect when 'unusual' data quantities or values (or indices) were in place....
Try...
December 23, 2003 at 2:32 am
Sounds like "Zoltan" doesn't see that this is an off-the-wall objective....
it's a bit like saying...(just because today is FRIDAY)...I want all my references to SELECT @dt = GETDATE()...
November 7, 2003 at 3:03 am
in relation to the 2nd part of your question...."It works fine if there are data for the very last day of a month. However sometimes the data is not ideal....
September 30, 2003 at 3:40 am
Viewing 5 posts - 271 through 275 (of 275 total)