12 Days of Christmas 2013 Day 1
Last year I did a mini-series themed around the 12 Days of Christmas. I am going to do a similar series this year. Over the next 12 days, I...
2013-12-25
9 reads
12 Days of Christmas 2013 Day 1
Last year I did a mini-series themed around the 12 Days of Christmas. I am going to do a similar...
2013-12-25
589 reads
Christmas Day Winner and RDC Clients: Day 13
Finally we'll see who won the final training prize! The winner is Komal! Merry Christmas and Happy Holidays to everyone! The free...
2013-12-25
519 reads
Question of the Week -25/12/2013- Question1
Suppose we have a table says tbl_students whose structure is given below:-
Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))
Suppose it contains...
2013-12-25
478 reads
Ranking Functions in SQL Server
Ranking Function:- Sometimes we need to provide a Row number to the rows in a table or within a partition....
2013-12-25
9,964 reads
MDX Implementing Logical AND On Members of the Same Hierarchy
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli In my prior blog post, I discussed implementing logical OR in MDX on members of...
2013-12-24
25 reads
MDX Implementing Logical AND On Members of the Same Hierarchy
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli In my prior blog post, I discussed implementing logical OR in MDX on members of...
2013-12-24
34 reads
MDX Implementing Logical AND On Members of the Same Hierarchy
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli
In my prior blog post, I discussed...
2014-01-01 (first published: 2013-12-24)
1,884 reads
2013-12-24
585 reads
The 12 days after release
On the first day after release my developer gave to me
a performance problem on a crucial query
On the second day...
2013-12-24
798 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