Introduction to SQL Server Execution Plans
Watch this week’s episode on YouTube! I nearly always use execution plans as the starting point for SQL query performance troubleshooting. In this multi-part series, I plan to review...
2019-07-23
244 reads
Watch this week’s episode on YouTube! I nearly always use execution plans as the starting point for SQL query performance troubleshooting. In this multi-part series, I plan to review...
2019-07-23
244 reads
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
I nearly...
2019-07-23
32 reads
Watch this week's video on YouTube
Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans
I nearly...
2019-07-23
22 reads
This post continues looking at some of the Kubernetes concepts I’ve been learning with the 50 days of Kubernetes (K8s). Specifically in this post, I’m writing and thinking about...
2019-07-22
40 reads
2019-07-22
29 reads
Below are the top 15 questions I am seeing from customers looking to build a modern data warehouse in the cloud, and the blogs that I have wrote that...
2019-07-22
981 reads
I’ve always said if you’re running a script for the first time in a production environment, you’re doing it wrong. Testing is fundamental to technology, yet it is one...
2019-07-22
32 reads
I have a lot of co-workers who use sp_who and sp_who2 to see who’s in a given database. This is ... Continue reading
2019-07-22
315 reads
Another week passed. Look what did I find during that time. Press British Airways faces record £183m fine for data breach The penalty imposed on BA is the first...
2019-07-22
27 reads
This blog post is around the changing landscape of both SQL Server and the people who are our trusted guardians of it – DBAs. If you have been involved...
2019-07-22
305 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers