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)
687 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)
432 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
89 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
86 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
8 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-18 (first published: 2019-04-03)
2,186 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
27 reads
The SEQUENCE object was added to T-SQL in SQL Server 2012. It’s reasonably well known to DBAs, but less so...
2019-03-12 (first published: 2019-02-20)
2,263 reads
I’ve recently encountered an issue that was difficult to resolve and I didn’t find the particular cause that was troubling...
2019-02-28 (first published: 2019-02-12)
2,920 reads
When I’ve created resources in Azure it’s usually taken from a few minutes and up to quarter of an hour...
2019-02-26
824 reads
One of the frequently quoted ETL best practices is to disable your non-clustered indexes...
By kleegeek
I hope you’re all enjoying the latest rev of the Microsoft Ignite conference as...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
We are running SQL Server 2017 (RTM) on Windows. The question came up, if...
I'm having an issue with a database that I recently moved from SQL 2014...
We are setting up this thread to welcome questions and comments about the latest...
Ask SSC