Nicholas Williams


sp_what

Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z.

*Dont you just love totally non subjective assessments like this?

4 (5)

2018-11-01 (first published: )

2,023 reads

Blogs

Using SQL Compare for One Procedure

By

A customer recently was concerned about the time to run SQL Compare for a...

Daily Coping 11 June 2021

By

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

Azure SQL Database – Secondary Database and Tiers

By

On the theme of failover groups let’s do a quick recap on my environment....

Read the latest Blogs

Forums

Tracking, Privacy, and Lots of Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Tracking, Privacy, and Lots of...

Why am I seeing logical reads on insert into #tmp table

By schleep

Here's the table definition. There are no indexes nor constraints on it. CREATE TABLE...

Special type of Deadlock

By sqlenthu 89358

Hello SQL experts, I am facing an issue where a process gets deadlock and...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers