Columnstore Indexes – part 88 (“Minimal Logging in SQL Server 2016”)
Continuation from the previous 87 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Getting Data into the Database is one...
2016-10-22
597 reads
Fixing Untrusted Foreign Key or Check Constraint
Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax.If...
2016-10-22
246 reads
Fixing Untrusted Foreign Key or Check Constraint
Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax....
2016-10-22
1,256 reads
If You Read One Article About Split String in SQL SERVER 2016s Read this One #3
In the Series of SQL SERVER 2016, this is another post. Before Jumping in detail just think if you have...
2016-10-22
970 reads
VMworld Europe 2016 Wrap Up
This past week I had the pleasure of attending our first VMworld Europe conference, held this week at the Fira Gran Via in...
2016-10-21
732 reads
Meet and Greet Data Pros at #sqlsummit
Next Monday night is the networking dinner that Andy Warren and I have put together for the last 6 years....
2016-10-21
502 reads
#RedgateRocks at the PASS Summit
If you are attending the PASS Summit next week in Seattle, and want to attend a fun party on Thursday...
2016-10-21
500 reads
How O’reilly Picks Sessions
Read this and wanted to share as we head to the PASS Summit next week: This is how we do it:...
2016-10-21
435 reads
Notes on Designing an After Hours Event for the PASS Summit
This year we’re trying out two ideas on Thursday night, a networking dinner (of a sort) and game night. I...
2016-10-27 (first published: 2016-10-20)
666 reads
Syncing QA data with Production
Applies to: xSQL Data Compare v7.0.0 and higher
WARNING: this article focuses on the data transfer / synchronization task and does not address operation security issues and sensitive data scrubbing /...
2016-10-20
68 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Adding Bits I
Comments posted to this topic are about the item Adding Bits I
Question of the Day
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