Viewing 15 posts - 37,816 through 37,830 (of 49,552 total)
Lynn Pettis (7/8/2009)
Think, I do, that our True Relational Fanatic may have new persona here on SSC.Anyone else have thoughts on this? 😉
I think I'm staying out of that thread....
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
July 8, 2009 at 9:25 am
What's the exact error that you get?
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
July 8, 2009 at 9:22 am
hi_abhay78 (7/8/2009)
If you right click on say index seek symbol and select properties , you will find that this query is creating 9 worker 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
July 8, 2009 at 9:18 am
Lynn Pettis (7/8/2009)
GilaMonster (7/8/2009)
OKAJ I **WEKING CAWMED HOWM AND SAW TE UPDATE JEH? AWN I WSN LIKE WOOOT??? CO0L UPDATE3Z T0D4y PL**AXK? THWN IT WES A FREKING STWID TAWBS *********MUTEHR******...
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
July 8, 2009 at 9:10 am
Steve Jones - Editor (7/6/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
July 8, 2009 at 8:58 am
sanderstad (7/8/2009)
You can get the VCE (Visual Cert Exam test) from here:
Testking are braindumps - questions taken directly from the exam in violation of the rules. Using them is...
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
July 8, 2009 at 6:26 am
sanderstad (7/8/2009)
You can get the VCE (Visual Cert Exam test) from here:
Testking are braindumps - questions taken directly from the exam in violation of the rules. Using them is...
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
July 8, 2009 at 6:26 am
To everyone suggesting CheckDB, DBCC checkDB cannot be run on a database that is suspect.
ekknaveen: Check the SQL error log. There should be an indication in there as to why...
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
July 8, 2009 at 6:24 am
One of the databases has the auto-close option set to true. Set it to false for both.
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
July 8, 2009 at 2:37 am
That means that those particular operators are running in parallel.
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
July 8, 2009 at 2:35 am
I would start with READ COMMITTED. It's the default isolation level and most of the time is sufficient. Do some load testing, if you do have lots of blocking (and...
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
July 8, 2009 at 1:25 am
Sounds like you have some large transactions that need 20 MB of log space. Index rebuilds are a prime candidate, or a large data load.
20MB is tiny for a log....
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
July 8, 2009 at 1:05 am
hi_abhay78 (7/7/2009)
5) create database test on( NAME = test, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test.mdf' )for attach_force_rebuild_log..
Don't forget to run CheckDB afterwards to ensure that there's no physical or logical...
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
July 8, 2009 at 1:02 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic749033-147-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
July 8, 2009 at 12:16 am
Delete that 'fake' ldf that you created and then follow the advice given here.
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
The database is recovery-pending because it wasn't shut down cleanly. In that case the log file is...
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
July 7, 2009 at 2:46 pm
Viewing 15 posts - 37,816 through 37,830 (of 49,552 total)