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

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

May 26, 2007

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

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.

SQL SERVER – 2005 Explanation Left Semi Join Showplan Operator and Other Operator

May 23, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins

I come across very interesting documentation about Joins, while I was researching about article about EXCEPT yesterday. There are few interesting kind of join operations exists when execution plan is displayed in text format. Left Semi Join Showplan Operator The Left Semi Join operator returns each row from the first…

SQLAuthority News – T-Shirts in Action

May 22, 2007

Pinal Dave

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

SQL T-Shirt

Thank you All for great response to SQLAuthority T-Shirts. I have ran out of all of them. Please put your request here. I will go over all of them soon and see what I can do. They are made from high quality fiber and very comfortable. Reference : Pinal Dave…