All Articles - SQL Authority with Pinal Dave

SQL SERVER – Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies

June 10, 2008

Note: Download Here by Microsoft Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies Release Candidate (RC0) (Reporting Services Add-in) enables you to take advantage of SQL Server 2008 Release Candidate (RC0) report processing and management capabilities within Windows SharePoint Services (WSS) 3.0 or Microsoft Office SharePoint Server 2007.…

SQLAuthority News – SQL Server 2008 Release Candidate 0

June 9, 2008

Pinal Dave

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

Database, DBA, SQL Download

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.

All Articles Compound-Assignment-Operators-600x387

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…

SQL SERVER – Order Of Column In Index

June 2, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Index, SQL Joins, SQL Scripts

I just found one of my Jr. DBA to create many indexes with lots of column in it. After talking with him I found out that he really does not understand how really Index works. He was under impression that if he has more columns in one index, that index…

SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 4

June 1, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts

I have been asked many times when there is DATENAME function available why do I go in exercise of writing UDF For the getting the day of the week. Answer is : I just like it! SELECT DATENAME(dw, GETDATE()) Reference : Pinal Dave (https://blog.sqlauthority.com)