All Articles - SQL Authority with Pinal Dave

SQL SERVER – Msg: 2593 : There are ROWCOUNT rows in PAGECOUNT pages for object ‘OBJECT’.

February 16, 2008

SQL Error Messages, SQL Server, SQL Server DBCC

There are ROWCOUNT rows in PAGECOUNT pages for object ‘OBJECT’.

This message is displayed when DBCC command is ran for any database. It is harmless and displayed for information purpose only. For each database DBCC commands displays number of rows and number of pages it is using. DBCC CHECKALLOC is exception for this messages.

SQL SERVER – Index Reorganize or Index Rebuild

February 15, 2008

Pinal Dave

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

SQL Index

Recently, I have received one question quite often about when to Index Reorganize and when to Index Rebuild. I have already written about this topic earlier but it seems that many are unable to search it. SQL SERVER – Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script…

SQL SERVER – Introduction to Performance Monitor – How to Use Perfmon

February 14, 2008

Pinal Dave

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

SQL Utility

Yesterday I wrote about SQL SERVER – Introduction to Three Important Performance Counters. I received few questions about how to use Perfmon. Here is very brief introduction to Perfmon. There are three ways to launch Perfmon. 1) Type “start perfmon” at the command prompt. 2) Go to Start | Programs…

SQL SERVER – Introduction to Three Important Performance Counters

February 13, 2008

Pinal Dave

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

SQL Utility

Performance Counters are very important to evaluate. There are more than thousands of Performance Counters. Today I will cover three basic but very important Performance Counters. Processor:% Processor Time It reports the total processor time with respect to the available capacity of the server. If counter is between 50 to…

SQL SERVER – Get Current Database Name

February 12, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Yesterday while I was writing script for SQL SERVER – 2005 – Find Unused Indexes of Current Database . I realized that I needed SELECT statement where I get the name of the current Database. It was very simple script. SELECT DB_NAME() AS DataBaseName It will give you the name…

SQL SERVER – 2005 – Find Unused Indexes of Current Database

February 11, 2008

Pinal Dave

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

SQL Index, SQL Scripts

Simple but accurate following script will give you list of all the indexes in the database which are unused. If indexes are not used they should be dropped as Indexes reduces the performance for INSERT/UPDATE statement. Indexes are only useful when used with SELECT statement. Script to find unused Indexes.…

SQLAuthority News – RIP: Ken Henderson, 1967 – 2008

February 10, 2008

Pinal Dave

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

Database, DBA, SQL Download

Ken Henderson, a nationally recognized consultant and leading DBMS practitioner, consults on high-end client/server projects away on Sunday, January 27, in Meeker, Oklahoma. Ken was an inspirational author of the SQL Server Guru’s Guide series of books. We will miss his forever. He was the author I respected the most.…

SQLAuthority News – 2008 – Download – SQL Server 2008 Brochure

February 9, 2008

Pinal Dave

SQLAuthority News

Data Warehousing, Database, DBA, Software Development, SQL Server

SQL Server 2008 Brochure is available to download. It contains many information like available Server Editions, Top New Features, New Available Technologies and additional resources.

SQL SERVER – Microsoft SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity Framework Beta 3

February 8, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, DBA, SQL Download

SQL Server Compact 3.5 SP1 Beta release for the ADO.Net Entity Framework Beta 3 enables the following scenarios: Applications can work in terms of a more application-centric conceptual model, including types with inheritance, complex members, and relationships Applications are freed from hard-coded dependencies on a particular data engine or storage…

SQL SERVER – Sharpen Your Basic SQL Server Skills – Database backup demystified

February 7, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Backup and Restore, SQL Data Storage, SQL Scripts

Read my article in SQL Server Magazine January 2007 Edition I will be not able to post complete article here due to copyright issues. Please visit the link above to read the article. [Articles are relocated so links are disabled] Reference : Pinal Dave (https://blog.sqlauthority.com)