Yakov Shlafman


The Best Kept Secret About SQL Query Analyzer

It has been nearly 5 years since SQL Server 2000 was released and almost seven since Query Analyzer was introduced in SQL Server 7. Surely every trick, tip, technique, or secret has been published by now? Perhaps, but this might be a new one from Yakov Shlafman. Check out what he thinks is the best kept secret.

4.29 (14)

2006-01-27 (first published: )

76,693 reads

Blogs

When Read Committed Snapshot Goes Bad – Version Store Filling TempDB

By

We all had those calls, it’s the middle of the night and we get...

Daily Coping 17 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

#PowershellBasics: Finding a common AD group for a set of users.

By

A while back (almost 7 years ??) I wrote a post on finding the...

Read the latest Blogs

Forums

UniqueIdentifier as Primary Key, non-clustered index, fragmentation issue

By oRBIT

I've been working a little bit with a few tables here, they've got "CreatedDate"...

Multiple deadlocks occuring on simultaneous deletions from temporal table

By zoggling

We have a stored procedure which is attempting to delete 1-2 rows at a...

Foreign key for Xml Datatype

By IT researcher

Is foreign key constraint possible in xml data type? OR Is it possible to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers