SQL Server – Calculating elapsed time from DATETIME
Elapsed time can be calculated from DATETIME field by extracting number of hours/minutes and seconds. You can use below query...
2013-12-23
101 reads
Blog Posts
SQL Server – Calculating elapsed time from DATETIME
Elapsed time can be calculated from DATETIME field by extracting number of hours/minutes and seconds. You can use below query...
2013-12-23
260 reads
SQL Server Pro Community Choice Awards
I’m a bit late posting this, but it’s worth a couple minutes to check out the Community Choice awards, might...
2013-12-23
924 reads
SSMS Shortcuts and more
I went and voted for #tribalawards and when I was finished they offer you links to 6 different free PDFs....
2013-12-23
696 reads
Symmetric Keys
One of the encryption options in SQL Server is symmetric key encryption. This is the type of encryption most people...
2013-12-23 (first published: 2013-12-16)
2,944 reads
The Night Before Upgrade
I originally wrote this in December 2011. It’s been one of my most popular posts, so reposting it has become...
2013-12-23
457 reads
Tribal Awards: Vote Now!
The #tribalawards voting is now online. Get over there and get it done.
I honestly don’t care who you vote for...
2013-12-23 (first published: 2013-12-20)
924 reads
Android is better than iOS
Not in many ways, and certainly not in enough for me to stick with Android over iOS, but here are...
2013-12-20
1,135 reads
Assign SQL Service Account with Group Policy
How do I assign and enforce a service account for the SQL Server Services with Active Directory Group Policy?
The answer...
2013-12-20
6,845 reads
Case-Sensitive Updates in a Case-Insensitive World
Assuming you're in a case-insensitive ("CI" in the collation name) column, this UPDATE statement:
UPDATE tablefoo
set foo = 'Z'
where foo = 'z'
will just...
2013-12-20 (first published: 2013-12-16)
1,814 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