Viewing 15 posts - 33,166 through 33,180 (of 49,552 total)
Schema stability locks are taken by every single query (select, insert, update, delete) to ensure that the structure of the table doesn't change while they are running. The only thing...
April 23, 2010 at 4:40 am
There's a GO right before the last END. Since GO is a batch breaker, that terminates the CREATE TRIGGER statement and leaves an orphaned END at the end.
April 21, 2010 at 1:14 pm
Adi Cohn-120898 (4/21/2010)
I think that you’ll have to use some third party products such as Lumigent’s Log explorer or Red Gate’s SQL Log Rescue.
Log rescue doesn't work on SQL...
April 21, 2010 at 2:22 am
shen-dest (4/21/2010)
for a high-loaded system profiler might be a problem.
Server side trace to fast local drive is usually ok even on heavily loaded systems. Profiler GUI, not so much.
April 21, 2010 at 2:16 am
shen-dest (4/21/2010)
sys.dm_exec_query_stats --execution_count
Bear in mind that that DMV is flushed when the DB is closed, queries can be removed from cache and it is possible they'll never appear in...
April 21, 2010 at 1:47 am
Pretty much, yes.
A lower fill factor helps reduce/prevent page splits from insert or update operations (not deletes), but the downside is that the index takes more pages, hence more...
April 21, 2010 at 1:35 am
No. Operations that are minimally logged in bulk-logged are minimally logged in simple recovery too. In bluk logged you have to additionally worry about log backups.
Besides, updates are not minimally...
April 19, 2010 at 12:04 pm
Danny Sheridan (4/19/2010)
EXEC sp_dboption 'db_name', 'trunc. log on chkpt.', 'TRUE'
That option was deprecated back before SQL 2000. It should not be used any more and the replacement is Simple recovery.
April 19, 2010 at 11:52 am
I'd suggest upgrade to at least SP3, if not SP3 + latest Cumulative Update (CU). I know there was a bug recently (in last 12 months) found related to these...
April 19, 2010 at 11:50 am
You're lucky.
Now, take measures to ensure that it can't happen again - tighten file system security, remove unnecessary permissions/logins, and make sure that administrators understand that the log file is...
April 19, 2010 at 8:59 am
This should help.
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
It's for SQL 2005+, but the steps are pretty much the same for SQL 2000, except for the emergency mode repair. You should be able to find...
April 19, 2010 at 8:26 am
That will work for certain, specific types of schema corruption, it may not work for this one, as I commended several posts back.
p.s. You did notice that this thread is...
April 15, 2010 at 4:19 am
1) If the clustered index is disabled, the table is inaccessible and cannot be queried at all.
2) It's mentioned in the article, under 'What is a nonclustered index'
3) Fill factor...
April 15, 2010 at 4:15 am
RBarryYoung (4/13/2010)
Grant Fritchey (4/13/2010)
Roy Ernest (4/13/2010)
Where is Gail? I havent seen her... Anyone has any news?
She's doing fine. We've exchanged email a bit. She's busy working on her masters thesis....
April 13, 2010 at 10:40 am
Roy Ernest (4/13/2010)
Where is Gail? I havent seen her... Anyone has any news?
Taking a long, long break from the forums. Stuff's getting on my nerves and it wass getting to...
April 13, 2010 at 10:36 am
Viewing 15 posts - 33,166 through 33,180 (of 49,552 total)