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,379 reads
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,379 reads
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,601 reads
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,077 reads
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,075 reads
SSIS access permissions are managed via Component Services. It is the DCOM object named MSDTSServer. Here are the steps to...
2008-08-13
45,102 reads
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,734 reads
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,520 reads
"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it is...
2008-03-28
1,438 reads
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,462 reads
Here's a good article on setting up Deadlock Notifications in SQL Server 2005 written by Patrick LeBlanc.
2007-10-16
1,467 reads
By Zikato
In SQL Server, using the KILL command to terminate a session results in an...
In today’s data-driven world, having the right tools to manage and process large datasets...
By Steve Jones
flichtish – adj. nervously aware how much of your self-image is based on untested...
I took a backup with the CHECKSUM option, which was successful and showed no...
Comments posted to this topic are about the item Realities of Predictive Analysis
Just came across something weird. Was wondering if anyone else has ever seen this....
I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?
See possible answers