Okay, I think I've got my head round this at last.

What was confusing me was that I was under the impression that Fillfactor affected data pages and the rows in data...

That is partly right. Fill Factors are disregarded whilst performing standard insert/update/delete operations on a table (otherwise SQL Server would need to do page splits to maintain the original density...

The value shown for Space Available in EM is unreliable. Try increasing the size of the database and then running:

EXEC sp_spaceused @updateusage = 'TRUE'

It also sounds as though you may...

Just to clarify, I backed up the log using the WITH TRUNCATE_ONLY option. I'm not aware of any practical difference between that and issuing a CHECKPOINT statement for a db...

Hi XYZ

I'd be very interested to hear your experiences of the upgrade. Who carried it out? How long did it take? What was the downtime? Was it difficult? What precautions did...

Well, that will be the problem then. As I mentioned there is a firmware upgrade available which purports to resolve the problem but our suppliers tell us that they have never...

Oops, sorry about the incomplete post...

I'd be really interested to know if your server has an HP MSA1000 disk controller.

We've been getting these...

We've been getting these errors at a rate of about one per month for a while now. We believe that the issue is related to our disk controller's...

Assuming that your text file doesn't contain the identity column values and the columns in the text file are in the correct order, try

BULK INSERT Sport.dbo.game

   FROM 'C:\SourceFile.txt' --Change as appropriate

   WITH...

Steve I agree with you that you can't check file size or file space retroactively but backup file size is stored in the backupfile table in the msdb database isn't...

There is no problem with the set statement where @FilterCmd is concatenated. The problem is in the final select statement. The WHERE clause is incorrect.

This was a Question Of The Day. You can resort to mixed mode by doing the following:

Stop SQL Service down,

set the value of HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode to 2 in the registry,

Restart...

If you are trying to find any procs that mention SHIPPING_TOTAL try the following:

SELECT DISTINCT SO.name

FROM  sysobjects SO

JOIN  syscomments SC

ON  SO.id = SC.id

WHERE  SC.text LIKE '%SHIPPING_TOTAL%'

ORDER BY SO.name

Thanks for the suggestion but I'm not sure how the File Scripting Object would work. Would it involve doing a Windows copy? If so, it will not be quick enough for our...

The answer could be either or both. It depends on the nature of the SQL query and the event(s) that you wish to capture.

The SQL:BatchStarting, SQL:BatchCompleted, SQL:StmtStarting and SQL:StmtCompleted events...