All Articles - SQL Authority with Pinal Dave

SQL SERVER – TRIM() Function – UDF TRIM()

April 24, 2007

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Server does not have function which can trim leading or trailing spaces of any string. TRIM() is very popular function in many languages. SQL does have LTRIM() and RTRIM() which can trim leading and trailing spaces respectively. I was expecting SQL Server 2005 to have TRIM() function. Unfortunately, SQL…

SQL SERVER – Six Properties of Relational Tables

April 24, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Relational tables have six properties: Values Are Atomic This property implies that columns in a relational table are not repeating group or arrays. The key benefit of the one value property is that it simplifies data manipulation logic. Such tables are referred to as being in the “first normal form”…

SQL SERVER – 2005 Collation Explanation and Translation

April 24, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Collation

Just a day before one of our SQL SERVER 2005 needed Case-Sensitive Binary Collation. When we install SQL SERVER 2005 it gives options to select one of the many collation. I says in words like ‘Dictionary order, case-insensitive, uppercase preference’. I was confused for little while as I am used…

SQL SERVER – 2005 Query Analyzer – Microsoft SQL SERVER Management Studio

April 23, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio, SQL Utility

Following may be very simple to some and helpful to other type of question. I have seen this in my server log as well as this has been always first question in my Developer Team. Where is SQL SERVER 2005 Query Analyzer? SQL SERVER 2005 has combined Query Analyzer and…

SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column value of the table

April 23, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Identity, SQL Index, SQL Scripts, SQL Server, SQL System Table

Following script will return all the tables which has identity column. It will also return the Seed Values, Increment Values and Current Identity Column value of the table. SELECT IDENT_SEED(TABLE_NAME) AS Seed, IDENT_INCR(TABLE_NAME) AS Increment, IDENT_CURRENT(TABLE_NAME) AS Current_Identity, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE OBJECTPROPERTY(OBJECT_ID(TABLE_NAME), 'TableHasIdentity') = 1 AND TABLE_TYPE = 'BASE…

All Articles hand-gesture-raising-the-index-finger-512x400

SQL SERVER – Understanding new Index Type of SQL Server 2005 Included Column Index along with Clustered Index and Non-clustered Index

April 23, 2007

Pinal Dave

SQL Performance

SQL Constraint and Keys, SQL Index, SQL Scripts, SQL Server

Clustered Index Only 1 allowed per table Physically rearranges the data in the table to conform to the index constraints.

SQL SERVER – Raid Configuration – RAID 10

April 22, 2007

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Database, SQL Data Storage, SQL Utility

I get question about what configuration of redundant array of inexpensive disks (RAID) I use for my SQL Servers. The answer is short is: RAID 10. Why? Excellent performance with Read and Write. RAID 10 has advantage of both RAID 0 and RAID 1. RAID 10 uses all the drives…

SQL SERVER – @@DATEFIRST and SET DATEFIRST Relations and Usage

April 22, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Utility

The master database’s syslanguages table has a DateFirst column that defines the first day of the week for a particular language. SQL Server with US English as default language, SQL Server sets DATEFIRST to 7 (Sunday) by default. We can reset any day as first day of the week using…

SQL SERVER – Fix : Error 1418 – Microsoft SQL Server – The server network address can not be reached

April 22, 2007

Pinal Dave

SQL

Computer Network, SQL Error Messages, SQL Server, SQL Server Security, SQL Utility

Error: 1418 – Microsoft SQL Server – The server network address can not be reached or does not exist. Check the network address name and reissue the command
The server network endpoint did not respond because the specified server network address cannot be reached or does not exist.

SQL Server Interview Questions and Answers Complete List Download

April 21, 2007

Pinal Dave

SQL Interview Questions and Answers

Best Practices, Database, SQL Scripts, SQL Server

This is summary blog post for SQL Server Interview Questions and Answers. Click here to get free chapters (PDF) in the mailbox.