Viewing 15 posts - 36,031 through 36,045 (of 49,562 total)
As far as I'm aware (haven't tested), with a single log file SQL may be able to recreate the log if it's deleted, with 2 or more, it won't. That...
November 4, 2009 at 7:24 pm
Oracle database? Is this an Oracle or SQL Server stored procedure?
November 4, 2009 at 11:40 am
jocampo (11/4/2009)
Normally, when there is only one log file, if its missing, SQL will recreate it.
Sometimes, not always. If the DB was not cleanly shut down, the log cannot...
November 4, 2009 at 11:35 am
Animal Magic (11/4/2009)
If a DB is in full recovery and...
November 4, 2009 at 11:23 am
Dave Ballantyne (11/4/2009)
1. The problem with this is that sqlServer will scan every row testing the logic, it wont shortcuit.
Providing there's an appropriate index, Column IN (Value1, Value2) will be...
November 4, 2009 at 11:17 am
Charles Kincaid (11/3/2009)
GilaMonster (11/3/2009)
What are you waiting for?Methinks he is waiting for your next installment.
Next week.
November 4, 2009 at 11:08 am
Roy Ernest (11/4/2009)
I wonder how the Kilt day is going in PASS... 🙂
Interestingly. Photos later.
November 4, 2009 at 11:07 am
sejal p gudhka (11/4/2009)
Suspect state tells that database is corrupted meaning either physical files or filegroups are damaged or logical entries in system tables has been corrupted.
Almost. A db can...
November 4, 2009 at 12:29 am
parthi-1705 (11/3/2009)
Reason for suspect databases in ms sql ,
Could be one of several. Look in the SQL error log. There will be entries in there saying why the DB is...
November 4, 2009 at 12:26 am
ra_leech (11/3/2009)
I have a problem I need to restore a database without restoring the associated Log Files..
Can't be done. Data and log files have to both be restored.
i would suggest...
November 4, 2009 at 12:23 am
shanu.hoosen (11/3/2009)
the shrinkfile will not help for this.it will reduce size if the log is full.
shrinkfile will reduce the size if the log is NOT full. If the log is...
November 4, 2009 at 12:18 am
farax_x (11/3/2009)
yes it helps but does not answer my question.
There is no one, single, always right answer to your question. Without knowing the queries that run against that table, there...
November 4, 2009 at 12:15 am
For monitoring space usage yes.
Fill factor is reduced to alleviate page splits and fragmentation.
November 3, 2009 at 5:00 pm
All data modifications take an exclusive lock.
Locks can be at the row, page, extent or table. Never part of a row.
Exclusive locks are held until the end of a transaction....
November 3, 2009 at 4:59 pm
Viewing 15 posts - 36,031 through 36,045 (of 49,562 total)