May 26, 2007 - SQL Authority with Pinal Dave

Jun 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

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

May 26, 2007

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…