Columnstore Indexes – part 98 (“Null Expressions & String Aggregates”)
Continuation from the previous 97 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing with the spirit of the previous...
2017-02-15
475 reads
Continuation from the previous 97 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing with the spirit of the previous...
2017-02-15
475 reads
I’ve been testing and working with SQL Clone for the last few months, trying to help the devs at Redgate...
2017-02-20 (first published: 2017-02-15)
1,632 reads
Logging into the Azure portal is a daily task of mine and my eyes light up when I see features...
2017-02-15
344 reads
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-02-21 (first published: 2017-02-14)
6,960 reads
Today is yet another T-SQL Tuesday – the monthly blogging party started by Adam Machanic (b|t) to get everyone in the...
2017-02-14
451 reads
Welcome to T-SQL Tuesday #87 being hosted this month by Matt Gordon (blog|@sqlatspeed). This month’s topic is “Fixing Old Problems...
2017-02-14
701 reads
Thanks to Matt Gordon (@atsqlspeed) for hosting this T-SQL Tuesday.
Splitting Strings in SQL
A problem that has plagued SQL developers through...
2017-02-14
449 reads
This post is a response to this month's T-SQL Tuesday prompt. T-SQL Tuesday was created by Adam Machanic and is a way for SQL users to share ideas about...
2017-02-14
46 reads
Sometimes you have a requirement to grant permissions to every database on an instance. Historically this has required creating a...
2017-02-14
743 reads
In this module you will learn how to use the Mekko Chart Power BI Custom Visual. The Mekko Chart visual...
2017-02-14
886 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