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...
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
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.
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
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...
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
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.
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
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...
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
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...
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
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...
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
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)
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
December 24, 2009 at 12:44 am
stephen.rice 10158 (12/23/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
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...
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
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...
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
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...
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
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?
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
December 23, 2009 at 11:34 am
CirquedeSQLeil (12/23/2009)
Next question is: Who has mentally checked out for the holidays?
*raises hand*
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
December 23, 2009 at 11:10 am
James Lavery (12/23/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
December 23, 2009 at 11:05 am
Viewing 15 posts - 35,101 through 35,115 (of 49,552 total)