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