SQL Saturday #132 Pensacola and Wheeling, WV PASS UG
I have 2 upcoming speaker opportunities in June and am very excited about presenting this material.
June 9th is in...
2012-05-26
763 reads
Exercise in the Margins
This article about exercising when you can is really interesting. It contains a number of hints about exercising and fitting...
2012-05-25
1,175 reads
Backup duration statistics
Here is a simple query which can list backup duration statistics for all database, including the max, min, avg of...
2012-05-25
2,806 reads
SQL Server – Cannot resolve collation conflict
A friend of mine contacted me through email today having a very common problem with a query he had written....
2012-05-25
811 reads
The Done Stamp
I’m fond of replying with “done” when a task is complete, no need for anything more elaborate. I’ve been experimenting...
2012-05-25
592 reads
Building a Presentation Map
This idea came up during a critique of a presentation. I may have re-invented (or re-labeled) something that is already...
2012-05-25
627 reads
Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)
Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)
MDS and Best Practice Analyzer new features were introduced in sql...
2012-05-25
704 reads
Recently Used Tables and Databases
Recently developed these queries to assist with the evaluation of development or sandbox environments. Sometimes disk space demands that old...
2012-05-24
1,596 reads
It’s OK To Eat Alone
There’s a lot to be said for the philosophy of Never Eat Alone, using meals as a great time to...
2012-05-24
768 reads
Denali – Day 24: True Black Box Recorder – sp_server_diagnostics
Denali – Day 24: True Black Box Recorder – sp_server_diagnostics
Earlier sql server was having diagnoses tool.
Default trace.
SQLDiag
And other tools but could not...
2012-05-24
1,441 reads
Blogs
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
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...
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