Viewing 15 posts - 27,976 through 27,990 (of 49,552 total)
CheckDB runs database integrity checks. Nothing else. It doesn't cause errors. It should be run regularly to make sure that things aren't broken.
Regardless, there's nothing to disable, checkDB runs when...
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
February 2, 2011 at 4:44 pm
Steve Jones - SSC Editor (2/2/2011)
GilaMonster (2/2/2011)
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
February 2, 2011 at 4:42 pm
Jason, Gus, Brandie, Wayne and Stefan. How do you want to be credited in tran log article? Blog link? twitter handle? Both? Neither? something else?
Please let me know by friday...
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
February 2, 2011 at 3:20 pm
I'm planning on picking up an iPad on Friday. Was going to get in Canada, but they're finally available for sale here.
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
February 2, 2011 at 3:09 pm
You have a damaged page in your sharepoint content database. It's the integrity check that's failing here, not the backup.
I don't suppose you have a backup from before this started?...
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
February 2, 2011 at 1:57 pm
Just one thing, there is not and never has been a SQL 2005 R2. The only version that got an R2 was SQL 2008.
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
February 2, 2011 at 1:54 pm
Errrr.... why the cursor?
IF ( @caseNbr IS NOT NULL )
BEGIN -- get all the active parties on the cases entered
...
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
February 2, 2011 at 1:48 pm
scott_lotus (2/2/2011)
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
February 2, 2011 at 9:59 am
See http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
For table and indexes, just the create scripts. If you have management studio, right click the table/index script-> Create to -> clipboard then paste into reply.
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
February 2, 2011 at 9:55 am
Oh, time to hack the database back in and see if that will help.
http://sqlskills.com/BLOGS/PAUL/post/Disaster-recovery-101-hack-attach-a-damaged-database.aspx
If you get it 'attached', check the state (select name, state_desc from sys.databases), then post back with...
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
February 2, 2011 at 9:06 am
It is possible.
The question is, do you know better than the query optimiser for every and all possible parameter values what index is best?
Have you exhausted every other possible fix?
Have...
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
February 2, 2011 at 9:03 am
Maybe, but you'll need to delete the log file from the database that you created (the one whose mdf and ndf you overwrote). SQL knows that log doesn't belong to...
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
February 2, 2011 at 8:58 am
Will take a look at this tomorrow (if I get a chance). I have asked if any of the other regulars here would be able to take a look.
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
February 2, 2011 at 6:31 am
Does anyone have thoughts on this? bit more complex than I have time for right now.
http://www.sqlservercentral.com/Forums/Topic1057262-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
February 2, 2011 at 6:28 am
Dave Ballantyne (2/2/2011)
questionhacker , is certainly on my 'one to watch' list.http://www.sqlservercentral.com/Forums/Topic1057295-391-1.aspx
Based on the latest post, maybe black list rather than watch list
http://www.sqlservercentral.com/Forums/FindPost1057413.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
February 2, 2011 at 6:27 am
Viewing 15 posts - 27,976 through 27,990 (of 49,552 total)