PASS 2012 Countdown – 3 Weeks To Go
Another week down and there are now 3-weeks until this year’s PASS Summit. Take a moment and register now if...
2012-10-17
1,752 reads
Another week down and there are now 3-weeks until this year’s PASS Summit. Take a moment and register now if...
2012-10-17
1,752 reads
Back on October 3, I put up a post about a free indexing book. And specifically about Expert Performance Indexing for...
2012-10-17
577 reads
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-17
641 reads
If you missed all the great speakers on the five city tour of SQL in the City, don’t despair. Many...
2012-10-17
1,151 reads
Inserted and deleted tables are 2 pseudo tables preseting the before and after images of modified rows. They can only...
2012-10-17
2,454 reads
A question that a DBA will often be asked is what databases are actively being used on my SQL Server?...
2012-10-17
3,608 reads
I haven’t seen this many fake ID’s since I was in college.
Back on April 26, Grant Fritchey (of execution...
2012-10-24 (first published: 2012-10-16)
5,144 reads
The 4thcumulative update release for SQL Server 2012 is now available for download at the Microsoft Support site. Cumulative Update...
2012-10-16
766 reads
Today I have uploaded the 4rd SQL Server Quickie to YouTube. In this episode I’m talking about IAM Pages in...
2012-10-16
647 reads
Today I have uploaded the 4rd SQL Server Quickie to YouTube. In this episode I'm talking
about IAM Pages in SQL...
2012-10-16
1,219 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...
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