Aug 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Restore Database Without or With Backup – Everything About Restore and Backup

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Backup and Restore, SQL Download, SQL Scripts
The questions I received in last two weeks: “I do not have backup, is it possible to restore database to previous state?” “How can restore the database without using backup file?” “I accidentally deleted tables in my database, how can I revert back?” “How to revert the changes, I have…
Read More

SQL SERVER – Microsoft White Papers – Analysis Services Query Best Practices – Partial Database Availability

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, SQL Download, SQL White Papers
Microsoft TechNet frequently releases White Papers on SQL Server Technology. I have read the following two white papers recently. The summary of its content is here. Analysis Services Query Performance Top 10 Best Practices Optimize cube and measure group design Define effective aggregations Use partitions Write efficient MDX Use the…
Read More

SQL SERVER – 2005 – Microsoft Document Explorer cannot be shown because the specified help collection ‘ms-help://MS.SQLCC.v9

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Download, SQL Error Messages, SQL Scripts, SQL Utility
I have received six emails in last four days asking for the resolution of error when tried to open newly installed SQL Server Book On-Line. Microsoft Document Explorer cannot be shown because the specified help collection ‘ms-help://MS.SQLCC.v9 1) Uninstall the versions of Book On-line (different languages, different releases etc) using…
Read More

SQL SERVER – 2005 Best Practices Analyzer Tutorial – Sample Example

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, Database, SQL Download, SQL Scripts, SQL Utility
Yesterday I posted small note about SQL SERVER – 2005 Best Practices Analyzer (July BPA). I received many request about how BPA is used. Some of readers has asked me to provide sample tutorial which can help start using BPA. This utility has many uses for best practice. I have…
Read More