Rant About Judges that Misunderstand the Role of a DBA
Part - 07 Exerpts from "The Tyranny of Bill-101" - Part 07
Commenting on how frustrating it is for DBAs to deal with...
2011-04-05
685 reads
This appears to be a system procedure..but it isn’t!
G’day,
Recently, I was browsing through my database server when suddenly under the “System Stored Procedures” folder of the master database...
2011-04-05
2,046 reads
Adding a processor_description column to sys.dm_os_sys_info in SQL Server Denali
I opened a new Connect Item today, asking Microsoft to add a new column to the sys.dm_os_sys_info DMV in SQL...
2011-04-05
609 reads
S3OLV April 2011
Are you ready to learn again? The Las Vegas SQL Users Group is ready to have our April meeting. The meeting is to be held April 14, 2011 at...
2011-04-05
8 reads
S3OLV April 2011
Are you ready to learn again? The Las Vegas SQL Users Group is ready to have our April meeting. The...
2011-04-05
544 reads
Updated Overlapping Statistics Scripts
Last year I published a script for identifying automatically generated column statistics that overlapped index statistics. I've updated the script...
2011-04-05
1,704 reads
A SQL Server Hardware Nugget A Day – Day 5
For Day 5, I will be covering a few tools that can be used for hardware identification. Since quite a...
2011-04-05
621 reads
To TOP or not to TOP an EXISTS
Earlier this year I had a look at a query pattern that I often see on forums and in production...
2011-04-05
5,893 reads
How to Deal with Quebec’s Extremists – Report their Threats to the Police (Investigation Under Way)
I’m part of a Committee that is dedicated to eliminating discriminatory legislation in Quebec, here’s a statement we released last...
2011-04-05
2,426 reads
Canada Begins Return to Democracy as the ‘Harper Government’ Found in Contempt of Parliament, a First Throughout the Commonwealth – And No Confidence Vote Triggers the Election Race
For over a week now, Canada has begun its return to appearing to be a democracy thanks to a Liberal...
2011-04-05
1,221 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