Speaking at PASS Summit and why you need to think about submitting….
This post is about the honor and experience of speaking at PASS Summit not once (2016) but twice (2017).
I recently...
2018-01-29
400 reads
This post is about the honor and experience of speaking at PASS Summit not once (2016) but twice (2017).
I recently...
2018-01-29
400 reads
2017 was an awesome year for SQLDusty.com! Thank you to all of the readers and visitors that stopped by to...
2018-01-29
413 reads
[read this post on Mr. Fox SQL blog] Recently I had a requirement to collate and briefly compare some of the various methods to perform SQL Server backup for...
2018-01-28
32 reads
[read this post on Mr. Fox SQL blog]
Recently I had a requirement to collate and briefly compare some of the...
2018-01-28
1,146 reads
Over the last several weeks, we have been making several changes to various settings in SSMS. Now that you have...
2018-01-28
405 reads
Houston, We Have a Problem
We are living in a crazy world. And it just gets more and more crazy all...
2018-01-28
884 reads
When you are performance tuning code, you will frequently examine the execution plans to see what is happening. As you...
2018-01-27
471 reads
Earlier this week the folks at PASS reached out to last year’s speakers asking us to share a story of...
2018-01-27
145 reads
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2018 on the conference runs from April 9th 2018 through April 12th 2018. This is...
2018-01-27
10 reads
I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2018 on the conference runs from April...
2018-01-27
351 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