Working with the registry from within SQL Server
There is a lot of information within the Windows registry. Sometimes, it would sure be nice to work with the...
2017-08-30 (first published: 2017-08-16)
3,825 reads
There is a lot of information within the Windows registry. Sometimes, it would sure be nice to work with the...
2017-08-30 (first published: 2017-08-16)
3,825 reads
For the longest time, MySQL has been the recommended database platform for blogs and other websites. It’s free. It’s available...
2017-08-16
167 reads
If you do – shame on you and shame on me because I do.
Moving on, I found strange behaviour within SQL...
2017-08-16
395 reads
Now that SSDT (SQL Server Data Tools) has been installed the next step is to create a project. First, open...
2017-08-30 (first published: 2017-08-16)
1,903 reads
It’s Wednesday and that means another SQL/Oracle post. Today we’ll be discussing NULL Values, which can sometimes be a real...
2017-08-28 (first published: 2017-08-16)
9,478 reads
Last week I presented my session on SQL Server & Containers for the PASS Virtualization Group and during my prep I...
2017-08-28 (first published: 2017-08-16)
2,980 reads
Welcome back, everyone. In the previous post in this series, I explained how to work within the new SQLCLR security...
2017-08-16
725 reads
As a developer, I’ve been a big fan of multiple monitors for a long time. I moved to a triple...
2017-08-15
271 reads
Watch this week's video on YouTube
How many times have you had to transform some column value and ended up stacking several nested SQL REPLACE() functions like this?
-- Input: Red,...
2017-08-15
24 reads
This post demonstrates one of the ways to gather an inventory of database backup information. The output of the script...
2017-08-15
451 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