2009-01-12
515 reads
Articles
2009-01-12
507 reads
SQL Server Management Studio 2008: New features, part 2
SQL Server Management Studio 2008 has several new features, including the T-SQL Debugger for easier debugging and a new Object Explorer Details window that's easier to use.
2009-01-12
4,656 reads
Little Security Issues
There's a trend for smaller laptops called netbooks to make traveling with computers easier. However these devices may result in more security issues. Steve Jones comments on some of the problems.
2009-01-11
251 reads
Little Security Issues
There's a trend for smaller laptops called netbooks to make traveling with computers easier. However these devices may result in more security issues. Steve Jones comments on some of the problems.
2009-01-11
507 reads
Little Security Issues
There's a trend for smaller laptops called netbooks to make traveling with computers easier. However these devices may result in more security issues. Steve Jones comments on some of the problems.
2009-01-11
268 reads
2009-01-11
776 reads
Getting A Clue About Your Databases
Got a new database you know nothing about? Here's my basic proposal on how to find interesting tables in it.
2009-01-09
10,751 reads
Simple Bar Chart for Analysis Services Data
Join MSAS Architect Bill Pearson as he leads the hands-on creation of a simple bar chart based upon an Analysis Service data source.
2009-01-09
2,644 reads
Utilize SSAS for data predictions and classification using Excel
Using Excel as a tool for data mining and predictions is very powerful. Learn how to take advantage of SSAS in SQL Server 2005 with Microsoft Office Excel 2007.
2009-01-09
2,868 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