Driving Value
Does your IT organization bring value to your company? Steve Jones takes a look at some of the ways you can do this.
2008-07-01
43 reads
Editorial - WMV
Data Rich and Information Poor
Do you deal with data or information? Do you know the difference and are you transforming one into the other. Steve Jones comments on the state of many companies' data.
2008-06-30
45 reads
The June 2008 Energy Update
It's time again to take a look at energy news from an IT perspective, or at least the Steve Jones' perspective and there have been some interesting notes over the last couple months in the world of energy.
2008-06-29
500 reads
The Database Weekly Update for June 30, 2008
Steve Jones looks back at a week of news on data center infrastructure, the EF war, and SQL Server 2008 news.
2008-06-28
208 reads
The Multiple Instance Dilemna
SQL Servers seem to proliferate in many companies, making management a headache for DBAs. Steve Jones asks a Friday poll about how you handle all those service account.
2008-06-26
42 reads
2008-06-25
42 reads
2008-06-19
37 reads
In The Zone
Are you in the Zone at work? Can you find those times when you are amazingly productive? Tim Mitchell asks a question in this guest editorial.
2008-06-18
49 reads
Double Check
Steve Jones looks at the positive side of someone else doing your work when you're on vacation. There's an interesting benefit for the company.
2008-06-17
51 reads
The Green Stuff
Money. It's part of the reason why we all work, though hopefully not all of it. Steve Jones comments a bit on financial matters.
2008-06-16
46 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