Viewing 15 posts - 37,306 through 37,320 (of 49,566 total)
Wait. Rollback has to complete. You can restart SQL, but then the rollback will still have to complete and the entire database will be unavailable while that happens.
August 5, 2009 at 11:52 am
SanjayAttray (8/4/2009)
Agreed with Matt. Rule of thumb: Never use like operator on a very large table. It kills.
More correctly, never use LIKE with a leading wildcard on a...
August 5, 2009 at 11:49 am
Teched over for another year. Good conference, lots of fun. Sessions went quite well and ratings (last time I checked) were very nice though final ratings will only be available...
August 5, 2009 at 11:48 am
Switching from Temp Tables to table variable is not going to help with IO problems. they are treated exactly the same regarding their location (memory or disk) and when they...
August 5, 2009 at 11:35 am
Bob Hovious (8/3/2009)
August 5, 2009 at 11:31 am
Jack Corbett (8/1/2009)
August 2, 2009 at 12:57 am
Jan Van der Eecken (8/1/2009)
Enjoy TechEd, Gail! Are you presenting?
Yup!
Doing a session on query hints and plan guides late on Monday and a session on evaluating indexing strategies on...
August 1, 2009 at 12:25 pm
Jeff Moden (8/1/2009)
It would be a great addition to your blog but it would also make a hellofa nice article for SSC, too!
Maybe what I'll do is blog it, then...
August 1, 2009 at 12:23 pm
Well I'm off to TechEd tomorrow and looking at the schedule I have, I doubt I'm going to be able to post here much during the next 4 days. In...
August 1, 2009 at 11:11 am
Oh sure. I must actually write a blog post on this, people keep asking.
If statements don't have a direct affect on performance. They can't, they're just flow-control, not actual processing....
August 1, 2009 at 10:49 am
You're in full recovery model and you have no transaction log backups? How on earth does that work without your log completely growing out of control?
Are you truncating the transaction...
August 1, 2009 at 9:33 am
barani (8/1/2009)
in a nut sheel will,Select Col1, Col12, Col15 FROM [Table]
improve performance to this statement
Select Col1, Col 2, Col 3 ......., Col 25 FROM [Table]
Maybe.
If you're got indexes that...
August 1, 2009 at 9:12 am
Duplicate post. No replies to this thread please.
Direct replies to http://www.sqlservercentral.com/Forums/Topic763603-338-1.aspx
August 1, 2009 at 9:09 am
Unlikely.
Oddly enough, row-by-row code doesn't usually suffer badly from parameter sniffing. Parameter sniffing is worst when the optimiser compiles a statement thinking that there's a very small number of...
August 1, 2009 at 9:06 am
Viewing 15 posts - 37,306 through 37,320 (of 49,566 total)