November 2009 - SQL Authority with Pinal Dave

SQL SERVER – Size of Index Table for Each Index – Solution

November 30, 2009

Earlier I have posted small question on this blog and requested help from readers to participate here and provide solution. Please read the original Puzzle here. SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table The puzzle was to write…

SQL SERVER – Azure Start Guide – Step by Step Installation Guide

November 29, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Azure

As SQL Azure CTP is released I have included here step by step guide for how to configure the CTP. For pricing and introduction please read SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing First it has to be configured online at Login using…

SQLAuthority News – SQL Server R2 Resources Downloads, Documentations

November 28, 2009

Pinal Dave

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

Data Warehousing, Database, SQL Documentation, SQL Download, SQL White Papers

Microsoft SQL Server 2008 R2 November Community Technology Preview Building on SQL Server 2008, R2 provides an even more scalable data platform with comprehensive tools for managing your databases and applications, improving the quality of your data, and empowering your users to build rich analyses and reports using tools they…

SQLAuthority News – Subscribe to Blog – Search a Blog

November 27, 2009

Pinal Dave

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

Quite often I get request if I send blog post in newsletter or through email. Here are few important links. You can for sure get email of my post, however, I strongly suggest to visit blog as if there are any updates in my post they are reflected on blog.…

SQLAuthority News – SQL Server 2008 Analysis Services Performance Guide

November 26, 2009

Pinal Dave

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

Business Intelligence, SQL Documentation, SQL Download, SQL White Papers

Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white paper organizes performance tuning techniques into the following three segments. Enhancing Query Performance – Query performance directly impacts the quality of the end user experience. As such, it is the primary benchmark…

SQL SERVER – Comma Separated Values (CSV) from Table Column

November 25, 2009

Pinal Dave

SQL Tips and Tricks

Best Practices, CSV, SQL Scripts, SQL Server, SQL XML

I use following script very often and I realized that I have never shared this script on this blog before. Creating Comma Separated Values (CSV) from Table Column is a very common task, and we all do this many times a day. Let us see the example that I use frequently and its output.

SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY

November 24, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL View

Today we will go over a very simple, but interesting subject. The following error is quite common if you use ORDER BY while creating any view: Msg 1033, Level 15, State 1, Procedure something, Line 5 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and…