Viewing 15 posts - 54,151 through 54,165 (of 59,068 total)
Oh, I understand what you want to do... but why do you want to do this to perfectly good data? Why do you need all of 1 person's info...
November 12, 2007 at 11:47 pm
Now I remember... it's called "Parameter Sniffing" and, apparently, it can crush otherwise effecient code. Lots of good info on the Web about it... Google it...
November 12, 2007 at 11:36 pm
Of course it's going to take some time... your sproc has four relatively large SELECTS and they ALL must be recompiled even if only one is going to be used...
The...
November 12, 2007 at 11:31 pm
Ummmm.... you know what SUM is... do you know what COUNT is?
November 12, 2007 at 11:03 pm
I've never understood this... a 300GB hard drive costs about $110 and a 500GB hard drive costs only about $140. Your database is going to do nothing but to...
November 12, 2007 at 11:00 pm
Very urgent normally means "I'm on an interview" or "I'm taking a test" or "I have homework due tomorrow"... what's your situation 😉
November 12, 2007 at 10:49 pm
Why does anyone think that SQL Server Express can handle the Enterprise quality/size of 2k5 databases? You've probably violated at least one size limit and Lord knows what else...
November 12, 2007 at 10:47 pm
There must be a couple million posts on how to do something like this... and, most of them are a bad use of SQL 'cause this is a form of...
November 12, 2007 at 10:43 pm
I just got done doing a conversion for "unlimited scalability" using a (yeeeeaaacchh!) Cursor (haaaaaaaaaack! Patoooooiiiii!)... it takes 17 times longer to run even though I wrote it as a...
November 12, 2007 at 10:37 pm
And, unless you're going to put the sproc in the Master database, don't use sp_ as the beginning of the sproc name.
November 12, 2007 at 10:27 pm
Remove the DROP TABLE and the GO... then, it should work as a sproc.
November 12, 2007 at 10:26 pm
Ack... I forgot that the Name column in SysDatabases is of the SysName datatype which is actually NVARCHAR... cuts the capabilities of the script in half without a conversion.
Also, 8000...
November 12, 2007 at 9:44 pm
More like SPAM than anything else...
November 12, 2007 at 6:30 pm
Yes... you need to write it in a "special" way... without a cursor! 😉
November 12, 2007 at 6:18 pm
Viewing 15 posts - 54,151 through 54,165 (of 59,068 total)