We have a system test environment as well which developers have do access to, otherwise it invalidates the environment. All builds are applied here and then once passed applied to...

sp_spaceused gives an approximate row count (pretty accurate unless your doing loads of inserts when you call it) and the amount of data used, reserved and used for indexes

Simon Sabin

Co-author...

Even better is to use the FULL JOIN this will show records missing in both tables

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

We have full auditing on tables, and only store the changed data. Peformance is not really an issue because we have very narrow tables.

The triggers are generated from a script...

The indexed view cannot include the getdate() function as you have found. You have to create the indexed view without it and then a view with it.

You could create a...

I have done a detailed examination of the OPENXML for the book below, but not looked at the FOR XML part.

You can put the XML processing on the client...

I believe to have them accessible through EM you have to have them configured for the NT user that SQL server is running under.

You can specify what you want if...

Not possible all the parameters are fixed.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

My understanding of what it states is that it will read and write 8K pages "an io" if more than this is required it can read on extent into non-contigous...

This will happen if no user can be identified on the connection and you are trying to connect using trusted connection.

This would occur if you use TCP/IP.

Simon Sabin

Co-author of...

Agree with everythign said. You can write an article from either point of view. It is interesting that the replication section is one paragraph, I understand that its not up...

Due to the fact that is crashing the server, I would believe that it's your dll thats failing. You could run it under com+ which should protect the server more.

You...

I believe SQL XML 3.0 uses MSXML 4.0 for the IIS side of SQLXML but OPENXML does not use MSXML4.0. This is clear when you try and use some of...

You will be better off using the having clause.

SELECT c.company, c.contact, h.historreference

FROM contact c

INNER JOIN (SELECT contactid ,

...

I assume it is using profiler, if so the level of tracing you must have, will be seriously reducing performance. You would be much better off using lumients log explorer....