Grant Fritchey

Execution Plans: First Operator

The first time you see a new execution plan that you’re examining to fix a performance problem, something broken, whatever, you should always start by looking at the first...

2020-01-14 (first published: )

471 reads


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


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...

cardinality estimation

By MVDBA (Mike Vessey)

Just a quick question I'm putting in a new SQL 2019 server and an...

Attribute in the hierarchy display as one value

By Charmer

Hello Friends, I want to display the attributes in a hierarchy as one value...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Auto Rounding

See possible answers