I recently encountered a requirement to estimate the size of (a lot of) nonclustered indexes on some very large tables due to not having a test box to create...
2021-08-13 (first published: 2021-08-01)
244 reads
While testing a script that involved calculating index record size recently I was getting some confusing results depending on server version, and after some digging it appears there was...
2021-07-28
11 reads
Hopefully not many people are still configuring SSIS instances on SQL 2012 or 2014 – especially HA instances – but if you are, this post is for you. If...
2021-05-28
24 reads
Blocking in SQL Server can be good – after all, it’s one of the ways consistency is guaranteed – we usually don’t want data written to by two processes...
2021-05-24 (first published: 2021-05-13)
577 reads
This month’s T-SQL Tuesday is hosted by Andy Leonard who has poised the question ‘What do you do when technology changes underneath you?’ I was going to begin by...
2021-05-11
6 reads
I recently encountered a SSIS package that was failing due to an ‘arithmetic overflow error converting IDENTITY to datatype int’; Conversion/overflow errors aren’t that unusual – normally a data...
2021-04-06
3 reads
A quick PSA on the behaviour of Serverless Azure SQL DB space reporting in the Azure Portal. I recently had to shrink a large Azure SQL DB for cost...
2021-03-31
10 reads
Hopefully you already know everything about your SQL estate, including what services are installed and what’s running them, either because it’s so small you just know, or, preferably, you...
2021-03-15
3 reads
By Rayis Imayev
(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists...
By Steve Jones
Data Masker for SQL Server is a great tool ensuring the data you use...
I find myself doing more and more work with containers. Yet, I also find...
Hi all. I’m not even sure if this is the right section to post...
Hi all, My understanding about the structure of data within SQL Server is that...
Hi, I am using SQL 2016 (13.0.5888.11). Last Saturday (18th September), in non-office hours,...
Ask SSC