WaitForSql (to start)
In the spirit of having apps that do just one thing I have put a really small .net app on...
2015-07-17
50 reads
WaitForSql (to start)
In the spirit of having apps that do just one thing I have put a really small .net app on...
2015-07-17
34 reads
Validating Cluster Instance Owner with Powershell
A few weeks ago, for TSQL Tuesday, I wrote about how I used Powershell to manage failing over clusters. At work,...
2015-07-17
1,017 reads
Murder and XE Train in Louisville
Bringing years of experience together in two all day workshop sessions.
Related Posts:
Seattle SQL Pro Workshop 2017 October 19, 2017
Finding Installed Event Sessions December 31, 2018
Sharepoint Diagnostics and...
2015-07-17
6 reads
Murder and XE Train in Louisville
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2015-07-17
859 reads
WaitForSql (to start)
In the spirit of having apps that do just one thing I have put a really small .net app on github that tries to create a connection to a...
2015-07-17
6 reads
SQL Server: utilize partitioning to purge large tables
Sooner or later every DBA needs to purge old data from database tables. And it often happens that such tables...
2015-07-17
3,593 reads
Speaking next Wednesday July 22nd, at Vermont SQL PASS group, thanks to Roman Rehak? for the invite!
Speaking next Wednesday, Vermont SQL PASS group, thanks to Roman Rehak? for the invite! http://www.meetup.com/VTCode/events/223946011/
I'll be doing an update to...
2015-07-17
724 reads
Introduction To Query Store In SQL Server 2016 – Part 2
Hi friends, today we will continue with Query Store in SQL Server 2016. In previous blog we learnt about what...
2015-07-17
1,113 reads
How do different types of functions compare performance wise?
A while back, I wrote a blog post showing the differences (including performance) between Inline Table-Valued Functions (ITVF) and Multi-Statement...
2015-07-16
1,088 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