Thanks for the link. I'm using SQL 2005, does all of this 200 link still apply?
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...
I know there are a lot of different factors involved, but does anyone know roughly how long it is likely to take to run UPDATE STATISTICS with...
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...
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...
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...
A scheduled job is running the following using sa... EXEC master..xp_cmdshell 'bcp "USE ConfusedLive SET NOCOUNT ON SET TRANSACTION ISOLATION LEVEL...
I am running a number of bcp commands scheduled on the same server, but there is only one that is outputting this warning. I believe that it is the...
When running the bcp command I get the following warning: SQLState = 01S05, NativeError = 0 Warning = [Microsoft][ODBC SQL Server Driver]Cancel...
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...
There are two servers that have SP3 where DBCC CACHESTATS returns zero values. On both servers, those other three DBCC commands work fine. However,...
Both the logs say Installation Succeeded at the end.
It says it's just SP3. So does DBCC CACHESTATS not work properly in SP3?
I believe it is just SP3. The version is 8.00.760. Does that mean SP3?... where do I look to find out for sure?
You can only have one dbo user per database. Every database has one and you can't delete it.
It is working but it's just returning zeros for everything. Any ideas why?
Thanks. I thought that must be ths case. If it is supposed to work on SP3 then, do you have any idea why it isn't?
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...
Separate names with a comma.
