SQL Server sample databases
Here are some places on the web where you can find sample databases for SQL Server. It’s nice to have...
2014-02-24
236 reads
Here are some places on the web where you can find sample databases for SQL Server. It’s nice to have...
2014-02-24
236 reads
The “Perfectly Optimized” Page infographic states that there is no such thing as a “Perfect Page”. But don’t be discouraged!...
2014-02-24
943 reads
A few years back, I put together a blog series on SQL Server Integration Services (SSIS) titled 31 Days of SSIS....
2014-02-24
1,310 reads
A long time ago, in a galaxy far, far away….
About ten years ago, I realized I was spending more than...
2014-02-24
842 reads
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-02-24
1,054 reads
Accenture and DataStax have signed an alliance agreement, formalizing their longstanding collaboration in helping clients manage and drive insights from...
2014-02-24
615 reads
SQL Server is a software product, right? And software has a history of having bugs, getting updates, and having support...
2014-02-24
590 reads
Here’s a list of free presentation software I ran across, maybe worth a few minutes to get out of the...
2014-02-24
739 reads
I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the...
2014-02-24
1,115 reads
We’ve probably all heard the famous quote by John Wanamaker, the father of modern advertising: “Half the money I spend...
2014-02-24
1,056 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
Comments posted to this topic are about the item Adding Bits I
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