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
81 reads
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)
542 reads
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)
286 reads
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)
714 reads
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)
435 reads
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
90 reads
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
87 reads
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
10 reads
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-26 (first published: 2019-04-03)
2,207 reads
When you drop a database from a SQL Server instance the underlying files are usually removed. This doesn’t happen however if you set the database to be offline first,...
2019-03-27
37 reads
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Foreword In the second part of this...
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Now that your CFS has been setup it’s time to get the word out...
Hi guys I have a query with a SELECT statement, that joins 2 other...
Hi all, Can someone please help Pivot a table. The table currently looks like...
Hello Community, Can someone please help transpose a table. The table currently looks like...
Ask SSC