Pinal Dave - SQL Server Performance Tuning Expert

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

September 5, 2009

SQL Error Messages, SQL Replication, SQL Scripts

Error 3724 stops you from dropping a database once used for replication. My simple fix: back up an empty database with the same name and force a restore.

Three wooden specimen trays hold leaves, seed pods and stones beside a magnifying glass.

PERCENTILE_DISC: Return an Observed Percentile Value

September 4, 2009

Pinal Dave

SQL Tips and Tricks

SQL Datatype, SQL Function, SQL Server

PERCENTILE_DISC selects from the supplied observations. Preserve duplicates and distinguish an observed threshold from an interpolated value.

A rich painting of a grocer studying three fruit baskets and two fruit pairings on a sunlit counter.

Data Mining: A Simple Introduction and a SQL Basket Example

September 3, 2009

Pinal Dave

SQL Tips and Tricks

Business Intelligence, Data Warehousing, SQL Server

Market-basket analysis turns purchases into measurable product relationships. Deduplicate products within each order, calculate support, confidence and lift in T-SQL, and interpret the counts before drawing conclusions from a small sample.

SQL SERVER – Mirrored Backup and Restore and Split File Backup – Introduction

September 2, 2009

Pinal Dave

SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Scripts, SQL Server

Backup and Restore lessons from my consulting work: conventional backups, split file backups, mirrored backups and the FORMAT clause, each with an example.