2016-12-21
1,058 reads
SQL Server 2016
A Big Deal : SQL Server 2016 Service Pack 1
Microsoft has made a bold change with SQL Server 2016 Service Pack 1 : Many Enterprise features are now available in lower editions. Read on for details.
2016-12-13
10,390 reads
2016-12-09
1,152 reads
Experience SQL Server 2016 in Microsoft Luxembourg’s Intelligent Office
The SQL Server Luxembourg User Group invites you to join us at our next event, in Microsoft’s new Intelligent Offices, for Tom van Zele’s SQL 2016 presentation. Tom’s road-show session highlights SQL Server 2016’s new features: End-to-end mobile BI, advanced analytics, cloud integration and lots of other new stuff will be addressed.
2016-11-28 (first published: 2016-11-23)
3,352 reads
SQL Server 2016 DBCC CHECKDB with MAXDOP
Ahmad Yaseen explains how you can control the number of processors assigned to the SQL Server DBCC CHECKDB command in order to free-up the server's resources.
2016-10-28
3,392 reads
Time Traveling with Temporal Tables on SQL Server 2016
One of the new features of SQL Server 2016 is the ability to time travel in your databases and visit a specific table at a specific point of time in history. You can also use this feature to audit changes or “undo” whole data warehouse updates.
2017-09-04 (first published: 2016-10-18)
10,236 reads
SQL Server 2016 New Date Objects
SQL Server 2016 introduced three new objects to deal with the greater demand of data; John Miner takes a look at this new functionality.
2016-10-13
4,605 reads
2016-10-07
1,052 reads
Masking Your Data with SQL Server 2016
There are times when you want some users to see part of a column value but not the whole thing, but you want other users to see the complete column value without any masking. The new SQL Server 2016 Dynamic Data Masking feature will allow you to define these different kinds of masking rules - Greg Larson explains.
2016-09-29
5,212 reads
AT TIME ZONE – a new favourite feature in SQL Server 2016
Rob Farley explains why AT TIME ZONE is his new favourite feature in SQL Server 2016, but also shows that it can make a mess of cardinality estimates.
2016-09-22
4,108 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
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...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
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