Columnstore Indexes – part 92 (“Lobs”)
Continuation from the previous 91 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Since the very first version of the...
2016-11-27
612 reads
Continuation from the previous 91 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Since the very first version of the...
2016-11-27
612 reads
Data security is always one of the important points which can not be ignored. Nowadays if you are working for...
2016-11-27
935 reads
Dear All,
I am starting a YouTube channel for SQL Server and Microsoft Data Platform Technologies called "Data Channel". What this...
2016-11-26
424 reads
One of our SQL Server 2014 clusters was installed and after the install, my client told me that we are...
2016-11-26
220 reads
This post is in support of Tim Ford’s (blog|twitter) #iwanttohelp challenge. And also written because this has burned me twice in the past 3 months and by blogging about it,...
2016-11-26
18 reads
Today is the day after Thanksgiving. There are many things to be thankful so I decided to write a short...
2016-11-25
669 reads
I’ve been trying to get used to using the dbatools cmdlets in PoSh. They help me learn some PowerShell, but...
2016-12-02 (first published: 2016-11-25)
1,544 reads
Friday again so before I spend a weekend watching sci-fi movies, I’ll be reading:-
Virtue in the Virtual
Tony Davies discusses containerisation...
2016-11-25
491 reads
We all know what the sqlservr.exe and its importance, but have you noticed the size difference of the .exe when comparing...
2016-11-25
727 reads
Recently I have been working on a project where I needed to parse XML files that were between 5mb and 20mb in size. Performance was critical for the project,...
2016-11-24
30 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