By Steve Bolton
…………One of the major thrusts of my various mistutorial series has been to drive home the point that...
2019-02-14 (first published: 2019-01-25)
2,264 reads
This is the sequel to “It’s always parameter sniffing (part 1).” In that post, we identified the stored procedure, and...
2019-02-14 (first published: 2019-01-23)
2,513 reads
It’s a week to my webinar with Donovan Brown (bt, yg), leader of the League of Extraordinary Cloud DevOps Advocates,...
2019-02-14
228 reads
Please see https://sqlundercover.com/undercover-catalogue-0-2/ for full details on the Undercover Catalogue and how to obtain it.
We’ve spotted an issue where unicode...
2019-02-14
123 reads
Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know...
2019-02-13
187 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2019-02-13 (first published: 2019-01-24)
2,216 reads
Shrink log file for log_reuse_wait_desc =...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-02-13
10 reads
Shrink log file for log_reuse_wait_desc =...
[[ This is a content summary only. Visit my website for full links, other content, and more!...
2019-02-13
129 reads
It’s taken longer than I thought it may and I’ve run into several problems along the way but had a...
2019-02-13
218 reads
In Partitioning 1, my query searched through all 1-12 partitions. Let’s see if we can reduce that number.
Adding the partitioning...
2019-02-13
1,636 reads
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers