All Articles - SQL Authority with Pinal Dave

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

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.