Docker images for custom SQL Server Installations
I no longer install SQL Server on my workstation, I use Docker to spin up instances as and when I...
2017-08-22
1,834 reads
I no longer install SQL Server on my workstation, I use Docker to spin up instances as and when I...
2017-08-22
1,834 reads
Unexpected SQL Server Performance Killers #3
Watch this week's video on YouTube
In this series I explore scenarios that hurt SQL Server performance and show you how to avoid them. Pulled...
2017-08-22
42 reads
Capturing query execution metrics is much easier now that you can see the runtime metrics in execution plans when you’re...
2017-08-22
262 reads
Capturing query execution metrics is much easier now that you can see the runtime metrics in execution plans when you’re...
2017-09-06 (first published: 2017-08-22)
1,619 reads
I thought I’d do another chess puzzle this month. This one is a variant on the Eight Queens problem:
SQL Puzzle...
2017-09-01 (first published: 2017-08-22)
2,358 reads
I am so excited to be helping out with SQL Saturday Charlotte again this year. This is the 6th year...
2017-08-22
415 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-08-22
241 reads
One of the more common questions I find in SQL Server SSIS forums is how to split apart a single...
2017-08-22
493 reads
In the previous posts I posted some questions that I usually get when we talk about getting certified with SQL Server also listed some resources you can use to...
2017-08-21
20 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-21
506 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