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

SQL SERVER – 2005 – Explanation and Script for Online Index Operations – Create, Rebuild, Drop

August 17, 2007

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

SQL Server 2005 Enterprise Edition supports online index operations. Index operations are creating, rebuilding and dropping indexes. The question which I receive quite often – what is online operation? Is online operation is related to web, internet or local network? Online operation means when online operations are happening the database…

SQL SERVER – 2005 – Difference and Similarity Between NEWSEQUENTIALID() and NEWID()

August 16, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts

NEWSEQUENTIALID() and NEWID() both generates the GUID of datatype of uniqueidentifier. NEWID() generates the GUID in random order whereas NEWSEQUENTIALID() generates the GUID in sequential order. Let us see example first demonstrating both of the function. USE AdventureWorks; GO ----Create Test Table for with default columns values CREATE TABLE TestTable…

SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE

August 15, 2007

Pinal Dave

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

SQL Scripts, SQL Stored Procedure

Following three questions are many times asked on this blog. How to insert data from one table to another table efficiently? How to insert data from one table using where condition to another table? How can I stop using cursor to move data from one table to another table? There…

SQL SERVER – Fix : ERROR : Msg 1033, Level 15, State 1 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.

August 12, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts

Following error is encountered when view is attempted to created with ORDER BY clause in it. ORDER BY clause is not allowed in views in SQL Server 2005. This solution also displays the workaround to use ORDER BY in VIEW. I really do not prefer to use views. My views…

SQL SERVER – UDF – Validate Integer Function

August 11, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

I received quite a good feedback about my post about SQL SERVER – Validate Field For DATE datatype using function ISDATE() One of the most interesting comment I received from my reader from Canada. I was suggested just like ISDATE() to write about ISNUMERIC() which can be used to validate…

SQL SERVER – 2005 – Find Stored Procedure Create Date and Modified Date

August 10, 2007

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Stored Procedure, SQL System Table

This post is second part of my previous post about SQL SERVER – 2005 – List All Stored Procedure Modified in Last N Days

SQL SERVER – 2005 – List All The Column With Specific Data Types

August 9, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Datatype, SQL Scripts, SQL System Table

Since we upgraded to SQL Server 2005 from SQL Server 2000, we have used following script to find out columns with specific datatypes many times. It is very handy small script. SQL Server 2005 has new datatype of VARCHAR(MAX), we decided to change all our TEXT datatype columns to VARCHAR(MAX).…