Designing and Implementing Online Analytical Processing (OLAP) Architecture – (Part 2)
SQL Server allows applications and users to execute full- text search queries against character based data in SQL Server tables....
2013-08-06
949 reads
SQL Server allows applications and users to execute full- text search queries against character based data in SQL Server tables....
2013-08-06
949 reads
Normalization, which is the key part of the OLTP databases logical design process, is a design requirement for OLTP databases....
2013-08-06
575 reads
Time has flown by and we’re just five weeks from SQLSaturday #232 on September 14th, 2013. It’s a time of...
2013-08-06
571 reads
What are the advantages of using SSAS Cubes over a regular data warehouse for reporting? Note I’m not asking why...
2013-08-06
1,692 reads
I had a very unpleasant experience a while back when I was commenting anonymously on a web site (not SQL...
2013-08-06
607 reads
Recently I installed the Android version of the Overdrive Media Console on my Nexus 7. It’s a free app. Install...
2013-08-06
792 reads
Deadlocks are rough to work with. Here are the scripts I use to capture deadlocks, find which ones are reoccurring,...
2013-08-06
2,096 reads
If you're using a Windows phone, versions 7.8 or 8, there is a new security advisory out with respect to...
2013-08-06
633 reads
Test your SQL Server knowledge in a fun and unique way with this exclusive crossword.
2013-08-06
22 reads
When there’s something worth celebrating, such as a birthday or achieving the Microsoft Certified Master (MCM) SQL Server certification, I like...
2013-08-08 (first published: 2013-08-06)
1,468 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
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