Viewing 15 posts - 106 through 120 (of 131 total)
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
What about autogrow on the database? Is it have to expand every 5 minutes.
Monitor Page Splits on tables and indexes. Use a Fill Factor.
ThomBeaux
March 15, 2007 at 2:37 pm
Viewing 15 posts - 106 through 120 (of 131 total)