All Articles - SQL Authority with Pinal Dave

SQL SERVER – mssqlsystemresource – Resource Database

July 27, 2008

SQL Backup and Restore, SQL Scripts, SQL System Table

Just a day ago I received following email “Dear Pinal, While I was exploring my computer in directory C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data I have found database mssqlsystemresource. What is mssqlsystemresource? Thanks, Joseph Kazeka” Simple question like this are very interesting. mssqlsystemresource is Resource Database. It is read only database and…

SQLAuthority News – Readers Selection – Readers Most Favorite Articles

July 26, 2008

Pinal Dave

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

I have been receiving many emails from my readers about their favorite article. Few days ago, I asked in one of my post SQLAuthority News – Updated My Personal Book Mark Pages, which articles are most favorite articles of my readers. I have received tremendous response to my question and…

SQLAuthority News – SQLAuthority T-Shirts, Mug, Hat and Other Product

July 25, 2008

Pinal Dave

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

SQL T-Shirt

I frequently get request for SQLAuthority T-Shirts. After continuous requests from many of loyal readers, I am posting link to SQLAuthoirty Products. SQLAuthority Products I have no intention to make money from this site or any product sale. All the product are sold from the site directly at no profit…

SQL SERVER – DBCC SHRINKFILE Takes Long Time to Run

July 25, 2008

Pinal Dave

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

SQL Server DBCC

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.