Using a Filtered Index to Enforce Filtered Uniqueness
One of the advantages and uses of Filtered Indexes (introduced with SQL Server 2008) is to provide filtered uniqueness. Obviously...
2014-05-06 (first published: 2014-04-24)
2,179 reads
One of the advantages and uses of Filtered Indexes (introduced with SQL Server 2008) is to provide filtered uniqueness. Obviously...
2014-05-06 (first published: 2014-04-24)
2,179 reads
I have run into this before, but not in this same way, so I decided it would be worth writing...
2014-05-05 (first published: 2014-04-23)
3,427 reads
If you are near Pittsburgh, PA on May 22, 2014 catch the following all-day training session from 8:30 AM to 4:00...
2014-04-23
1,019 reads
I introduced Azure Automation in a previous post. I’ve spent some more time exploring it.
There’s a set of documentation available...
2014-04-23
1,386 reads
I started reading about collations after I had a recent run in with them. As I read I started to...
2014-04-23
550 reads
I started reading about collations after I had a recent run in with them. As I read I started to...
2014-05-02 (first published: 2014-04-23)
2,404 reads
Practical Data Migration Strategies
As organizations mature their IT infrastructure must change to keep up with new applications and technologies. Many...
2014-04-23
1,338 reads
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-23
1,092 reads
I am excited about being selected to speak and attend the May 3rd SQLSaturday BA Edition in Dallas, TX. There...
2014-04-23
760 reads
This is a followup to a previous post where I likened SQL Server float datatype to Muhammad Ali. Specifically, I...
2014-05-01 (first published: 2014-04-23)
2,972 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...
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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