How many heap tables do you have? :Quick Tips
Nothing exciting, just a general script. How can you see what heaps you have laying around?
exec sp_MSforeachdb @command1 ='
use [?]
SELECT...
2013-11-22
901 reads
Blog Posts
It sure would be grand to have interesting interviews
Coincidentally, in a week of debate and thinking and writing on IT interviews and candidates, XKCD has gifted us with...
2013-11-22
540 reads
Reblog: November 15 to November 21
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-11-22
829 reads
#SQLRelay 2013 R2 – Week 2
If you haven’t heard of SQL Relay and you live in the UK then shame on you. SQL Relay is...
2013-11-21
975 reads
Fill Factor and wasted space: Quick Tip
This is a little excessive, but here's a quick script to show you your fill factors per table that are...
2013-11-21
919 reads
JFK
“There is little value in ensuring the survival of our nation if our traditions do not survive with it. And...
2013-11-21
635 reads
Learn About PCI Today
I’ll be presenting PCI for the SQL DBA today at 1 pm EST for the PASS Security Virtual Chapter. Depending...
2013-11-21
629 reads
Notes from SQLSaturday in Oregon Nov 16, 2013
I wanted to take time to thank our sponsors, speakers and volunteers for making #sqlsat265 a big success. Over 400...
2013-11-21
580 reads
Powershell in a Month – Day 3 – Commands
This is part of my Powershell Challenge, to learn more about Powerhsell (PoSh) using the Learn Windows Powershell 3 in a Month...
2013-11-21
1,338 reads
What Happens In Vegas…
…stays in Vegas, except when it comes to chocolate. After walking more than 1500 miles over the past 9 months,...
2013-11-21
519 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
A Complete Guide to IMAP to Office 365 Migration
IMAP to Office 365 migration is an important step for organizations that want to...
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...
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