Viewing 15 posts - 37,291 through 37,305 (of 49,552 total)
if emergency mode repair fails and you have no backup, you are out of luck. emergency mode repair is the last resort.
What might work is if you select the data...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2009 at 12:10 pm
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2009 at 11:35 am
Bob Hovious (8/3/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 5, 2009 at 11:31 am
If it has to grow again, yes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 2, 2009 at 1:15 pm
Jack Corbett (8/1/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 1, 2009 at 9:09 am
Viewing 15 posts - 37,291 through 37,305 (of 49,552 total)