Precons in Richmond, Philadelphia and New York
I love when I get the opportunity to present at SQLSaturday events. Even more than that, I love when I...
2018-03-09 (first published: 2018-02-28)
1,679 reads
I love when I get the opportunity to present at SQLSaturday events. Even more than that, I love when I...
2018-03-09 (first published: 2018-02-28)
1,679 reads
With the Automating Database Deployment: Part 3 Running RoundhousE post we walked through running a RoundhousE deployment for the first time to create the database and several database objects. Script naming...
2018-02-28
80 reads
If you are a Sr DBA or developer you have probably had some variation of this conversation at multiple points...
2018-02-28
421 reads
You can watch on YouTube now: https://www.youtube.com/watch?v=0qyMutBkZsg
If you want slides and notifications, register on the Redgate hub.
We’re recording the sessions...
2018-02-28
850 reads
When working with partitioning the SWITCH operation has to be my favourite. The ability to move a large amount of...
2018-02-28
3,161 reads
Last week I spoke about a world wary data type for storing dates and times in a single column, with...
2018-02-28
1,083 reads
Situation Your query is waiting for another query and the other query is doing nothing. Blocking Locks A blocking lock...
2018-02-28
257 reads
Situation Your query is waiting for another query and the other query is doing nothing. Blocking Locks A blocking lock...
2018-02-28
518 reads
I’ve been doing that thing called DevOPs for about 17 years – you know – before it had a name…
In fact it...
2018-02-28
1,277 reads
SQL Server 2017 introduces a set of useful functions like STRING_AGG(), STRING_SPLIT(), TRIM()… and many more. In this tip, I am...
2018-02-28
9,385 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
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...
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