TechRepublic

Inserting specific values into an identity column with SQL

Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting. Despite your numerous ...
Visual Studio Magazine

Mastering SQL Server Indexing: What Every .NET Developer Needs to Know

At the upcoming Visual Studio Live! Las Vegas developer conference, SQL expert Denny Cherry will share essential indexing ...
Ars Technica

T-SQL: Building a string from all columns meeting a certain condition

DECLARE @string VARCHAR(MAX) = ''; SELECT @string = CASE WHEN MeaslesDue < '5/16/2013' THEN @string + MeaslesDue END CASE WHEN MumpsDue < '5/16/2013' THEN @string + MumpsDue END CASE WHEN RubellaDue < ...
dbta

Temporal Tables in SQL Server 2016

While temporal data support is something that has existed in the past within other database platforms, it is a newly available feature with the RTM version of SQL Server 2016. In case you haven’t ...