I’m Speaking! Quad Cities PASS User Group
I always have a special place in my heart for the SQL Server user groups of the mid-west. I ran...
2017-08-09
329 reads
I always have a special place in my heart for the SQL Server user groups of the mid-west. I ran...
2017-08-09
329 reads
SqlServer Powershell Cmdlets 2017 - Initialize Look
Diving into the Sql Server Management Objects library can be a pretty interesting process. You...
2017-08-09
1,143 reads
I was fresh off the boat* from South Africa, working in a small computer store in an equally small town...
2017-08-09
166 reads
I’m very honored to be able to announce that I am going to be speaking at IT/Dev Connections in San...
2017-08-09
193 reads
I’m very honored to be able to announce that I am going to be speaking at IT/Dev Connections in San...
2017-08-09
339 reads
In this module you will learn how to use the Quadrant Chart Custom Visual. The Quadrant Chart is used to...
2017-08-09
646 reads
In today’s continuation of the SQL / Oracle series, I thought it’d be nice to show how different the two are...
2017-08-09
310 reads
We know that we need to keep our credentials secure. We know that we should not re-use our passwords across...
2017-08-09
1,603 reads
I recently came up against a SQL Server instance that wouldnt start, after going through the event log the reason...
2017-08-09
259 reads
As mentioned in Part 1 of this “SQLCLR vs. SQL Server 2017” series, the new clr strict security server-level configuration...
2017-08-09
983 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