Hugo Kornelis (10/19/2010)

---

The same page in Books Online also contains this warning: "Partitioned tables and indexes are not fully supported in this view; use the sys.indexes catalog view instead." ......

(One of) the fastest? Yes. The most reliable? I don't think so, because that query counts both...

Could you please zip that script and attach it to your next message? 🙂

This example is the query used to send a formatted html by xp_sendmail:

-- to test send output to text or file c:\temp\1.htm

SET NOCOUNT ON

select '' AS []

SELECT

' '...

Good question, but there is a link to BOL/articles/etc missing in the explanation. Should I take the explanation on trust? 🙂

The question would be more educational if it had no 'DROP CONSTRAINT' statement. In this case I would probably have answered wrong 🙂

Sorry, but this conclusion...

The question forces to make an archaeological excavation 😀

Here is the formatted (in the way I like) code:

DECLARE @Text NVARCHAR(500)

DECLARE @StringDelimiter CHAR

SELECT @Text = 'This t-sql will split these sentences into rows.' +

'How many rows will be returned?.'...

As for me, this is one of several the thousands examples of totally unformatted and obscure code. An example...

I agree with tommyh, the word 'great' is misleading in this context.

Not being a native English speaker, I deciphered...

Nice question.

OFF

What does the word 'coorker' mean? Is it a typo and needs to be 'coworker'?

Thanks to the author! That was a good lesson about the SELECT INTO statement.

Maybe because they are not compatible with SQL Server 2005 and below?

Oh, my eyes 🙂 Using JPEG for the graphic was not the best solution – GIF and PNG are more suitable formats for this.

However, I like the question.