Stuart Davies


Blogs

Renaming Files by Padding Numbers with PowerShell

By

Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...

When do Statistics get updated?

By

Statistics objects are important for allowing the SQL Server Optimizer to make good estimates...

Power BI: Making Date & Time Keys

By

Saving the Day from Delay Part 2 Creating DateKey and TimeKey columns can be...

Read the latest Blogs

Forums

Intermittent "nesting level exceeded" error

By julian.fletcher

We're having a very peculiar problem with the "Maximum stored procedure, function, trigger, or...

Selecting last 6 months

By sqlErik

Hi, I need to select rows from the last 6 months prior to the...

Nested loop/HashJoin and left/right/full join

By 892717952

1. What is the difference among nested loop?hash join and merge join? 2. what...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers