Freigeben über


SQL Scratchpad

Query Performing Slow When Issued Against A Partitioned Table

  Recently, when I was working with one of our customer, I came across an interesting issue....

Date: 09/03/2014

“AddNode” operation while setting up SQL 2005 Cluster fails with an error: “Error String : The setup has encountered an unexpected error while Preparing Installation Wizard. The error is: Fatal error during installation. Error Number : 29528”

  Recently, I was working on one of the customers on an issue. The resolution is simple but I...

Date: 07/10/2014

Why is it important to close the keys after retrieving the data from an encrypted table, using Cell level encryption?

When we use cell level encryption, we usually create a symmetric key, do the encryption and close...

Date: 03/29/2014

How to store the SQLBPA recommendations in a SQL database to make more use out of the recommendations data

Lot of us use SQL Best Practices Analyzer (BPA) to detect any potential errors, warnings,...

Date: 03/17/2014

Restore Database from a UNC path – Why SSMS doesn’t show network drives/paths in the restore wizard

Lot of times we get into a situation where we need to restore databases from backup files (.BAK)...

Date: 03/11/2014

SQL 2012 cluster installation fails with disk resource can’t be moved error

When I was working with one of the customers on SQL server 2012 failover cluster installation, we...

Date: 03/11/2014