All Articles - SQL Authority with Pinal Dave

SQL SERVER – Interesting Observation – Execution Plan and Results of Aggregate Concatenation Queries

September 29, 2009

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

Working with SQL Server has never seems to be monotonous – no matter how long one has worked with it. Quite often, I come across some excellent comments that I feel like acknowledging them as blog posts. Recently, I wrote an article on SQL SERVER – Execution Plan and Results…

SQLAuthority News – Download IIS Database Manager

September 28, 2009

Pinal Dave

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

SQL Documentation, SQL Download, SQL Utility

IIS Database Manager allows you to easily manage your local and remote databases from within IIS Manager. IIS Database Manager automatically discovers databases based on the Web server or application configuration and also provides the ability to connect to any database on the network. Once connected, IIS Database Manager provides…

SQLAuthority News – FILESTREAM Storage in SQL Server 2008

September 27, 2009

Pinal Dave

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

Filestream, SQL Documentation, SQL White Papers

This white paper describes the FILESTREAM feature of SQL Server 2008, which allows storage of and efficient access to BLOB data using a combination of SQL Server 2008 and the NTFS file system. This white paper is Written By: Paul S. Randal (SQLskills.com) Read the white paper here. Reference :…

SQLAuthority News – FIX : An error occurred while executing this command. If this error persists, please contact your Live Meeting administrator.

September 26, 2009

Pinal Dave

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

SQL Error Messages

Recently, while I was scheduling a live meeting for one of my online training sessions, I kept receiving the following error message repeatedly. I had never encountered this type of error before, and despite searching online for a long time, I could not solve this problem. After several failed attempts,…

SQL SERVER – Outer Join in Indexed View – Question to Readers

September 25, 2009

Pinal Dave

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

SQL Index, SQL Joins, SQL View, SQL White Papers

Today I have question for you. Just a day ago I was reading whitepaper Improving Performance with SQL Server 2008 Indexed Views. Following is question and answer I read in the white paper. Q. Why can’t I use OUTER JOIN in an indexed view? A. Rows can logically disappear from…

SQL SERVER – Interesting Observation – Index on Index View Used in Similar Query

September 24, 2009

Pinal Dave

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

SQL Index, SQL Scripts, SQL White Papers

Recently, I was working on an optimization project for one of the large organizations. While working on one of the queries, we came across a very interesting observation. We found that there was a query on the base table and when the query was run, it used the index, which…

SQL SERVER – Insert Values of Stored Procedure in Table – Use Table Valued Function

September 23, 2009

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Table Operation

I recently got many emails requesting to write a simple article. I also got a request to explain different ways to insert the values from a stored procedure into a table. Let us quickly look at the conventional way of doing the same with Table Valued Function.

SQLAuthority News – Article 1100 and Community Service

September 22, 2009

Pinal Dave

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

MVP

This is 1100 the post of on my blog post on this blog. Just looking at the last 100 post of my blog, I have realized besides writing blog posts there are lots of other community events, I have been involved with. Let me quickly list few of the important…

SQL SERVER – Introduction to Service Broker and Sample Script

September 21, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Service Broker, SQL Download, SQL Scripts

Service Broker in Microsoft SQL Server 2005 is a new technology that provides messaging and queuing functions between instances. The basic functions of sending and receiving messages forms a part of a “conversation.” Each conversation is considered to be a complete channel of communication. Each Service Broker conversation is considered…

SQL SERVER – Execution Plan and Results of Aggregate Concatenation Queries Depend Upon Expression Location

September 20, 2009

Pinal Dave

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

SQL Documentation

I was reading the blog of Ward Pond, and I came across another note of Microsoft. I really found it very interesting. The given explanation was very simple; however, I would like to rewrite it again. Let us execute the following script. This script inserts two values ‘A’ and ‘B’…