Viewing 7 posts - 16 through 22 (of 22 total)
Thank you !!!
Yes it does run fast regardless of the table size --
I thought it was something simple just could not quite get it.
🙂
April 27, 2009 at 3:17 pm
comment out
join sys.dm_exec_requests r
,
then it'll work on SQL 2008
March 26, 2009 at 10:38 am
Different people may execute this sp using different SQL server logins.
I just need to know which ones ...
February 5, 2009 at 3:06 pm
Please fix the whitespacein the script, otherwise it's almost useless :w00t:
August 27, 2008 at 2:52 pm
Nope. Implicit conversion can be a problem on just about any data type. Elimination of implicit conversion would be the only way to handle that, and implicit conversion...
August 12, 2008 at 10:51 am
this makes varchar(max) a special type ... necessitating special handling aka "workaround" for a bug, maybe ??
August 11, 2008 at 4:07 pm
Another option is get rid of (do not use) the system page file. Works well for us, we have 32Gb of RAM
July 28, 2008 at 1:08 pm
Viewing 7 posts - 16 through 22 (of 22 total)