The idea is to include code based on that snippet into the procedure of interest,...

So long as they have at least the first clue 😛

BTW that bloody pigeon story made it on to the local radio[/url] this morning....

SELECT client_net_address

FROM sys.dm_exec_connections

WHERE session_id = @@SPID

AND net_transport = N'TCP'

Yes, and if you are going to just post and say "look in BOL", why not provide a link too?

Not everyone has immediate access to BOL locally, and not everyone...

Drive-by post:

From a quick look, it seemed that the check constraints do not match the range values for the *single partition* (number 2 I think it was)...

Check the partition range...

That is quite obviously a compilation lock - it says so 😉

See SQL Server blocking causes by COMPILE locks

I have seen this in the past in several very different circumstances...

EdVassie (9/10/2009)

---

The advice about puting each filegroup on its own RAID set has a good intention at its heart, but is not really correct.

SQL Server can initiate multiple I-O streams...

Look here

It's not entirely clear from your description, but it seems the application is not MAX data type aware.

Two solutions spring to mind: upgrade the application (presumably not an option) or...

It's under $SQL_Server_Install_Path\Microsoft SQL Server\MSSQL.1\MSSQL\FTDATA\ and the name depends on the language.

See...

This is a complex subject. A comprehensive discussion of the issues surrounding when to use XML, [n]varchar(max), and varbinary(max) storage can be found here

I would also add the ROW_OVERFLOW_DATA...

wjmsdn (9/10/2009)

---

I was hoping that there was an xml format which would supply the query, and by using it i would gain an entry point for other consumers, such as...

Adam,

SYSNAME might be preferred over NVARCHAR(128). SYSNAME will always reflect the correct definition between versions of SQL Server (it has changed before). Unless you are planning to migrate...

Cool. Post back if/when you get stuck.

This is no longer true in 2005 and...