Convert comma separated string to table and vice versa
I know that this subject has been blogged about numerous times but I thought I'd post an alternative way of...
2012-02-07
18,792 reads
S3OLV – Get your Merge On
We are rapidly closing in on the February meeting for S3OLV. You might remember reading about the upcoming meeting here. We are looking to have an excellent meeting this...
2012-02-07
11 reads
S3OLV – Get your Merge On
We are rapidly closing in on the February meeting for S3OLV. You might remember reading about the upcoming meeting here.
We...
2012-02-07
644 reads
Freedom
Not too long ago, I blogged about a Book called Daemon. Freedom is the sequel to Daemon. I enjoyed reading this book. The story continues from Daemon, but in...
2012-02-07
22 reads
Freedom
Not too long ago, I blogged about a Book called Daemon. Freedom is the sequel to Daemon.
I enjoyed reading this...
2012-02-07
721 reads
Opt In/Out of Personalized Microsoft Ads
Nice to have the option, you can opt-out (default is in) of having personalized ads. I turned it off, the...
2012-02-07
827 reads
Avoiding Bad Query Performance
There’s a very old saying, “When you find yourself in a hole, stop digging.”
And my evidence today is:
That’s certainly not...
2012-02-07
1,213 reads
LAST_VALUE() Analytic Function–SQL Server 2012
Earlier, i discussed FIRST_VALUE() function. FIRST_VALUE() returns the first value from an ordered set of records. Similarly LAST_VALUE() returns the last...
2012-02-07
2,710 reads
PIPE CLIP – (| CLIP)
The main focus of this blog is to write about SQL Server related stuff – but now and then in the...
2012-02-07
798 reads
Webcast: Successfully Meeting Your Audits for SQL Server
Tomorrow at 3 PM Eastern I'll be giving a webcast in conjection with Idera and MSSQLTips.com:
Registration for Successfully Meeting Your...
2012-02-07
1,015 reads
Blogs
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Forums
Adding new column with DEFAULT II
Comments posted to this topic are about the item Adding new column with DEFAULT...
Advanced Deployment Scenarios: Stairway to Reliable Database Deployments Level 7
Comments posted to this topic are about the item Advanced Deployment Scenarios: Stairway to...
You Need a DBA Pipeline
Comments posted to this topic are about the item You Need a DBA Pipeline
Question of the Day
Adding new column with DEFAULT II
Which number did the two COUNT(*) return:
DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp (id INT NOT NULL) INSERT INTO #tmp (id) SELECT gs.value FROM GENERATE_SERIES(1, 5) AS gs ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1 SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1 ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1See possible answers