The Lighter Side

Blogs

sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019

By

sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue...

Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)

By

Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Read the latest Blogs

Forums

Opening Azure database in SSMS

By DaveBriCam

I triad to open an Azure database in SSMS and it opens fine, I...

removing stretch on a restore

By MVDBA (Mike Vessey)

Hi We've been forced to use "Stretch" for some history tables where our existing...

SSMS Freezing when Editing SQL Agent Job Steps

By eclmam

I've spent several hours trying to overcome an odd technical bug on two SQL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Auto Rounding

See possible answers