2008-12-24
179 reads
Articles
2008-12-24
428 reads
Web Mining: Creating, Enhancing, Mining and Acting on Web Data
Customer interactions reveal important trends and patterns that can help a company design a website that effectively communicates and markets its products and services.
2008-12-24
1,509 reads
Auditing Changes in ETL with SSIS
This article briefly demonstrates a methodology for auditing changes made to data flows during the ETL process.
2008-12-23
7,327 reads
Creating One-Time Jobs - SQL School Video
SQL Agent is one of the handiest subsystems in SQL Server. This video shows how you can schedule a one-time job to handle something without you being there.
2008-12-23
3,898 reads
2008-12-23
79 reads
2008-12-23
626 reads
2008-12-23
632 reads
How do I run code automatically when SQL Server starts?
The need to run a stored procedure or SQL Agent Job when SQL Server or SQL Agent starts is a common requirement in the world of SQL Server administration. This article gives an overview of the ways to execute SQL stored procedures or SQL Agent jobs on startup.
2008-12-23
2,546 reads
Powerful Geographical Visualisations made easy with SQL 2008 Spatial (Part 2)
This is the final article in a series on how to perform data visualisation with SQL Server 2008
2008-12-23
2,302 reads
Blogs
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...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
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