Download Microsoft SQL Server 2008 Release Candidate 0 (RC0), preview the latest features and send feedback to the team. Note that RC0 expires after 180 days.
SQL SERVER – Order of Conditions in WHERE Clause
Sr. Developer in my organization asked me the following question about WHERE clause.
Question: Does the order of conditions matter in WHERE clause?
SQL SERVER – PIVOT and UNPIVOT Table Examples
If you PIVOT a table and then UNPIVOT it, do you get the original back? Not always. My PIVOT and UNPIVOT table examples show why aggregation loses data.
SQLAuthority News – Subscribe to the Newsletter for 3 Important Scripts
Want to stay in touch with SQLAuthority.com? Subscribe to the free newsletter and get three useful scripts, including one to find unused indexes, right away.
SQL SERVER – Compound Assignment Operators – A Simple Example
SQL Server 2008 added Compound Assignment Operators like += and *=, which change a variable and assign it on one line. A simple example and the full list.
SQL SERVER – Create a Comma Delimited List Using SELECT Clause From Table Column
I received following question in email : How to create a comma delimited list using SELECT clause from table column?
SQL SERVER – Example of DISTINCT in Aggregate Functions
Does DISTINCT in Aggregate Functions make a difference? Yes. A quick AdventureWorks example compares SUM(DISTINCT ReorderPoint) with a plain SUM.
SQL SERVER – Order Of Column In Index
Adding more columns does not make an index better. The order of column in index matters most, since an index is used only when its first column is in the query.
SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function Part 4
In Day of the Week Function Part 4, I answer why I write a UDF when DATENAME exists (I just like it) and show the one line DATENAME version.
SQL SERVER – Create Default Constraint Over Table Column
A small script I keep handy for Jr. Developers: create a default constraint on a table column with ALTER TABLE, and what happens to rows that already have values.