Check Query Progress with Live Query Stats

• by Matthew McGiffen

• Matthew McGiffen DBA

This is something I touched on back in 2017 a little after the Live Query Statistics feature was introduced with SQL 2016, but I was using the functionality this...

2019-09-18

25 reads

SQL Server Wishlist

• by Matthew McGiffen

• Matthew McGiffen DBA

This month for T-SQL Tuesday Kevin Chant asks us what our fantasy SQL feature would be. https://www.kevinrchant.com/2019/09/03/t-sql-tuesday-118-your-fantasy-sql-feature/ I think it’s appropriate to give a shout-out to Microsoft at this...

2019-09-11

49 reads

Query Store stores dates as UTC

• by Matthew McGiffen

• Matthew McGiffen DBA

One of the powerful aspects of Query Store is the ability to directly query the DMVs for details of historical executions and performance. A key view for this is...

2019-09-04 (first published: 2019-08-21)

186 reads

The 99 Flavours of SQL Server are all Vanilla

• by Matthew McGiffen

• Matthew McGiffen DBA

There are so many options for running SQL Server now. It can feel a little intimidating.  You’ve spent years gaining experience with SQL running on Windows Server. On bare...

2019-09-03 (first published: 2019-08-22)

456 reads

Find queries with high memory grants – using Query Store

• by Matthew McGiffen

• Matthew McGiffen DBA

I had a server that looked like it had been suffering from memory contention. I wanted to see what queries were being run that had high memory requirements. The...

2019-08-14 (first published: 2019-07-31)

530 reads

Adding a Column with a Default Constraint

• by Matthew McGiffen

• Matthew McGiffen DBA

Last week a question came up about adding a column to a table, and giving that column a default constraint. Would that default value be assigned to all existing...

2019-07-24 (first published: 2019-07-16)

379 reads

T-SQL Tuesday #114 Puzzle Party – Roundup

• by Matthew McGiffen

• Matthew McGiffen DBA

Here’s my round-up for this month’s T-SQL Tuesday. Thanks to everyone who contributed last week. It was great reading your posts and seeing the different ways you interpreted the...

2019-05-21

74 reads

T-SQL Tuesday #114 – Puzzle Party

• by Matthew McGiffen

• Matthew McGiffen DBA

A few years back I started running regular SQL workshops in my workplace. Teaching beginners the basics of querying databases with SQL, as well as more advanced topics for...

2019-05-07

84 reads

Attending a climate protest for the first time

• by Matthew McGiffen

• Matthew McGiffen DBA

This is a blog devoted to databases, but for once I’m going to go off topic and talk about something I did at the weekend that I’ve never done...

2019-04-25

8 reads

MAXDOP, Parallelism and the Cloud

• by Matthew McGiffen

• Matthew McGiffen DBA

Parallelism and MAXDOP The pros and cons of parallelism have always been with us in SQL Server and I blogged about this a couple of years ago. This is...

2019-04-18 (first published: 2019-04-03)

1,025 reads