April Version of SQL Server 2008 Diagnostic Queries
I have added two new queries to this month’s version, to try to collect some more hardware information about the...
2011-04-11
500 reads
Blog Posts
Cloud computing – not without risk?
Interesting quote from Sharepoint Best Practices Conference :” 17% of IT Pros think benefits of cloud computing outweigh the risks”!!
That’s not...
2011-04-11
831 reads
Hostettler the Viking Needs a New Ship and Your Help
Hostettler the Viking Needs a New Ship…And Your Help.
My good friend Justin Hostettler Davies (Blog@DBExpertise) pinged me a mail in...
2011-04-11
588 reads
If you truly want to understand something try and change it.
I saw this quote on facebook last week and it really hit close to home. I had just started working...
2011-04-11
695 reads
Limit Results Based on Aggregated Threshold
Problem
A post was recently added to one of the forums that I monitor so that I can help users in...
2011-04-11
1,717 reads
Powershell Day 11
Day 11 COM and WMI Powershell is a very powerful language, with Powershell we can achieve same result with the...
2011-04-11
923 reads
Slides & Samples for my SQLbits session
As announced in both of my sessions, you can download the slides & samples for
my SQLbits sessions here:
Message
in a Bottle: Service...
2011-04-11
762 reads
SQLBits Attendance Breaks Previous Records
How many people can you identify in the above photo from the closing party at SQLBits? Can you find Ola...
2011-04-11
1,361 reads
SSIS Job Ownership
I was strolling along one day when I saw somebody asking how to find out who owns a maintenance plan. That evolved into finding out who owns the the...
2011-04-11
34 reads
SSIS Job Ownership
I was strolling along one day when I saw somebody asking how to find out who owns a maintenance plan....
2011-04-11
1,128 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