Quick SSMS Tip: Map Mode for Code–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In recent versions of SSMS, there’s been an...
2020-08-05
34 reads
Blog Posts
The What, Why, When, and How of Incremental Loads
When moving data in an extraction, transformation, and loading (ETL) process, the most efficient design pattern is to touch only the data you must, copying just the data that...
2020-08-05 (first published: 2020-07-23)
564 reads
Azure SQL Database SLA
Can you improve on the baseline (service level agreement) SLA of 99.99 % for Azure SQL Database? How can you get 99.995% as shown below, from official Microsoft documentation?...
2020-08-04
105 reads
Color Coding a Database on All Servers with SQL Prompt
SQL Prompt has some nice color coding features, but sometimes I want a database to keep the same color, regardless of instance. I don’t know that I’d recommend this,...
2020-08-04 (first published: 2020-07-22)
368 reads
Daily Coping 4 Aug 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-08-04
17 reads
Probing Columnstore Indexes
This article was first published on: 2020-03-14.
This article will probe the performance benefits of columnstore indexes, on a transactional (OLTP) workload for real-time analytics.
We'll cover examples...
2020-08-04 (first published: 2020-07-23)
476 reads
Speaking at DataMinds Connect 2020
I’m delighted to announce I’ll be speaking again at DataMinds Connect this year, one of the greatest and best Microsoft Data Platform conferences on the European mainland. Due to...
2020-08-04
15 reads
Business Continuity in SQL Database
I have wrote a number of blogs on the topic of business continuity in SQL Database before (HA/DR for Azure SQL Database, Azure SQL Database high availability, Azure SQL...
2020-08-03 (first published: 2020-07-20)
440 reads
Daily Coping 3 Aug 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-08-03
12 reads
Data Cleanup for WordPress Tags without a Plugin
Over the years I’ve had this blog, I’ve added lots of tags. In 15 years and 4,600+ posts, you can guess that I’ve made some typos and mistakes. I’ve...
2020-08-03
28 reads
Blogs
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...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
BCA KCP Tumpang (08218200205) WhatsApp
ALAMAT : Jl. Raya Tumpang No.1, Ledoksari, Tumpang, Kec. Tumpang, Kabupaten Malang, Jawa Timur...
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