Toolbox - Why is My Database So Big????
I have written previously (here)about how to tell which database files have free space in them when your drive starts...
2018-01-19
3,754 reads
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,244 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
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