Viewing 15 posts - 37,831 through 37,845 (of 49,566 total)
What's the exact error that you get?
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...
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******...
July 8, 2009 at 9:10 am
Steve Jones - Editor (7/6/2009)
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...
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...
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...
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.
July 8, 2009 at 2:37 am
That means that those particular operators are running in parallel.
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...
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....
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...
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
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...
July 7, 2009 at 2:46 pm
Not all errors roll the transaction back. You should use begin transaction and rollback/commit if it needs to be an atomic operation (all succeeds or none succeeds)
On 2005, Try.. catch...
July 7, 2009 at 10:40 am
Viewing 15 posts - 37,831 through 37,845 (of 49,566 total)