Heh good point shows how much attention I paid to the output of dbcc showcontig didn't even pay attention to the number of pages scanned....

If i'm desigining a new database and very little idea about the usage in terms of updates versus reads I usualy start with a fill factor of 95% and then...

Yes to get a better page density you have to increase your fill factor.

You'll be able to tell if you have  alot of page splits by looking at

Logical Scan Fragmentation...

If the table was read only yes you would want a very high fill factor as there will be no updates to that could cause page splitting etc.

The fill factor...

dbcc dbreindex will rebuild your indexes with their original fill factor and this why you will have a low average page density. You find out the original fill factor from...

To find out if anything in your current setup is not compatible with sql server 2005 go to the microsoft sql server homepage and download the upgrade advisor tool.

I have...

Is the query captured from sql profiler part of a stored procedure?

If so have you captured the execution plan for this procedure from sql profiler and compared it to the estimated execution plan produced...

Is this the same query that's being run from query analyzer as from the application?

If not do are the people writing the ad-hoc queries in query analyzer proficient in SQL?...

I've not seen this on any of my servers before but given the final message about the the lazywriter I just wonder if for some reason there is not enough...

I can't say that I am 100 percent sure but looks like output from a trace flag to me as a lot of them write to the log by default...

The restore history table in the msdb database contains a row for each restore operation that has occurred.

hth

David

Looking at your code this trigger will only work if one row at a time is updated.

In sql server a trigger is not fired once per row update but once...

Are you sure the network guys haven't been playing the security configuration tool in Windows 2003 sp 1 and haven't just blocked the port used to do the monitoring with...

Don't you just query syscolumns for entries where colstat = 1?

David

You can do it by using xp_cmdshell to execute a reg query or execute a wmi script (if you need examples see technet)

In the resgisty you need to query HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\objectname

This...