Powering up DTS with PerlDTS
This article introduces the PerlDTS project that provides a Perl distribution to access and execute MS SQL Server 8 DTS packages.
2008-12-22
3,071 reads
Articles
Powerful Geographical Visualisations made easy with SQL 2008 Spatial (Part 1)
This article is part one of a two part series on how to perform data visualisation with SQL Server 2008
2008-12-22
3,010 reads
Smart Teaching
Do computers help us learn quicker? Do we need to in today's wired world? Steve Jones talks a little about learning in today's editorial
2008-12-22
724 reads
Smart Teaching
Do computers help us learn quicker? Do we need to in today's wired world? Steve Jones talks a little about learning in today's editorial
2008-12-22
741 reads
Smart Teaching
Do computers help us learn quicker? Do we need to in today's wired world? Steve Jones talks a little about learning in today's editorial
2008-12-22
1,003 reads
SQL inner and outer joins: Basics for getting started
Learn the basics to create a SQL inner join and SQL outer join. Get examples on how to use them for a customized result set querying more than one table.
2008-12-22
5,822 reads
The Set-Based Limit
An interesting post from Linchi Shea inspires Steve Jones to comment on procedural v set-based programming.
2008-12-21
624 reads
The Set-Based Limit
An interesting post from Linchi Shea inspires Steve Jones to comment on procedural v set-based programming.
2008-12-21
1,309 reads
The Set-Based Limit
An interesting post from Linchi Shea inspires Steve Jones to comment on procedural v set-based programming.
2008-12-21
636 reads
DAC - What to Execute when Connected?
SQL Server Issues? Connect with Dedicated Administrator Connection (DAC), then what? Execute this stored procedure to get some understanding on what is going on in the SQL server.
2008-12-19
6,253 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