DevOps Basics – Ignoring Files in Git
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-30
1,523 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-30
1,523 reads
Are you using your Model Database to its full potential?
I am finding more and more that Database Admins are not...
2017-10-30
754 reads
Have you ever had a query change performance unexpectedly? Intellisense all of a sudden stops working, or gives inconsistent results?...
2017-10-30
684 reads
From time to time it is necessary to find a way into an SSIS package that is password protected. This article will help you find your way in to...
2017-10-30
61 reads
A recurring theme over the past several weeks (there are always recurring themes it seems) has been an issue that...
2017-10-30
1,372 reads
One of the most common mistakes I see made when creating tables (and I’ve been guilty of this myself too...
2017-10-29
568 reads
Continuation from the previous 113 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost is focusing on the unsung...
2017-10-29
724 reads
Last summer, I heard about an awesome idea for speaker gifts at SQLSat Pensacola 2017 from organizer Karla Landrum and...
2017-10-29
627 reads
I have left the heat and humidity of Singapore where I have been presenting at the PowerShell Conference Asia and...
2017-10-29
617 reads
It’s on! Free registration at EventBrite.
I wrote last month about not being able to make it to Seattle on Monday...
2017-10-29
608 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