June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Plan Caching and Schema Change – An Interesting Observation

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Cache, SQL Documentation, SQL Profiler, SQL Scripts, SQL Server Management Studio, SQL Stored Procedure, SQL Utility, SQL White Papers
Last week, I had published details regarding SQL SERVER – Plan Caching in SQL Server 2008 by Greg Low on this blog. Similar to any other white paper, I have read this paper very carefully and enjoyed reading it. One particular topic in the white paper that caught my attention…
Read More

SQL SERVER – Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Spatial Database, SQL Documentation, SQL Download, SQL White Papers
Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet SQL Server Technical Article Writers: Isaac Kunen Project Editor: Diana Steinmetz Published: July 2008 I recently read this very interesting white paper. I really found it very interesting as this one was one very easy to read and humourous…
Read More

SQLAuthority News – Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.2

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Download
This download package is intended for Microsoft Premier Customers Only. This package includes all of the scoping tools necessary to prepare and qualify your environment to receive a Risk and Health Assessment Program for Microsoft SQL Server. Download Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool…
Read More

SQL SERVER – FIX – ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Replication, SQL Scripts
I have set up replication at many different organization. One error I quite commonly face is after I have removed replication I can not remove database. When I try to remove the database it gives me following error. Cannot drop the database because it is being used for replication. (Microsoft…
Read More