Columnstore Indexes – part 94 (“Use Partitioning Wisely”)
Continuation from the previous 93 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post will talk about some...
2017-01-06
588 reads
Continuation from the previous 93 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post will talk about some...
2017-01-06
588 reads
Happy New Year to all of you out there! I know, I know it’s a week late but hey I’ve...
2017-01-06
347 reads
As SQL developer, you must have often come across a scenario where you need to remove the empty spaces at...
2017-01-06
2,090 reads
For those of you on the Denver SQL Server User Group e-mail list, you probably heard the news I am...
2017-01-05
358 reads
If you're lucky enough to have SQL Server 2016, go on and upgrade to SP1....you get extra-lucky special database snapshots...
2017-01-05
625 reads
At last year’s SQL in the City, I played the part of a manual DBA making changes and deploying those...
2017-01-12 (first published: 2017-01-05)
1,569 reads
Have you ever heard the phrase “Hold The Fort”? Long ago in battle supply routes were targeted by enemy regiments...
2017-01-12 (first published: 2017-01-05)
1,342 reads
With 2017 starting this week I would like to take a moment and reflect on 2016. I have to admit that 2016 was a great year for many different...
2017-01-05
16 reads
With 2017 starting this week I would like to take a moment and reflect on 2016. I have to admit...
2017-01-05
439 reads
I’ve been studying Azure recently and came across a really interesting Azure site.
resources.azure.com
To give you an idea why I find...
2017-01-13 (first published: 2017-01-05)
1,469 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