Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – 2008 (Katmai) June CTP Released – Improvement Pillars – Diagram

June 7, 2007

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

I received quite a few emails in last three days for not mentioning on my blog about SQL Server 2008 (Katmai) CPT June is released. The reason I did not mentioned because I was busy with my mini series SQL SERVER – Database Coding Standards and Guidelines Complete List Download.…

SQL SERVER – Fix : Error : Error 15401: Windows NT user or group ‘username’ not found. Check the name again.

June 7, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, , SQL Scripts

Fix : Error : Error 15401: Windows NT user or group ‘username’ not found. Check the name again. This is quite a famous error and I was asked to write about it by couple of readers. The reason I was not writing about this as the solution of this error…

SQL SERVER – Database Coding Standards and Guidelines Complete List Download

June 6, 2007

Pinal Dave

SQL

Database, DBA, Software Development, SQL Coding Standards, SQL Download, SQL Scripts, SQL Server

Download SQL SERVER Database Coding Standards and Guidelines Complete List

SQL SERVER – Database Coding Standards and Guidelines – Part 2

June 5, 2007

Pinal Dave

SQL Interview Questions and Answers

Database, DBA, Software Development, SQL Coding Standards, SQL Download, SQL Scripts, SQL Server

SQL Server Database Coding Standards and Guidelines – Part 2

SQL SERVER – Database Coding Standards and Guidelines – Part 1

June 4, 2007

Pinal Dave

SQL

Database, DBA, Software Development, SQL Coding Standards, SQL Download, SQL Scripts, SQL Server

SQL Server Database Coding Standards and Guidelines – Part 1

SQL SERVER – Database Coding Standards and Guidelines – Introduction

June 3, 2007

Pinal Dave

SQL

Database, DBA, Software Development, SQL Coding Standards, SQL Download, SQL Scripts, SQL Server

I have received many many request to do another series since my series SQL Server Interview Questions and Answers Complete List Download. I have created small series of Coding Standards and Guidelines, as this is the second most request I have received from readers. This document can be extremely long but I have limited to very few pages as it is difficult to follow thousands of the rules. My experience says it is more productive developer and better code if coding standard has important fewer rules than lots of micro rules.

SQL SERVER – 2005 Explanation and Example – SELF JOIN

June 3, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

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…