Viewing 15 posts - 106 through 120 (of 133 total)
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...
February 13, 2009 at 8:51 am
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...
February 5, 2009 at 2:28 pm
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...
October 29, 2008 at 8:45 am
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...
October 29, 2008 at 8:33 am
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...
October 29, 2008 at 8:30 am
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...
October 7, 2008 at 8:02 am
Get job...
I agree with Ninja's_RGR'us about a single file to download.
Thomas
September 15, 2008 at 8:37 am
Great article, thanks... you should do more on SSIS
Thomas
August 21, 2008 at 7:24 am
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...
April 17, 2008 at 10:15 am
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...
March 28, 2008 at 9:58 am
What is the difference between Auto_Fix and Update_One?
ThomasLL
December 4, 2007 at 3:43 pm
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
November 19, 2007 at 5:59 am
Restart the service on each node of the cluster and the error went away...
ThomasLL
November 15, 2007 at 7:23 am
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...
August 1, 2007 at 8:42 am
You can not run 64-bit version of 2000 on non-Itanium CPUs. This forces us to upgrade to 2005.
ThomBeaux
July 11, 2007 at 8:42 am
Viewing 15 posts - 106 through 120 (of 133 total)