The SQL Server 2008 Merge Statement does INSERT, UPDATE and DELETE in one statement and reads the data only once. An introduction to how it works and its syntax.
SQLAuthority News – Microsoft SQL Server 2008 Report Builder 2.0
Download Report Builder 2.0 for SQL Server 2008 Reporting Services, with table, matrix and chart wizards, plus a note on SQL Server 2008 R2 Report Builder 3.0.
SQL SERVER – XML – Split a Delimited String – Generate a Delimited String
Two XML articles by my friend Jacob Sebastian show how to split a Delimited String and build one with FOR XML PATH, which can do more than COALESCE.
SQL SERVER – 2008 – Introduction to Online Indexing Operation
An introduction to online indexing in SQL Server, which lets you create or rebuild an index while the table stays available to your app.
SQL SERVER – Get Date Time in Any Format – UDF – User Defined Functions
Nanda shared a detailed UDF to get date time in any format you need. Save it in your code bookmarks, download the script and try my examples.
SQL SERVER – Effect of Order of Join In Query
Does the order of join in a query change the result? With AdventureWorks, I show two queries that return the same rows, only in a different order.
SQL SERVER – 2008 – Get Current System Date Time
Several ways to get the current system date time in SQL Server 2008, from GETDATE to the newer functions, with a quick video on the topic.