What Does REPAIR_ALLOW_DATA_LOSS in SQL Server Signify?
REPAIR_ALLOW_DATA_LOSS is the repair level, which is recommended by DBCC CHECKDB when the database is found in a corrupted state.SQL...
2018-01-19
3,243 reads
Friday Reading 2018-01-19
It’s been absolutely freezing here in Dublin this week. Been spending pretty much all time wrapped up indoors reading…
Discussing PASS...
2018-01-19
314 reads
Faster
In the human history, there was a huge drive (such an ambiguous meaning here) to get faster.
Maybe within our DNA...
2018-01-19
317 reads
Template Explorer (Day 18)
You may have noticed that in many places in SSMS, you can create a new item and SSMS opens up...
2018-01-18
83 reads
Template Explorer (Day 18)
You may have noticed that in many places in SSMS, you can create a new item and SSMS opens up...
2018-01-18
285 reads
Advent of Code 2017 Day 4–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-01-18
737 reads
Database Corruption and IO Errors
A quick way to have your day turned upside down and rip your gut out with nerves and anxiety is to come in one day to find that users...
2018-01-18
16 reads
Database Corruption and IO Errors
A quick way to have your day turned upside down and rip your gut out with nerves and anxiety is...
2018-01-18
1,013 reads
Pester 4.2.0 has a Because…… because :-)
I was going through my demo for the South Coast User Group meeting tonight and decided to add some details...
2018-01-18
387 reads
Jack of ALL Trades
Warning: If during reading this post, you feel like a lot of bells started ringing – I might have written about...
2018-01-18
427 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