How many mirrored databases can I have on a server?
How many mirrrored databases can I have on a server?
10 mirrored databases per server is the recommendation for a 32...
2008-11-18
6,441 reads
SQL Server Soldier :: News from the frontlines of the database wars
Deleting Duplicates without a unique key
The following was sent to me by my friend and colleague Dave Miller:
Dave's Email:
Wanted to pass along something I hadn't...
2008-08-21
1,632 reads
What every DBA that manages a large number of SQL Servers should know about SQL 2008!!
Error when importing RegServer list from SQL 2005 to SQL 2008
I discovered the already known bug in SQL 2008 that...
2008-08-19
3,092 reads
How do I automatically respond to mirrored database failovers?
Automatic Failover - an incomplete solution
Automatic failover with Database Mirroring is great, but what about all of the other things that...
2008-08-18
2,103 reads
How do I .... grant access permissions for SSIS to users?
SSIS access permissions are managed via Component Services. It is the DCOM object named MSDTSServer. Here are the steps to...
2008-08-13
46,025 reads
I've got a date with an Error Log -- Error Logs Part II
Error Logs Part II -- Enumerating the error logs
In my first post on SQL Server Error Logs, I briefly mentioned using...
2008-04-25
1,758 reads
Shhhh!! Be vewy, vewy quiet. I'm hunting Select *!!
"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it is...
2008-03-28
1,447 reads
Shhhh!! Be vewy, vewy quiet. I'm hunting Select *!!
Who's bad?
"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it...
2008-03-28
1,533 reads
The Shadow Knows What Procedures Lurk in the SQL Plan Cache
How do you know what procedures are cached in SQL Server? Simple, just ask, and SQL Server will tell you.You...
2008-03-28
1,479 reads
Suggested Reading: Deadlock Notifications in SQL Server 2005
Here's a good article on setting up Deadlock Notifications in SQL Server 2005 written by Patrick LeBlanc.
2007-10-16
1,486 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