Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority News – Author Visit – SQL Hour at Patni Computer Systems

October 7, 2008

MVP, SQL User Group, SQLAuthority Author Visit

Ahmedabad SQL Server User Group has started organizing a special event, “SQL Hour”, where we visit IT companies and interact with the SQL Server professionals. We had the first meeting this Saturday, 4th October 2008 at Patni Computer Systems, Gandhinangar. This meeting was lead by SQL Server User Group President…

SQLAuthority News – Upgrade SQL Server With SA Renamed – Rebuild System Databases – SQL Server 2008

October 6, 2008

Pinal Dave

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

Database

I recently came across two interesting blog post by PSS SQL Server Engineers. They have written two interesting SQL Server 2008 related post and it can be very helpful to those who come across the issues mentioned in them. How to Rebuild System Databases in SQL Server 2008 Rarely but…

SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported – VS SP1 ISO Download

October 5, 2008

Pinal Dave

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

Software Development, SQL Download, SQL Utility

I previously wrote article SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported where I discussed how downloading Visual Studio SP1 will fix the error of Visual Studio 2008 connecting to SQL Server 2008. I have provided link to SP1 which…

SQLAuthority News – Cumulative update package 1 for SQL Server 2008

October 4, 2008

Pinal Dave

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

SQL Download, SQL Service Pack

Cumulative update package 1 for SQL Server 2008 is released. Click on link : http://support.microsoft.com/kb/956717/en-us Update : I have received few emails where developer did not find where to click on the support page to download the update package. Following image describes the link which is on very top of…

SQL SERVER – 2008 – Find If Index is Being Used in Database

October 3, 2008

Pinal Dave

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

SQL DMV, SQL Index, SQL Scripts

It is very often I get query that how to find if any index is being used in database or not. If any database has many indexes and not all indexes are used it can adversely affect performance. If number of index is higher it reduces the INSERT / UPDATE…

SQLAuthority News – Download – Visual Studio Team System 2008 Database Edition GDR September CTP

October 3, 2008

Pinal Dave

SQLAuthority News

CTP, Database, SQL Server

In addition to providing support for SQL Server 2008 database projects, this release incorporates many previously released Power Tools as well as several new features. The new features include distinct Build and Deploy phases, Static Code Analysis and improved integration with SQL CLR projects. Database Edition no longer requires a Design Database. Therefore, it is no longer necessary to install an instance of SQL Express or SQL Server prior to using Database Edition. Let us learn about Visual Studio Team System.

SQLAuthority News – Download – Microsoft SQL Server 2008 Books Online (August 2008)

October 2, 2008

Pinal Dave

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

Database, DBA, SQL Download

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. Books Online includes the following types of information: Setup and upgrade instructions. Information about new features and backward compatibility. Conceptual descriptions of the technologies and…