The T-SQL Paradigm
This Friday, Steve Jones looks for opinions on what you think of the T-SQL language. Is it well structured or does it really need help?
2009-04-02
560 reads
Editorial - WMV
The March 2009 Car Update
This month Steve Jones looks at the problems in the auto industry along with a link to the cars most likely to be caught speeding.
2009-03-30
460 reads
Annoyances
Working with others can be a challenge. This Friday's poll asks for those little annoyances in the workplace and how to deal with them.
2009-03-26
304 reads
The Need for Tape
Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.
2009-03-25
745 reads
It Depends
It depends. The mantra of many DBAs and others in IT. Steve Jones reminds us why it applies.
2009-03-24
71 reads
Almost Like a Service Pack
Microsoft recently laid off a number of people and made a mistake that they handled poorly. Steve Jones comments about what could have been done better.
2009-03-23
642 reads
A Better English Query
Someone is trying to build a better query engine for the web, something beyond a search engine. Steve Jones comments on the possible implications for databases if this works.
2009-03-22
785 reads
Secure Programming
Writing secure programs is hard. Steve Jones has a few comments on what some of the issues are with training developers.
2009-03-18
477 reads
SQL Server Knockoffs
Will we see a low-cost SQL Server knock-off at some point? Steve Jones thinks it could happen as the RDBMS becomes a commodity product.
2009-03-16
568 reads
Letting People Go Securely
Having employees leave your company is a reality of life. But how do you handle letting your IT workers go and protect your systems? Steve Jones isn't sure there is much you can do to prevent issues, but you can deal with them.
2009-03-15
780 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...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
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