SQL Tips and Tricks Archives - Page 518 of 536 - SQL Authority with Pinal Dave

SQL SERVER – 2005 Limiting Result Sets by Using TABLESAMPLE – Examples

May 27, 2007

Introduced in SQL Server 2005, TABLESAMPLE allows you to extract a sampling of rows from a table in the FROM clause. The rows retrieved are random and they are are not in any order. This sampling can be based on a percentage of number of rows. You can use TABLESAMPLE…

SQL SERVER – 2005 Replace TEXT with VARCHAR(MAX) – Stop using TEXT, NTEXT, IMAGE Data Types

May 26, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Datatype, SQL String

Yesterday, in Friday Afternoon team meeting. I was asked question by one of application developer “I am asked in new coding standards to use VARHCAR(MAX) instead of TEXT. Is VARCHAR(MAX) big enough to store TEXT field?” Well, I realize that I was not clear enough in my coding standard. It…

SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key

May 26, 2007

Pinal Dave

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

SQL Index, SQL Scripts

One of the basic Database Rule I have is that all the table must Clustered Index. Clustered Index speeds up performance of the query ran on that table. Clustered Index are usually Primary Key but not necessarily. I frequently run following query to verify that all the Jr. DBAs are…

SQL SERVER – Stored Procedure to display code (text) of Stored Procedure, Trigger, View or Object

May 25, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure, SQL Trigger, SQL View

This is another popular question I receive. How to see text/content/code of Stored Procedure. System stored procedure that prints the text of a rule, a default, or an unencrypted stored procedure, user-defined function, trigger, or view. Syntax sp_helptext @objname = 'name' sp_helptext [ @objname = ] 'name' [ , […

SQL SERVER – Disadvantages (Problems) of Triggers

May 24, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Trigger

One of my team member asked me should I use triggers or stored procedure. Both of them has its usage and needs. I just basically told him few issues with triggers. This is small note about our discussion. Disadvantages(Problems) of Triggers It is easy to view table relationships , constraints,…

SQL SERVER – 2005 Retrieve Configuration of Server

May 24, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Few days ago I was asked what is our SQL Server’s configuration. I provided way more information then they requested. Run following script and it will provide all the information about SQL Server . SQL Server provides in detailed information if Advanced Options are turned on. It is very clear…

SQL SERVER – NorthWind Database or AdventureWorks Database – Samples Databases

May 23, 2007

Pinal Dave

SQL Tips and Tricks

SQL Download, SQL Sample Database, SQL Server, SQL Server Express

SQL Server 2005 does not install sample databases by default due to security reasons.I have received many questions regarding where is sample database in SQL Server 2005. One can install it afterward. AdventureWorks and AdvetureWorksDS are the new sample databases for SQL Server 2005, they can be download from here. Let us learn how to install NorthWind Database – samples databases.