What is the Role of the UPDATE Lock in SQL Server?
The most common types of locks in SQL Server are the SHARED (S) lock and the EXCLUSIVE (X) lock. The...
2017-11-18
1,427 reads
The most common types of locks in SQL Server are the SHARED (S) lock and the EXCLUSIVE (X) lock. The...
2017-11-18
1,427 reads
This tweet showed up in the dbatools Slack channel Friday afternoon.
Just did my first Pull Request to "contribute" to @psdbatools. Granted, the code change was a single line of...
2017-11-18
15 reads
The last month has been a rough one for me, with lots of travel. I was on trips for 4...
2017-11-17
1,015 reads
I started speaking on a semi-regular basis this year after many years of trepidation. You can read about my first...
2017-11-17
316 reads
Back in July, I gave a webcast for Idera’s Geek Sync. They’ve published the recording. You can find it here:
Take...
2017-11-17
455 reads
Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error that is vague, we sometimes find ourselves wanting to...
2017-11-17
52 reads
Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error...
2017-11-17
343 reads
I am delighted to announce that I’ll be delivering my full-day course, Building Better SSIS Packages, at the SQLBits conference...
2017-11-17
370 reads
On Wednesday Microsoft Announced the release in preview of SQL Operations Studio (SOS)... What is that I hear you cry!...
2017-11-17
638 reads
Fun week, lots of stuff to organise and prepare for! Whilst I’ve had some downtime I’ve been reading…
Write your first...
2017-11-17
306 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