We get CXPACKET waits because we have some Stored Procedure queries that run in parallelism. Some of these cause so much blocking to itself, that we change the Query in...

This procedure for space does not get space taken up by text fields???

I am trying to see why Unused space on a table is large(40GB) through Disk Usage by Table...

Idera Diagnostic manager does a good job for us with putting the history in a database.

But, you can accomplish this with a Server-Side trace.

Read up on SQL Profiler, and...

Based on the couple of questions you have posted, I would suggest to you to go to some SQL Server Administristration classes focused on databases, files and maintenance.

You questions are...

reindexing in our shop depends on the application and database size.

Some are re-indexed every night, when there are no users on the system.

But the large databases (200+ GB with 40-50...

I ran DBCC ShowContig on a 2000 database, then restored it to 2005 and ran DBCC ShowContig. The results were exactly the same, which leds me to believe the indexes...

Get job...

I agree with Ninja's_RGR'us about a single file to download.

Thomas

Great article, thanks... you should do more on SSIS

Thomas

Other info:

IBM and CMA (reseller) of these IBM machines can not find one customer using these machines for production server sql machines that will share information about their configuration.

1 customer...

MS PSS Solution to the discussed problem:

I am a DBA with Noel (no longer with us) and we have a solution from PSS that seems to have worked (for the...

What is the difference between Auto_Fix and Update_One?

ThomasLL

I can follow it for a non-cluster index, but a cluster index is the table itself. Rebuild rebuilds the whole table - tree and leaf nodes?

Thomas

Restart the service on each node of the cluster and the error went away...

ThomasLL

Check with Backup software and it is not using a agent to backup SQL Server. This is a 2005 server, and the only agent available in the software is for...

You can not run 64-bit version of 2000 on non-Itanium CPUs. This forces us to upgrade to 2005.

ThomBeaux