Viewing 15 posts - 35,101 through 35,115 (of 49,552 total)
Active-active is two SQL instances, one running on each node, each one using the other one's node as it's passive failover. Hence you can look at it as two active-passive...
December 27, 2009 at 6:07 am
A transaction can only be committed in the session that it was started in. From another connection all you can do is kill it, which forces a rollback.
December 27, 2009 at 6:06 am
A clustered index scan doesn't have to be in the order of the clustered index. It's just a read of all1 of the leaf pages of the table. Two ways...
December 27, 2009 at 6:06 am
I suggest (as I did in the article), half an hour to an hour, once a week. Longer than that and it gets cumbersome to analyse.
December 24, 2009 at 5:45 am
rashmigangurde (12/24/2009)
plz send me the link for SQL server 2000 and 2004 dumps
I take it you didn't read (or just ignored) my comment above. Using dumps is cheating and using...
December 24, 2009 at 5:44 am
Ben Kentzer (12/24/2009)
This second database is set up with the Simple recovery model, and so the log entries are essentially lost once committed which is fine.
Well, the log records will...
December 24, 2009 at 1:31 am
Export/import, transactional replication, custom solution using Change Tracking or Change Data Capture. None of them are going to be pleasant. Backups cannot be restored to SQL 2000, that includes transaction...
December 24, 2009 at 12:47 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
December 24, 2009 at 12:44 am
stephen.rice 10158 (12/23/2009)
December 24, 2009 at 12:43 am
Ben Kentzer (12/24/2009)
If I insert data via the view, which database gets the transaction log entry?
The one that's got the table.
What gets logged are data changes. Since views (ignoring...
December 24, 2009 at 12:41 am
chris.worthington (12/23/2009)
It could be completely unrelated but a vendor recently installed an online disk defrag tool on our RAID device where this particular database lives.
Uninstall it or disable it. Then...
December 23, 2009 at 2:21 pm
The end of file message refers to the hidden snapshot that CheckDB takes. It's not affecting the mdf file itself (if it was, CheckDB would find a lot more than...
December 23, 2009 at 1:36 pm
Grant Fritchey (12/23/2009)
Fighting with a messed up development deployment. I love when developers mix up scripts from multiple versions of the database.
Time to fetch the chain-saw?
December 23, 2009 at 11:34 am
CirquedeSQLeil (12/23/2009)
Next question is: Who has mentally checked out for the holidays?
*raises hand*
December 23, 2009 at 11:10 am
James Lavery (12/23/2009)
December 23, 2009 at 11:05 am
Viewing 15 posts - 35,101 through 35,115 (of 49,552 total)