Shaking the Money Tree
Are developers or administrators worth more? Is it easier to get funding for one group or the other? Steve Jones asks the question in today's poll.
2009-06-03
513 reads
Editorial - WMV
Syncing Releases
Is the future for product releases and upgrades, to be synchronized with point releases? Steve Jones relishes the possibility.
2009-06-03
569 reads
The Problem Is You
Why doesn't SQL Server just run smoothly after it's installed? Steve Jones thinks the problem is you.
2009-06-02
97 reads
No More SOX
A legal challenge to the Sarbannes-Oxley act is being heard this fall. Steve Jones doesn't necessarily think this is a bad law.
2009-05-30
652 reads
Making Mistakes - Database Weekly (June 1, 2009)
We all make mistakes, even when we are trying to help others. What should you do about it? Steve Jones has a few thoughts on advice online.
2009-05-30
503 reads
The Sports Salary
Are you happy with your salary? Are you happy with the way you negotiated it? Steve Jones asks if you might like a different salary structure.
2009-05-28
716 reads
Dead Data
What happens to the data of a company if it goes out of business? Steve Jones has a little experience and says it might not be as simple as you think.
2009-05-27
529 reads
Time Off
It's almost summer with Memorial Day coming next week in the US. For this Friday's poll Steve Jones asks about nothing to do with SQL Server, technology, or work.
2009-05-21
474 reads
Do You Have a Problem?
Is it easier to justify expenses fr a developer than an administrator. Steve Jones thinks it is.
2009-05-20
83 reads
Giving Your Best
It's easy to get into a rut at work, and easy to just attempt to get some minimum amount of work done each day. Steve Jones is inspired today to think about doing more.
2009-05-18
206 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