Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Reasons to Backup Master Database – Why Should Master Database Backedup

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices, SQL Backup and Restore, SQL Data Storage, SQL Server Security, SQL Utility
The most interesting thing about writing blog at SQLAuthority.com is follow up question. Just a day before I wrote article about SQL SERVER – Restore Master Database – An Easy Solution, right following it, I received email from user requesting reason for importance of backing up master database. Master database…
Read More

SQL SERVER – Start SQL Server Instance in Single User Mode

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio, SQL Server Security, SQL Utility
There are certain situation when user wants to start SQL Server Engine in “single user” mode from the start up. To start SQL Server in single user mode is very simple procedure as displayed below. Go to SQL Server Configuration Manager and click on  SQL Server 2005 Services. Click on…
Read More

SQL SERVER – 2008 – Download Microsoft SQL Server 2008 Express with Tools Free

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, SQL Download, SQL Server Express, SQL Utility
Note: Download Microsoft SQL Server 2008 Express with Tools Free by Microsoft SQL Server 2008 Express Edition was much awaited version of SQL Server 2008. It is FREE and available to download from web. Microsoft SQL Server 2008 Express with Tools (SQL Server 2008 Express) is a free, easy-to-use version…
Read More

SQL SERVER – Find Number of Rows and Disk Space Reserved – Using sp_spaceused Interesting Observation

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Data Storage, SQL Function, SQL Scripts, SQL Server DBCC, SQL Stored Procedure, SQL Utility
Previously I posted SQL SERVER – Find Row Count in Table – Find Largest Table in Database – T-SQL. Today we will look into the same issue but with some additional interesting detail. We can find the row count using another system SP sp_spaceused. This SP gives additional information regarding…
Read More