T-SQL Tuesday #73 - Not Running CHECKDB is Naughty!
This month T-SQL Tuesday is hosted by Bradley Balls (blog/@SQLBalls) and his topic of choice is “Naughty or Nice.”
(If you...
2015-12-14 (first published: 2015-12-08)
2,875 reads
Nebraska SQL from @DBA_ANDY
What Do You Mean There is No Current Database Backup?!?
Yet another late night/early morning tale...
The LOG backups for multiple databases on a server failed overnight (not all databases, but...
2015-12-03
974 reads
We Are All Responsible
Today we all received an email from PASS's president Tom LaRock (blog/@SQLRockstar):
PASS Anti-Harassment Policy ReminderIt is unfortunate that I have...
2015-11-24
494 reads
CHECKDB - The database could not be exclusively locked to perform the operation
…so the job failed….again…you know the one – that darn Integrity Check job: Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp_ma...".: 100% complete ...
2015-11-18 (first published: 2015-11-16)
11,487 reads
SQL Server Training
Brent Ozar’s group (http://www.brentozar.com/) just announced a pretty crazy set of “Black Friday” deals:
http://www.brentozar.com/archive/2015/11/announcing-our-2015-black-friday-sale-on-sql-server-training/
Insane sales if you can be one...
2015-11-12
584 reads
T-SQL Tuesday #72 - Implicit Conversion Problems
This month T-SQL Tuesday is hosted by Mickey Steuwe (blog/@SQLMickey) and her topic of choice is “Data Modeling Gone Wrong.”
(If...
2015-11-12 (first published: 2015-11-10)
1,867 reads
PASS Summit 2015 Recap
Last week was the annual PASS Summit in Seattle. The Summit is the predominant educational and networking event for SQL...
2015-11-03
617 reads
Deleting Files Older than X Hours with PowerShell
(aka "OMG I can't believe I am actually finally writing a #PowerShell blog post").
--
I currently have a situation at a...
2015-04-15
33,677 reads
Availability Groups - Where Did My Disks Go?
The TL;DR - beware of Failover Cluster Manager trying to steal your non-shared storage!
--At a client recently two availability groups on...
2015-04-02
13,127 reads
POSTPONED to 02/11 - Speaking at the Omaha SQL Server User Group *Tomorrow* Night!
UPDATE - due to weather conditions today (snow this AM and sub-zero cold tonight) we are postponed to next Wednesday 02/11...
2015-02-03
920 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
Hello everyone, Last week we performed an upgrade of our SQL Server instance, moving...
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