Hawaii is Not Prometric Microsoft Certification Test Friendly
While I was at TechEd last week, I got a 50% off Microsoft Certification test voucher that expires on June...
2010-06-15
1,498 reads
Building A Remote Desktop Manager Connection List
Remote Desktop Connection Manager or RDCMan is a free download from Microsoft for managing multiple remote desktop connections. The functionality...
2010-06-15
2,331 reads
Sarasota SQL Server Users Group
Tonight I’m presenting for the Sarasota SQL Server Users Group. If you’re interested in attending, you can join in using...
2010-06-15
713 reads
The Value of an Artist
A short while ago someone complained that some of the headlines on SSC were deceiving in terms of what they...
2010-06-15
663 reads
Teaching ICT 4462 – Transact SQL Programming at Denver University, University College
I will be teaching a special five week version of ICT 4462 – Transact SQL Programming at Denver University, University College...
2010-06-15
632 reads
DBA Hell
On the first day of DBA hell, the server gave to me
A database with damaged system tables and no good...
2010-06-15
968 reads
Virtualizing Servers in Production
The company where I work has been using virtualization in development, QA, testing, etc., for many years now. We have...
2010-06-15
879 reads
Daily SQL Server 2008 New Features – Day 23
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-15
423 reads
SQL Server XML Schemas
Ever been curious about the schema of , say an SSRS rdl file ? How about the execution plan ?
Not only should...
2010-06-15
499 reads
Networking – A Year Later
I was excited to attend the networking session last year at the PASS Summit. Andy Warren and I had talked...
2010-06-15
665 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