SQL Archives - Page 502 of 519 - 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 – 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…

SQL SERVER – Top 15 free SQL Injection Scanners – Link to Security Hacks

May 21, 2007

Pinal Dave

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

SQL Download, SQL Server Security

SQL injection is a technique for exploiting web applications that use client-supplied data in SQL queries, but without first stripping potentially harmful characters. Checking for SQL Injection vulnerabilities involves auditing your web applications and the best way to do it is by using automated SQL Injection Scanners. Security-Hacks.com compiled a…