Viewing 15 posts - 30,226 through 30,240 (of 49,552 total)
For your monday evening entertainment: http://www.sqlservercentral.com/Forums/Topic997896-357-1.aspx
There are days I just don't want to know...
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
October 4, 2010 at 3:08 pm
Open management studio, connect to server. Right click database, select delete. Check that you deleted the correct one.
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
October 4, 2010 at 2:53 pm
Yay. Someone who can read and knows what a search engine is. I like you already!
If you want some laughs and have several hours, there are two more such threads...
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
October 4, 2010 at 2:42 pm
There are no errors in that message. It's cut off, only the first chunk's there.
Check the SQL error log. If a backup failed it'll be logged there.
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
October 4, 2010 at 2:06 pm
dant12 (10/4/2010)
I want to save to a table, I can't because the SP_TRACE_CREATE doesn't let me
No, you absolutely do not. Not unless you want to cripple performance. Tracing to 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
October 4, 2010 at 1:56 pm
Depends what that unused space looks like. If it once was part of a table, there will still be values on those pages. SQL doesn't zero out a page once...
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
October 4, 2010 at 1:22 pm
brainy (10/4/2010)
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
October 4, 2010 at 1:19 pm
David O (10/4/2010)
Feel free to mock and ridicule. I'm guessing this one might wind up on the never ending "Are the questions getting dumber" thread. 😀
Nah. That's for really dumb...
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
October 4, 2010 at 1:04 pm
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in the...
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
October 4, 2010 at 12:56 pm
CheckDB is not running on startup.
Those messages are not saying that checkDB has completed. Check the dates in the messages. They are saying when CheckDB last ran successfully (without error)
2010-10-04...
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
October 4, 2010 at 12:02 pm
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
October 4, 2010 at 11:48 am
All data modifications in SQL are always logged in the transaction log, regardless of recovery model. Primarily the difference between full and simple recovery is when the inactive portions of...
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
October 4, 2010 at 11:47 am
Two words:
SQL Injection
Make sure you're familiar with the SQL injection vulnerability and that you've taken appropriate steps to prevent hacks from occurring, because this procedure is vulnerable.
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
October 4, 2010 at 7:05 am
Please don't crosspost. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic997349-146-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
October 4, 2010 at 3:41 am
Please don't crosspost. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic997349-146-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
October 4, 2010 at 3:38 am
Viewing 15 posts - 30,226 through 30,240 (of 49,552 total)