Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – 2005 Explanation and Example – SELF JOIN

June 3, 2007

A self-join is simply a normal SQL join that joins one table to itself. This is accomplished by using table name aliases to give each instance of the table a separate name. Joining a table to itself can be useful when you want to compare values in a column to…

SQL SERVER – 2005 – Microsoft SQL Server Management Pack for Microsoft Operations Manager 2005 – Download SQL Server MOM 2005

June 2, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Download

The Microsoft SQL Server Management Pack provides both proactive and reactive monitoring of SQL Server 2005 and SQL Server 2000 in an enterprise environment. Availability and configuration monitoring, performance data collection, and default thresholds are built for enterprise-level monitoring. Both local and remote connectivity checks help ensure database availability. Features…

SQLAuthority News – Subscribe to Feed in Email

June 2, 2007

Pinal Dave

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…