Search Results | SQL Server Performance Forums

Index Fragmentation

Thread by: DanCassell, Feb 15, 2007, 3 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi I have a reference table with 791 rows. Using dm_db_index_physical_stats it says that the average framentation for this clustered index is...

Auto Update Statistics

Thread by: DanCassell, Mar 15, 2006, 7 replies, in forum: Performance Tuning for DBAs

I've noticed that the the Auto Update Statistics option seems to UPDATE STATISTICS using a very very small sample. We have recently updated the...

DataWarehouse: Star Schema or Normalised database?

Thread by: DanCassell, Dec 2, 2005, 7 replies, in forum: Analysis Services/Data Warehousing

Hi I need some advice on designing a DataWarehouse... We are currently using 2000 (upgrading to 2005 soon) for out OLTP database which is currently...

Parameters

Thread by: DanCassell, Nov 29, 2005, 3 replies, in forum: Performance Tuning for DBAs

Hi Can someone please explain to me why when I run the following 2 queries in Query Analyser that Query 1 takes significantly longer to run than...

bcp warning

Thread by: DanCassell, Sep 23, 2005, 6 replies, in forum: General DBA Questions

When running the bcp command I get the following warning: SQLState = 01S05, NativeError = 0 Warning = [Microsoft][ODBC SQL Server Driver]Cancel...

bcp error file

Thread by: DanCassell, Sep 14, 2005, 1 replies, in forum: General DBA Questions

Hi I am using the -e argument in a bcp command to create a file of any rows that it fails to transfer. Even if there are no errors, it will create...

BDCC CHACHESTATS

Thread by: DanCassell, Sep 7, 2005, 16 replies, in forum: General DBA Questions

Can anyone tell me why DBCC CACHESTATS returns all zeros? It seems to return zeros on our servers that have SP3, but works fine on the server that...