Professional SSRS 2016 Book Preview Posts
This page is a table of contents for for several new and forthcoming posts. I’m posting a series of excerpts...
2017-01-22
531 reads
Columnstore Indexes – part 96 (“Nonclustered Columnstore Index Online Rebuild”)
Continuation from the previous 95 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focused on a...
2017-01-22
693 reads
MVP 2016!!!
Dear All,Very happy to share the news that I have been awarded Microsoft Most Valuable Professional award for my contributions to SQL Server Community in 2016!!!. This is an...
2017-01-22
5 reads
MVP 2016!!!
Dear All,Very happy to share the news that I have been awarded Microsoft Most Valuable Professional award for my contributions to SQL Server Community in 2016!!!. This is an...
2017-01-22
21 reads
How to Count the Total Number of Rows Across Multiple Tables
I have been working on SQL Server Consulting assignment, a SQL Server 2014 migration for a new client over the...
2017-01-31 (first published: 2017-01-22)
45,298 reads
MVP 2016!!!
Dear All,
Very happy to share the news that I have been awarded Microsoft Most Valuable Professional award for my contributions...
2017-01-22
383 reads
CREATE DATABASE – I’ve not seen that before.
TweetG’day,
It’s been a while
I thought that I’d make a quick blog post about an incident that I encountered today...
2017-01-22
1,024 reads
Implementing Fuzzy Sets in SQL Server, Part 7: The Significance of Fuzzy Stats
By Steve Bolton
…………In the world of fuzzy sets and imprecision modeling, the concept of cardinality takes on new shades of...
2017-01-20
529 reads
The most underrated show on Data Platform – SQL Unplugged
I would like to write a blog post about by far the most underrated online show about Data Platform – SQL...
2017-01-20
703 reads
We’re hiring!
I’m proud and humbled to announce that my company, Heraflux Technologies, is hiring for a Data Platform Solutions Architect!
We are...
2017-01-20
312 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