Database snapshots can take a long time to create
Database Snapshots Can Take a Long Time to Create
Believe it, it's true!! One of the big selling point for database...
2009-03-11
4,805 reads
SQL Server Soldier :: News from the frontlines of the database wars
Database Mirroring FAQ: Why is my mirror database in a restoring state?
Question: Why is my mirror database in a restoring state?
This question was asked on a technical discussion group. This is...
2009-03-06
39,904 reads
Database Mirroring FAQ: How do we handle transaction log maintenance for a mirrored database?
Question: How do we handle transaction log maintenance for a mirrored database?
This question was asked on a technical discussion group....
2009-03-04
23,463 reads
Database Mirroring FAQ: What would be the best practice to configure Failover Clustering and Database Mirroring?
Question: What would be the best practice to configure Failover Clustering and Database Mirroring?
This question is frequently asked in one...
2009-02-23
1,550 reads
Database Mirroring FAQ: Will the Mirror automatically fail back to the original Principal when it comes back online?
Question: Will the Mirror automatically fail back to the original Principal when it comes back online?
This question doesn't usually come...
2009-02-22
11,466 reads
How do I ... Determine Database Growth If I Am Not Tracking It? -- Error Logs Part III
How do I ... Determine Database Growth If I Am Not Tracking It?
If your database has grown considerably and you're not...
2009-02-20
5,963 reads
Database Mirroring FAQ: Why does Database Mirroring Monitor report that my mirror is disconnected?
Question: Why does Database Mirroring Monitor report that my mirror is disconnected?
This question was sent to a discussion list via...
2009-02-18
1,622 reads
Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?
Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?
This question was sent...
2009-02-17
2,126 reads
Database Mirroring FAQ: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online?
Question: If the principal fails while running in high performance mode, what options do I have for bringing the mirror...
2009-02-16
4,546 reads
How Do I Configure SSIS to Work With a Named Instance
How Do I Configure SSIS to Work With a Named Instance?
By default, SSIS (SQL Server Integration Services) uses the msdb...
2008-12-11
12,769 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers