Stranger Danger… The need for trust with constraints
I ran into an issue with errors with an database upgrade running into a violation of a foreign key constraint....
2015-08-13
438 reads
I ran into an issue with errors with an database upgrade running into a violation of a foreign key constraint....
2015-08-13
438 reads
Power BI is becoming popular for a lot of reasons. Simply put, Power BI is “BI on your fingertips.” Companies looking to...
2015-08-13
1,239 reads
In the world of performance monitoring, there a number of ways to identify problems. Each method is different and usually, neither...
2015-08-13
726 reads
Whoa whoah. Aren’t you supposed to increase your data flow buffer size in order to speed up your packages? If...
2015-08-13
815 reads
Earlier today I was working on a project where I was recording some time stamps. In order to get as...
2015-08-13
595 reads
Through this article, we are going to discuss three important interview questions of SQL which are given below:-
1) Can we create clustered index on a column containing duplicate values?
2) Can we create...
2015-08-13
20 reads
Through this article, we are going to discuss three important interview questions of SQL which are given below:-
1) Can we...
2015-08-13
6,991 reads
Part of a Series on "Hekaton". Refer below for previous posts
Introduction to Hekaton - Part 1Creating a Hekaton Database - Part 2
Having...
2015-08-13
608 reads
This is one of the challenge for most of the developer to write dynamic SQL. Generally we follow the approach...
2015-08-12
1,294 reads
Continuation from the previous 61 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have spoken a lot of times...
2015-08-12
574 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