Daily Coping 30 Mar 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-03-30
10 reads
Blog Posts
Extended Events: Queries and Waits
Wouldn’t it be great to be able to put together queries and waits at the same time? You all capture query metrics using some method. Most of us query...
2020-03-30
22 reads
It’s Not April Fools – Redgate Streamed is Coming
Next week is April 1, typically April Fools Day, where we have jokes, pranks, and false stories. I’ve done my share of them, but this isn’t one. With the...
2020-03-30 (first published: 2020-03-25)
328 reads
Living with Bipolar During a Pandemic
Introduction Today is World Bipolar Day. I wanted to write a blog about my experience with bipolar to help others that have mental health challenges know that aren’t alone...
2020-03-30
11 reads
T-SQL Tuesday Live–31 Mar 2020
I’m hosting another live T-SQL Tuesday event tomorrow, which is really just a casual video meeting for anyone that wants to join and take a break from work, life,...
2020-03-30
23 reads
Why you should never use default string lengths.
TL;DR; You probably don’t know what you’re going to get. Even if you do know the person maintaining your code ... Continue reading
2020-03-30 (first published: 2020-03-25)
791 reads
Probing Columnstore Indexes
In this article, our focus will be to test, the performance benefits of columnstore indexes, on a transactional (OLTP) workload, for real-time analytics.
We'll cover examples from each of...
2020-03-29
50 reads
Understanding Disk Performance and IOPS in cloud platform
In the past many years, apart from working as DBA, I was working with multiple cloud technologies and actively involved in the migration process to cloud infrastructure. In between,...
2020-03-29
25 reads
COVID-19, a wake-up call
COVID-19 is the only pandemic I’ve seen in my whole life. It gave me a whole new percepective of the life. Kaal (Time) is mightiest of everyone and everything....
2020-03-28
43 reads
ASF 030: Benni De Jagere interview
Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus on the Microsoft (BI) Stack. On a daily basis, he turns (large amounts) of coffee...
2020-03-27
13 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
T-SQL Tuesday #202: The Two Outages I Won't Ever Forget
By ReviewMyDB
My T-SQL Tuesday #202 entry for Marlon Ribunal's invitation on memorable SQL Server outages....
Forums
Performance Regression After Upgrading from SQL Server 2016 to 2022
Bonjour à tous, La semaine dernière, nous avons effectué une mise à niveau de...
Adding new column with DEFAULT
Comments posted to this topic are about the item Adding new column with DEFAULT
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Question of the Day
Adding new column with DEFAULT
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers