Nicholas Williams


Technical Article

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,153 reads

Blogs

Power BI Meets Programmability – TOM, XMLA, and C#

By

For anyone who read the title of this and immediately thought, “Oh no, I...

Do Full Backups Break Log Shipping?

By

TLDR: Nope. Keep on doing your full backups. Make sure that any databases you...

Daily Coping 15 Oct 2021

By

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

Read the latest Blogs

Forums

SSRS Zero-Day patching?

By tacy.highland

Hello all, I've been tasked (rather randomly) with finding out if there is somewhere...

Informatica -SQL Error

By premkuttan

We get a sql connection from host informatica server and the query runs in...

Last Successful Completion Date for SQL Job

By AMCiti

I am trying to write a query to get a list of all SQL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers