COUNT, DISTINCT, and NULLs
Watch this week's video on YouTube
One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT) and DISTINCT interchangeably to get an idea of the...
2019-02-19
29 reads
Bert Wagner
COUNT, DISTINCT, and NULLs
Watch this week's video on YouTube
One thing I see fairly often (and am occasionally guilty of myself) is using COUNT(DISTINCT) and DISTINCT interchangeably to get an idea of the...
2019-02-19
44 reads
Parsing HTML in SQL Server
Watch this week's video on YouTube
Recently I was asked how to parse text out of an HTML fragment stored in SQL Server.
Over the next few seconds my brain processed...
2019-02-12
14 reads
Parsing HTML in SQL Server
Watch this week's video on YouTube
Recently I was asked how to parse text out of an HTML fragment stored in SQL Server.
Over the next few seconds my brain processed...
2019-02-12
10 reads
Parsing HTML in SQL Server
Recently I was asked how to parse text out of an HTML fragment stored in SQL Server.
Over the next few...
2019-02-12
2,675 reads
Why make?
This post is a response to this month's T-SQL Tuesday #111 prompt by Andy Leonard. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2019-02-12
25 reads
Why make?
This post is a response to this month's T-SQL Tuesday #111 prompt by Andy Leonard. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2019-02-12
12 reads
Optimizing for Ad Hoc Workloads
Watch this week’s episode on YouTube.
The execution plan cache is a great feature: after SQL Server goes through the effort...
2019-02-07 (first published: 2019-01-22)
2,235 reads
Automating Database Maintenance with Jess Pomfret and dbatools
Watch this week's video on YouTube
dbatools is one of the coolest community projects I've seen - it is amazing how many commands are available to help make managing your...
2019-02-05
15 reads
Automating Database Maintenance with Jess Pomfret and dbatools
dbatools is one of the coolest community projects I’ve seen – it is amazing how many commands are available to help...
2019-02-05
210 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Kantor Resmi BCA KCU PURWOKERTO Telp:0817°825°533
Telp/Wa 62817825533 Jl. Jend. Sudirman No.391 A, Brubahan, Purwanegara, Kec. Purwokerto Tim., Kabupaten Banyumas,...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
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