Installing SQL Server 2014 Language Reference Help from disk
Some weeks ago I had to wipe my machine and reinstall everything from scratch, SQL Server included.
For some reason that I...
2014-09-25
977 reads
Some weeks ago I had to wipe my machine and reinstall everything from scratch, SQL Server included.
For some reason that I...
2014-09-25
977 reads
Who is Mike in the business intelligence/analytics world?
Is it Mike White? If it is, he’s the guy I call for...
2014-09-25
1,076 reads
I learned a hard lesson when I first started as a DBA. Although to be honest, it’s not a lesson...
2014-09-30 (first published: 2014-09-25)
7,268 reads
Notes:
We sent out a final you haven’t paid for lunch reminder on Wed, asked for a reply if they were...
2014-09-25
491 reads
I said that I’d write about some good things PASS does, and I’ll make it a point to do so....
2014-09-29 (first published: 2014-09-25)
6,909 reads
Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...
2014-09-25
1,131 reads
Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...
2014-09-25
2,620 reads
About six months ago, I wrote a post reviewing a book titled The Phoenix Project. In that post, I compared...
2014-09-25
502 reads
SQL Server 2014 Cardinality Estimator
The SQL Server 2014 cardinality estimator has been improved to increase the quality of SQL Server query...
2014-09-25
1,003 reads
As a DBA, it is perfectly normal to forget your password from time to time. No need to hold your breath...
2014-09-25
558 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