Speaking at IT/DevConnections 2017
If you’re going to be in the San Francisco area in October, let’s get together and talk. I’ll be at...
2017-09-13
353 reads
If you’re going to be in the San Francisco area in October, let’s get together and talk. I’ll be at...
2017-09-13
353 reads
Ever wander around SQL Server properties and wonder what these little check boxes turn on? I do, and I get...
2017-09-13
373 reads
If you’re working for a big company, chances are that your IT already has a strategy and tools for dealing...
2017-09-13
999 reads
The PASS board elections are coming up and there is a twitter chat event to ask questions to the candidates before you vote. Both tweeter events will be on...
2017-09-13
15 reads
The PASS board elections are coming up and there is a twitter chat event to ask questions to the candidates...
2017-09-12
516 reads
I was creating and dropping VMs in Azure, and found myself charged money for disks that I thought I’d deleted....
2017-09-12
510 reads
SQL Server functionality can move on pretty quickly sometimes, and it’s not always all about the big features but the...
2017-09-12
2,381 reads
As a SQL Server DBA, do you need to be a master of PowerShell scripts? In this 9 minute episode, I talk about how much you need to know...
2017-09-12
37 reads
Invariably, either while building a new database, or while maintaining old ones, you will find that the business needs change...
2017-09-12
450 reads
This month’s T-SQL Tuesday is hosted by Rob Sewell (b|t) and surprise, surprise, it focuses on Powershell so I thought...
2017-09-12
415 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