A SQL Server Hardware Nugget A Day – Day 8
For Day 8 of my SQL Server hardware series, I want to give my current recommended Intel Processor List for...
2011-04-08
429 reads
For Your Friday Enrichment: Get Alifeatoll
I have made something for your pleasure and entertainment, and placed it on the MidnightDBA YouTube Channel. Please to enjoy...
2011-04-08
517 reads
Notes for Moving BizTalk’s Databases
Yesterday, I was tasked with helping a team move their BizTalk databases to another server. These are my notes for...
2011-04-08
1,440 reads
Confessions of a DBA - Part 1
Couple of year's back I brought the SQL Server down to its pathetic knees by using a HINT. Yes, with...
2011-04-08
1,510 reads
SQL Server, Storage and You
Just a note that I will start my three part webcast, SQL Server, Storage and You next week April 13th...
2011-04-08
1,012 reads
Powershell Day 8
Day 8 Event Viewver Event log is a very important trace and diagnose the activity on the system. Using Event...
2011-04-08
225 reads
An Appeal to Those Writing Training Documentation and Labs
I'm coming to the end of a week of training in a Microsoft Official Curriculum (MOC) Course. I should expect...
2011-04-08
934 reads
Upcoming Events
If live in Central/South Florida or are planning a trip, we’ve got several IT community events worth checking out…
May
SQLRally in...
2011-04-08
555 reads
Presenting Dr. DMV by Live Meeting on April 19 at 12PM CDT
I will be presenting my Dr. DMV presentation for the St. Louis SQL Server User’s Group on April 19. Here...
2011-04-07
1,140 reads
A SQL Server Hardware Nugget A Day – Day 7
For Day 7 of this series, I will talk about the incredibly useful CPU-Z utility, which is available for free...
2011-04-07
1,322 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