Common SQL Server Mistakes – Multi Row DML Triggers
How often have you seen someone write a DML trigger like this:
createtrigger mytrigger on Mytable forinsertas
declare @id int
select @id = id...
2010-09-23
15,417 reads
Microsoft Releases SQL Server 2008 SP1 Cumulative Update 10
On September 21, 2010, Microsoft released SQL Server 2008 SP1 Cumulative Update 10, which is Build 2799. I count 29...
2010-09-22
1,301 reads
Braindumps and Certification
I saw a post recently that said that braindumps were the best way to prepare for certifications. It was posted...
2010-09-22
1,890 reads
Why You Should Come to SQL Saturday #48 - Columbia, SC
SQL Saturday #48 is on October 2. We're offering free SQL Server and PowerShell training from some great names in...
2010-09-22
945 reads
Range locks do not only occur in Serializable transactions....
According to BOL, "Key-range locks protect a range of rows implicitly included in a record set being read by a...
2010-09-22
1,055 reads
Updates on SQLSaturday#59 in NYC
Hi, ALL: Just want to bring you some updates and news on SQLSaturday#59 @MS HQ in NYC on Nov 20, 2010. ...
2010-09-22
647 reads
Index Black Ops Part 3 – Index Usage
Last week, I mentioned in my TSQL2sDay index summary post, that I’d be writing a few posts on the information...
2010-09-22
1,469 reads
What Did that Geek Just Say?
The National Institute of Standards and Technology, NIST, maintains a Dictionary of Algorithms and Data Structures. The dictionary is a great place to go to find out what people...
2010-09-21
14 reads
What Did that Geek Just Say?
The National Institute of Standards and Technology, NIST, maintains a Dictionary of Algorithms and Data Structures. The dictionary is a great place to go to find out what people...
2010-09-21
19 reads
What Did that Geek Just Say?
Working in a technical field has it’s ups and downs. One of the more common annoyances I run into is...
2010-09-21
331 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