Database Archives - Page 54 of 55 - SQL Authority with Pinal Dave

SQL SERVER – 2008 Katmai – Your Data, Any Place, Any Time

May 10, 2007

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

I was following up on the news of first Microsoft Business Intelligence (BI) Conference held at Seattle. Good news is – SQL Server 2008 code name ‘Katmai’ is announced. I went to the official website I like the catchy line “Your Data, Any Place, Any Time“. As per my opinion…

SQL SERVER – 2005/2000 Examples and Explanation for GOTO

May 7, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Scripts, SQL Utility

The GOTO statement causes the execution of the T-SQL batch to stop processing the following commands to GOTO and processing continues from the label where GOTO points. GOTO statement can be used anywhere within a procedure, batch, or function. GOTO can be nested as well. GOTO can be executed by…

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…