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)
541 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)
695 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)
433 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,201 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
31 reads
By Jen McCown
Friends, the MidnightDBAs have a plan for 2022. A capital-P Plan. And it involves...
By Steve Jones
I was doing a little work with CosmosDB recently, and there were a few...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Now recover the Excel password by using this world famous Excel Unlockers software which...
Hi All I have 1 TB database and i cant shrink it as it...
Ask SSC