SQL Scripts Archives - Page 241 of 318 - SQL Authority with Pinal Dave

SQL SERVER – Difference TempTable and Table Variable – Table Variable in Memory a Myth

December 15, 2009

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

Recently, I have been conducting many training sessions at a leading technology company in India. During the discussion of temp table and table variable, I quite commonly hear that Table Variables are stored in memory and Temp Tables are stored in TempDB. I would like to bust this misconception by…

SQL SERVER – ERROR: FIX: Cannot drop server because it is used as a Distributor in replication

December 11, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Replication, SQL Scripts

Replication has been my favorite subject when it comes to resolving errors. I have found that many DBAs are stuck with the solving of the problem of replication for hours; however, the solution is very easy. One of the very common errors in replication occurs when replication is removed from…

SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore

December 5, 2009

Pinal Dave

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

MVP, SQL Scripts, SQLAuthority Author Visit

I recently had opportunity to attend TechDays 2009 Infosys. The dates of the event was Nov 16-17, 2009. This event was the largest technology conference by Microsoft in Infosys. Microsoft Tech Days focused on positioning Microsoft as the company to bet on for future technology investments by businesses and consumers…

SQL SERVER – Validate an XML Document in TSQL using XSD by Jacob Sebastian

December 2, 2009

Pinal Dave

SQL

SQL Scripts, SQL Server, SQL XML

Let us learn about XML Document in TSQL using XSD by Jacob Sebastian.

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

November 30, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

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 – 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…