How Do I Analyze a SQL Server Execution Plan?
A query is slow, and you figure out how to collect the query execution plan. Now what? In this video, I talk “big picture” about what execution plans are,...
2017-09-22
61 reads
A query is slow, and you figure out how to collect the query execution plan. Now what? In this video, I talk “big picture” about what execution plans are,...
2017-09-22
61 reads
Hello!
2 posts in 1 day? When you’re hot, you’re hot!
I’m actually writing this one whilst I’m waiting for a BACPAC...
2017-09-22
368 reads
(AKA how I lost a morning)
Hello!
This morning I needed to update my version of SSDT, but before I could do...
2017-09-22
783 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-09-21
473 reads
In SQL Server, scaling out reads (i.e. using Active secondary replicas via AlwaysOn Availability Groups) is a lot easier than scaling out...
2017-09-21
748 reads
Introduction
At times a user may perform UPDATE operation or DELETE operation in SQL server database without applying the WHERE condition....
2017-09-28 (first published: 2017-09-21)
5,026 reads
I saw a short video from Grant Fritchey on the Redgate channel that shows how to cerate a snapshot in...
2017-09-21
820 reads
I really like the dbatools project. This is a set of PowerShell cmdlets that are built by the community and...
2017-09-29 (first published: 2017-09-20)
2,204 reads
I’ve been working with SQL Server for many years now, and up until recently, I assumed that rebuilding any clustered...
2017-09-20
455 reads
PASS is our community.
It may sound a little cliche, especially with the current political climate in the US and other...
2017-09-20
366 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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