Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Mirrored Backup Introduction and Explanation

December 25, 2007

SQL Server 2005 Enterprise Edition and Development Edition supports mirrored backup. Mirroring a media set increases backup reliability by adding redundancy of backup media which effectively reduces the impact of backup-device failing. While taking backup of database, same backup is taken on multiple media or locations. T-SQL code to take…

SQL SERVER – Delete Duplicate Records – Count Duplicate Records Links

December 25, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I have wrote following two articles for Duplicate Rows Management in SQL Server. SQL SERVER – Count Duplicate Records – Rows SQL SERVER – Delete Duplicate Records – Rows Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Object Oriented Database Management Systems

December 24, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, DBA, Software Development

I have received few emails and comments about why I do not write about Object Oriented Database Management Systems (OODBMS). The reason for that is that I am big follower of Relational Database Management Systems (RDBMS) and that particularly of Microsoft SQL Server. If you are interested in reading about…

SQLAuthority News – Download Microsoft SQL Server 2000/2005 Management Pack

December 24, 2007

Pinal Dave

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

SQL Download

Note: Download Microsoft SQL Server 2000/2005 Management Pack by Microsoft The SQL Server Management Pack monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems. Availability and performance monitoring is done using synthetic transactions. In addition, the Management Pack collects Event Log…

SQLAuthority News – Jobs, Search, Best Articles, Homepage

December 24, 2007

Pinal Dave

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

Database, DBA

If you are looking for solution of any of your question : Search SQLAuthority If you are looking for best job in IT field : Find Job or email pinal@sqlauthority.com If you are looking for talented IT professional : Post Job or email pinal@sqlauthority.com If you want to read my…

SQL SERVER – 2008 – New DataTypes DATE and TIME

December 23, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

One of our project manager asked me why SQL Server does not have only DATE or TIME datatypes? I thought his question is very valid, he is not DBA however he understands the RDBMS concepts very well. I find his question very interesting. I told him that there are ways…

SQL SERVER – Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script

December 22, 2007

Pinal Dave

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

SQL Index, SQL Scripts

Index Rebuild : This process drops the existing Index and Recreates the index. USE AdventureWorks; GO ALTER INDEX ALL ON Production.Product REBUILD GO Index Reorganize : This process physically reorganizes the leaf nodes of the index. USE AdventureWorks; GO ALTER INDEX ALL ON Production.Product REORGANIZE GO Recommendation: Index should be…