Clearing Job Notifications - HELP!
I have inherited a SQL 2005 server with SQL Agent job notifications in place, and a request to clear the...
2012-03-02
914 reads
PepsiCo Women’s Inspiration Award Winner – If I can do it, so can you…
An inspiring story. A hard one, and one that comes from someone with talent.
I like seeing stories like this, and...
2012-03-02
1,016 reads
Introducing SQL Roundup
Following in the foot steps of John Sansom (b|t), I’m going to post a roundup of links from other blogs every Friday. I’ll...
2012-03-02
990 reads
MDX SSRS Parameter Values
<rant> One of the most frustrating things about working with the Microsoft BI Stack is after you go through all...
2012-03-02
9,344 reads
Smart Car Charging
I don’t know if electric cars are the answer, but I do think electricity will play a larger part of...
2012-03-01
888 reads
Speaking at oPASS on March 8th
I will be at oPASS on March 8th (Thursday) in Orlando, Florida. I'll give a preview of the talk I'm giving...
2012-03-01
1,032 reads
Linked Servers
Do you have linked servers that have been created in your environment? Do you know what these linked servers are? Finding Linked Servers SQL Server has provided us means...
2012-03-01
17 reads
Linked Servers
Do you have linked servers that have been created in your environment? Do you know what these linked servers are?
Finding...
2012-03-01
1,113 reads
Choosing the Right Microsoft Reporting Technology Part 1: Report Services
As Business Intelligence has evolved over the years the number of tools we have to choose from for presenting data...
2012-03-01
1,467 reads
sql server scripts and managing databases
Managing a large SQL Server inventory requires an efficient management processes.
Following on from DBA productivity and less is more , this...
2012-03-01
1,300 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