Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority News – Happy Indepedance Day to India

August 15, 2008

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

India’s Independence Day is celebrated on August 15 to commemorate its independence on that day in 1947. The day is a national holiday in India. India will celebrate its 61st Independent day on August 15, 2008. Happy Independence Day to India Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – 2008 – Introduction to Online Indexing Operation

August 15, 2008

Pinal Dave

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

SQL Index, SQL Scripts, SQL Server

When index is created or recreated it usually decreases performance of database. Either SQL takes long time for response or it does not response at all as transactions are blocked. When new table or database goes live it is not possible to find out exactly how many indexes are needed.…

SQL SERVER – Get Date Time in Any Format – UDF – User Defined Functions

August 14, 2008

Pinal Dave

SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Server, SQL Stored Procedure

One of the reader Nanda of SQLAuthority.com has posted very detailed script of converting any date time in desired format. I suggest every reader of this blog to save this script in your permanent code bookmark and use it when you need it. Let us learn about User Defined Functions.

SQLAuthority News – Authors Personal Website Renovate – SQL Centric Website

August 13, 2008

Pinal Dave

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

Database, DBA, MVP

I am very pleased to announce my newly renovated website. I always liked my previous website as it was “Valid XHTML 1.1” and “Valid CSS 2.0”. Since I become MVP last month I have been receiving many emails where people were expecting more from my personal website. My blog http://www.SQLAuthority.com…

SQLAuthority News – SQL Server 2008 Pricing and Licensing

August 12, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL Licensing

Note: SQL Server 2008 Pricing and Licensing by Microsoft SQL Server licensing and pricing are to intervined subjects and very important. I strongly suggest to use properly licensed SQL Server in any production environment. The concept of licensing can be confusing sometime to new administrators. If there is any confusion…

SQLAuthority News – Microsoft SQL Server 2008 Books Online – BOL – English

August 12, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, DBA, Software Development, SQL Download, SQL Utility

SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008. The Help viewer used by Books Online requires the Microsoft .NET Framework version 2.0. Books Online includes the following types of information: Setup and upgrade…

SQLAuthority News – SQL Server 2008 Downloads Availables

August 11, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download

SQL Server Compact 3.5 SP1 for Windows Mobile SQL Server Compact 3.5 SP1 for devices Windows Installer (MSI) file contains the CAB files and the DLLs for installing SQL Server Compact 3.5 SP1 on the Windows mobile devices. SQL Server Compact 3.5 SP1 and Synchronization Services for ADO.NET v1.0 SP1…