June 2008 - Page 4 of 5 - SQL Authority with Pinal Dave

SQLAuthority News – SQL Server 2008 Release Candidate 0

June 9, 2008

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Download Microsoft SQL Server 2008 Release Candidate 0 (RC0) and preview the latest features of SQL Server 2008! The SQL Server development team uses your feedback to help refine and enhance product features. Evaluate SQL Server 2008 RC0 today and send your feedback. SQL Server 2008 provides a comprehensive data…

SQL SERVER – Order of Conditions in WHERE Clause

June 8, 2008

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server

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

June 7, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

PIVOT, SQL Joins, SQL Scripts, UNPIVOT

I previously wrote two articles about PIVOT and UNPIVOT tables. I really enjoyed writing about them as it was interesting concept. One of the Jr. DBA at my organization asked me following question. “If we PIVOT any table and UNPIVOT that table do we get our original table?” I really…

SQLAuthority News – Subscribe to the Newsletter for 3 Important Scripts

June 6, 2008

Pinal Dave

SQLAuthority News

Database, , SQL Wait Stats

Lots of people ask me how to stay in touch with SQLAuthority.com. Well, the answer is very simple, you can subscribe to the newsletter of SQLAuthority.com by going to URL here: https://go.sqlauthority.com.

SQL SERVER – Compound Assignment Operators – A Simple Example

June 5, 2008

Pinal Dave

SQL Tips and Tricks

SQL Operator, SQL Scripts, SQL Server, SQL Utility

SQL SERVER 2008 has introduced new concept of Compound Assignment Operators. Compound Assignment Operators are available in many other programming languages for quite some time. Compound Assignment Operators is operator where variables are operated upon and assigned on the same line.

SQL SERVER – Create a Comma Delimited List Using SELECT Clause From Table Column

June 4, 2008

Pinal Dave

SQL Tips and Tricks

CSV, Database, SQL Function, SQL Scripts, SQL Server, SQL Stored Procedure

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

June 3, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

Just a day ago, I was was asked this question in one of the teaching session to my team members. One of the member asked me if I can use DISTINCT in Aggregate Function and does it make any difference. Of course! It does make difference. DISTINCT can be used…