[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 4. The partitioning includes several major components of work (and can be linked...
2015-06-09
8 reads
When I attend sessions at events, I try to mix it up. I’ll go to a session that, really, I...
2015-06-09
528 reads
So on June 3rd I got this email from Edward Pollack.
I had submitted a few weeks earlier and had been...
2015-06-09
745 reads
If you live in the Midwest region around Iowa, Nebraska, South Dakota, and Minnesota, you should consider attending the first-ever...
2015-06-09
540 reads
I appeared on the .NET Rocks podcast show #1149 this week. I had a blast talking about TypeScript, the new...
2015-06-09
802 reads
Let’s look at the following script:
CREATE TABLE LoadMeFast (Id INT NOT NULL,
InsertDate DATETIME NOT NULL,
ABunchOfLetters NVARCHAR(100)
)
GO
SET NOCOUNT ON
GO
DECLARE...
2015-06-09 (first published: 2015-06-03)
4,061 reads
Continuation from the previous 54 parts, the whole series can be found at http://www.nikoport.com/columnstore/
The architectural changes in the upcoming SQL...
2015-06-08
612 reads
Announcing my new book available in hard copy and eBook, HealthySQL -
A Comprehensive Guide to Healthy SQL Server Performance, by...
2015-06-08 (first published: 2015-06-03)
3,472 reads
A question came up at work the other day, mostly as a mind game, but you never know it might...
2015-06-08 (first published: 2015-05-28)
1,859 reads
Hi folks, in our previous blog of SQL Server Database Mail stored procedure we added database mail account to database...
2015-06-08
416 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