Released with SQL Server 2016, Query Data Store was a game changer for performance tuning. Right from Microsoft’s website: The SQL Server Query Store feature provides you with...
2020-10-20 (first published: 2020-10-13)
660 reads
Thank you all for your service!
I was fortunate to have attended PASS Summit again this year. As an added bonus...
2018-11-11
189 reads
I was at SQL Saturday 723 in Rochester, NY last weekend. I was selected to deliver 2 sessions, and I...
2018-03-27
217 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2018-03-02
285 reads
This month’s topic: Folks Who Have Made a Difference
T-SQL Tuesday is a monthly blog party for the SQL Server community...
2017-11-14
317 reads
This month’s topic: Let’s get all Posh – What are you going to automate today?
T-SQL Tuesday is a monthly blog party...
2017-09-11
308 reads
Today I learned that you can configure tempdb in RDS!
One of the things we DBA’s do is configure tempdb to...
2017-08-28
1,108 reads
Beware the automated backup window when running native SQL Server backups in RDS
If you’ve ever fired up an RDS instance...
2017-08-04
2,393 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2017-06-13
346 reads
T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called...
2017-05-25 (first published: 2017-05-09)
1,690 reads
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Comments posted to this topic are about the item Adding new column with DEFAULT...
Comments posted to this topic are about the item Advanced Deployment Scenarios: Stairway to...
Comments posted to this topic are about the item You Need a DBA Pipeline
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