Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority News – Subscribe to Feed in Email

June 2, 2007

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

You can subscribe to SQLAuthority.com Feed using Email. Email will be delivered to your preferred email address when new post appears on SQLAuthority.com Subscribe to SQLAuthority Feed Through Email Reference : Pinal Dave (https://blog.sqlauthority.com)

SQLAuthority News – Dedicated Search Engine for SQLAuthority – Search SQL Solutions

June 1, 2007

Pinal Dave

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

Database, DBA, Software Development, SQL Download

Visit search.SQLAuthority.com I have been receiving many questions asking for tutorials, suggestions or questions about topics I already have wrote before but readers are have not found it or having difficulty to find them. I have almost around 200 articles on this blog so far and it is growing. One…

SQL SERVER – 2005 Constraint on VARCHAR(MAX) Field To Limit It Certain Length

June 1, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts, SQL String

One of the Jr. DBA at in my Team Member asked me question the other day when he was replacing TEXT field with VARCHAR(MAX) : How can I limit the VARCHAR(MAX) field with maximum length of 12500 characters only. His Question was valid as our application was allowing 12500 characters.…

SQL SERVER – Retrieve Information of SQL Server Agent Jobs

May 31, 2007

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Server Agent, SQL Stored Procedure

sp_help_job returns information about jobs that are used by SQL Server Agent service to perform automated activities in SQL Server. When executed sp_help_job procedure with no parameters to return the information for all of the jobs currently defined in the msdb database.

SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility – Part 2 – Management Studio

May 31, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database Compatible Level, SQL Server Management Studio

I have received quite a few request about post I have two days ago SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility, if this can be done using SQL Server Management Studio. It is very simple to do this using Management Studio as well but I still…

SQL SERVER – Primary Key Must Not Contain NULL – Primary Key are NOT NULL

May 31, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys

While reviewing the search engine log for this blog I found lots of search regarding Nullable Primary Key. It is not possible. This post is especially to clear the Not Nullable Primary Key Property. The Allow Nulls property can’t be set on a column that is part of the primary…

SQLAuthority.com News – Best SQL Job Search – Best SQL Job List – Find SQL Jobs

May 30, 2007

Pinal Dave

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

Database, DBA, SQL Jobs

SQLAuthority.com News – Best SQL Job Search – Best SQL Job List – Find SQL Jobs Visit : I have been receiving two kind of requests almost every day. 1) Recruiters and Employers asking where can they find good candidates who are truly dedicated to SQL Server? 2) Job seeker…