Moving Lookup Data with ReadyRoll
I’ve been using ReadyRoll for a small project and wanted to move some lookup data. There are some tables where...
2018-02-19 (first published: 2018-02-08)
1,955 reads
I’ve been using ReadyRoll for a small project and wanted to move some lookup data. There are some tables where...
2018-02-19 (first published: 2018-02-08)
1,955 reads
I was reminded of this topic after yesterday’s #SQLChat. Have you set professional goals for yourself? If so, have you...
2018-02-16 (first published: 2018-02-08)
2,106 reads
Do you ever need to use a text editor to apply regular expressions to files? If so, this post is for you! If not, you may wanna skip it...
2018-02-08
42 reads
For the last 7 years, I have been speaking at the PASSSummit. This event is usually in Seattle, but one...
2018-02-08
333 reads
While we’re on the topic of SQL Server Reporting Services: WHYYYYYY is the Reporting Service Configuration Manager so hard to...
2018-02-07
453 reads
More and more companies are considering a move to the cloud, but one aspect of such a migration that may...
2018-02-07
344 reads
Back to the SQL Server Basics with Wayne
Connecting to a SQL Server instance is one of the first things that...
2018-02-19 (first published: 2018-02-07)
2,913 reads
Tom Roush The SQL Family lost a much admired member to cancer last month, Tom Roush. In our little community,...
2018-02-07
406 reads
We Speak Linux
I am super excited to be to have launched this website. We Speak Linux is a place for...
2018-02-07
125 reads
A few years ago I wrote what would turn out to be my most-hit blog post (so far) titled "Error...
2018-02-07
421 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