SQL University Lecture Series: Women in Tech
This week SQL University is on Spring Break but we’ve lined up some activities to help keep students busy (you...
2011-03-16
662 reads
24 Hours of PASS: Day 1
Yesterday was the first day of PASS’ 24 Hours of PASS event. For those not familiar, 24 Hours of PASS is...
2011-03-16
769 reads
Disaster Recovery Exposure - Part Two
In part one, I gave a general overview of some of the things that may affect IT services in the...
2011-03-15
542 reads
Disaster Recovery Exposure. - Part One
G'day,
I've just readPaul Randal's sqlmag article about the need to test your disaster recovery strategy. In that article Paul mentions...
2011-03-15
1,167 reads
The MCM is Worldwide
Well, not everywhere, but as long as Prometric sites meet some security requirements, they can offer the MCM tests. I...
2011-03-15
841 reads
Has Microsoft Desktop Virtualization Reached The End Of The Road?
I'm a big proponent of using Virtual Machines for development on your local machine. It just doesn't make sense to...
2011-03-15
615 reads
24 Hours of PASS Spring 2011 Code Sins
Here is all the things related to the most awesome Code Sins session I gave at 24 Hours of PASS Spring...
2011-03-15
677 reads
Boulder SQL Server User’s Group Meeting
I will be presenting at the Boulder SQL Server User’s Group (BSSUG) on March 15, 2011. My presentation will be...
2011-03-15
526 reads
March 2011 S3OLV Meeting Recap
The Las Vegas SQL Server Users Group met on March 10, 2011. The meeting was both virtual and in-person. Good news – we had just about as many person...
2011-03-15
12 reads
March 2011 S3OLV Meeting Recap
The Las Vegas SQL Server Users Group met on March 10, 2011. The meeting was both virtual and in-person. Good...
2011-03-15
713 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