High Energy Plankton – T-SQL Tuesday #35
High Energy Plankton
In 2022 humans will finally have become their own worst enemies/frenemies. No matter how hard Gore works to...
2012-10-09
1,089 reads
Blog Posts
High Energy Plankton – T-SQL Tuesday #35
So, what I’d like to know is, what is your most horrifying discovery from your work with SQL Server?
Related Posts:
Data Platform MVP 2020 August 12, 2020
It's an Honor:...
2012-10-09
4 reads
Interview with a #SQLPASS Candidate – @NTSSUG’s Sri Sridharan!
Last week, Sri Sridharan (Twitter, blog) and I sat down on the Internet to talk about his run for the...
2012-10-09
708 reads
MDS Error: “Cannot insert the value NULL into column ‘Code’”
In Microsoft Data Services (MDS), when running a stored procedure to process a staging table (stg.udp_name_Leaf), I received this error:
“Cannot...
2012-10-09
1,257 reads
My PASS Board Vote
I’m not a politically minded person and this is not the type of post I would normally write. However, I’m...
2012-10-09
772 reads
Part II - Louis Davidson (Dr SQL)–Designing for Common Problems in SQL Server…continued
The PASS Data Architecture Virtual Chapter will host part II of Designing for Common Problems in SQL Server by Dr....
2012-10-09
599 reads
Retrieving Driver Information
Recently, I had a need to take a look at all of the drivers for a specific set hardware on...
2012-10-09
446 reads
SQL Server 2012 CU3 Is Now Available !
The 3rd cumulative update release for SQL Server 2012 is now available for download at the Microsoft Support site. Cumulative...
2012-10-09
1,180 reads
SQLSaturday #171 Pittsburgh recap
This past weekend I made the drive from Cleveland to Pittsburgh to attend SQLSaturday #171. They picked the perfect time...
2012-10-09
575 reads
T-SQL Tuesday #35 – Soylent Green
This month’s host is Nick Haslam (b | t) and he bases his question on the movie Soylent Green, which I...
2012-10-09
970 reads
Blogs
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....
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Forums
Performance Regression After Upgrading from SQL Server 2016 to 2022
Hello everyone, Last week we performed an upgrade of our SQL Server instance, moving...
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