June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Whitepaper – Using the Resource Governor

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Download, SQL White Papers
Using the Resource Governor SQL Server Technical Article Writer: Aaron Bertrand, Boris Baryshnikov Technical Reviewers: Louis Davidson, Mark Pohto, Jay (In-Jerng) Choe Published: June 2009 SQL Server 2008 introduces a new feature, the Resource Governor, which provides enterprise customers the ability to both monitor and control the way different workloads…
Read More

SQL SERVER – Restore Sequence and Understanding NORECOVERY and RECOVERY

Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Data Storage, SQL Restore, SQL Scripts, SQL Server

I maintain a spreadsheet of questions sent by users and from that I single out a topic to write and share my knowledge and opinion. Unless and until I find an issue appealing, I do not prefer to write about it, till the issue crosses the threshold. Today the question that crossed the threshold is – what is the difference between NORECOVERY and RECOVERY when restoring database and what is the restore sequence.

Read More