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,841 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,922 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,519 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,561 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,495 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,971 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,632 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,308 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,561 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,812 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers