The Lighter Side


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


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 …)


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

ANSI_WARNINGS = OFF can break update statements with some SQL features


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

Read the latest Blogs


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


SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Auto Rounding

See possible answers