The Database Weekly Update for June 16, 2008
Steve Jones looks back at the news of the past, including a look at RC0, the latest release of SQL Server 2008.
2008-06-14
164 reads
Editorial - WMV
Do You Want to Be Right?
Steve Jones talks about being right versus being effective in your IT work.
2008-06-14
30 reads
The Vacation Dilemma
Does vacation cause extra stress at your job before or after you leave? Steve Jones asks a poll question this Friday to see how you feel.
2008-06-12
50 reads
The Bulldogs
Steve Jones talks about IT Project Failure and how you should re-evaluate things are you move forward.
2008-06-09
43 reads
A Private Database
Having separate databases for each client? It's a common problem and Steve Jones wonders if this might be a feature coming in SQL Server at some point.
2008-06-07
46 reads
2008-06-05
32 reads
The Software Comparison - Part 4
The final installment of Steve Jones' comparison between software developers and other professions looks at the most closely related: engineers.
2008-06-05
40 reads
The Software Comparison - Part 3
Steve Jones takes another attempt at comparing software development to another profession. Today's target: doctors.
2008-06-03
54 reads
The Software Comparison - Part 2
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
2008-06-02
39 reads
The Software Comparison
Is building software like building a house? Steve Jones digs into the comparison at the start of an editorial series looking at other professions.
2008-06-01
35 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