Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – DBCC SHRINKFILE Takes Long Time to Run

July 25, 2008

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

If you are DBA who are involved with Database Maintenance and file group maintenance, you must have experience that many times DBCC SHRINKFILE operations takes long time but any other operations with Database are relative quicker. Rebuilding index is quite resource intensive task but that happens faster than DBCC SHRINKFILE.…

SQL SERVER – 2005 -Track Down Active Transactions Using T-SQL

July 24, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL System Table, SQL Transactions

Just a day ago, I was wondering how many active transaction are currently in my database. I found following DMV very useful – very simple and to the point. Following SQL will return currently active transaction. SELECT * FROM sys.dm_tran_session_transactions Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Introduction to Log Viewer

July 23, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security, SQL Utility

SQL Server log data is very important for any DBA to troubleshoot SQL Server related problems. In SQL Server 2000 there was no facility to check System and Application log, however in SQL Server 2005 there is facility of the log viewer. It is very useful tool and very easy…

SQL SERVER – Clear SQL Server Memory Caches

July 22, 2008

Pinal Dave

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

SQL Scripts, SQL Server DBCC

If SQL Server is running slow and operations are throwing errors due to lack of memory, it is necessary to look into memory issue. If SQL Server is restarted all the cache memory is automatically cleaned up. In production server it is not possible to restart the server. In this…

SQL SERVER – FIX – ERROR : 9004 An error occurred while processing the log for database. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.

July 21, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts

ERROR : 9004 An error occurred while processing the log for database. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log. If you receive above error it means you are in great trouble. This error occurs when database is attempted…

SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – July 19 2008

July 21, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, MVP, SQL Download, SQL User Group, SQLAuthority Author Visit

Ahmedabad SQL Server User Group is just 2 months old chapter but it is getting extremely popular among enthusiastic IT professionals. I have joined this group and suggest all the developers of Ahmedabad and surrounding areas to join this group. It does not matter which application you are using but…

SQL SERVER – Change the Port of Service Broker Configuration

July 20, 2008

Pinal Dave

SQL Tips and Tricks

Service Broker, SQL Scripts, SQL Server

Just two days ago, I wrote a small note about SQL SERVER – Introduction to Service Broker.