June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – SQL Server Health Check Service – Speed UP SQL Server

Pinal Dave
Personal, SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News
Best Practices, Database, SQL Index, SQL Scripts, SQL Training
In my earlier article SQLAuthority News – Training and Consultancy and Travel – Story of Last 30 Days I had mentioned that I prefer to do 50% consultation and 50% training. Since then I often receive what do I do consultation for and what is my expertise. I am basically…
Read More

SQL SERVER – Plan Cache – Retrieve and Remove – A Simple Script

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Server

I had a very interesting situation at my recent performance tuning project. I realize that the developers there were running very large dataset queries on their production server randomly. I got alarmed so I suggested their developer not to do that on the production server; instead, they could create some alternate scenarios where they could synchronize database and query on the same server. The production server should not be used for development work. It should be queried with proper methods (queries, Stored Procedures, etc.), supporting production application.

Read More