Interesting answer. Just to be clear, that means that the first record with the non-unique value goes into the database, and the second goes to the error output, correct?

Actually I have a server with about 50 databases (out of about 100 on the instance) I want change from daily backups to weekly backups within the backup solution we...

This was just passed to me yesterday. My part would be to do the SQL part of rebuilding the cluster node once the OS is reinstalled. Apparently the hardware guy...

Mystery solved:

Our Network Security group was running a scan that attempted to connect using the port SQL uses for database mirroring. Since the connect request was not a valid...

But wouldn't altering it from master open the possibility of a another connection coming before the RESTORE command takes exclusive access?

Don't you love how Windows 8.1 and Windows 6.3 are the same thing?

In the scenario you describe, if you shrink your database after deletes it will only grow again during inserts. The time it takes to do the shrink adds time...

I think there's some confusion between Clustering on an OS level and a SQL Clustered instance.

Yes, you can install standalone instances on a Windows Server that is part of a...

In traditional failover clustering, there is one set of disks hosting the database files that are passed from one node to another, either when the failover process is manually launched...

I think the difference between system databases and user databases is that SQL Server will fail to come online if the system databases are corrupt or inaccessible (or in the...

One way is to have data encryption/decryption at the application level. However this has it's disadvantages - namely limiting the viewing of the data to the application...

If you set the maximum size of the MDF file to it's current size, it will stop further growth and force new data to be written to the NDF on...

Without clustering, a motherboard failure could mean that an application is unavailable for hours or days. With failover clusters the downtime for this event could be several minutes as...

I never suggested that a weekly shrink job on a production database was a sound practice. I just thought that the commandment "NEVER shrink a database!" was a bit too...

I'm surprised that discussions of whether or not to keep an index seldom include a look at what is generating the query using the index and how important speed is...