Many thanks, folks.

Sorting depends on collation (or can depend on collation).

In which case one would expect a clustered index on varchar etc columns to have to be rebuilt to take into account...

Grant Fritchey (6/29/2009)

---

It's using the index on SiteMap2 that has both columns because that makes it a covering index.

Don't use the cost estimates as a measure of query performance....

Jack Corbett (6/29/2009)

---

I would definitely say you are on the right track. Query1 will not need a bookmark lookup to the get the parentUrl because parentUrl is an included...

Jack Corbett (6/29/2009)

---

All that discussion is why I prefer abnormal forms 😛

Also as far as the cube/office setup discussion, the only thing I miss about my cube is the ability...

Thanks Brad,

I actually downloaded and perused that very document after you recommended it to me at SQLBits!

That, and your presentation from SQLBits that you kindly sent to me are providing...

I am an accidental DBA who intends to become a recognised one.

If that makes sense!

I don't doubt that for a second, now...

Paul White (6/26/2009)

---

Hey mazzz,

Take a look at the huge library of generally useful scripts also available for free on this very site - see the scripts link on the sidebar

<---...

SQLZ (6/26/2009)

---

I run a similar query to yours but I regularly dump that data into a dba database I've created and then I've hooked reporting services into it, which allows...

Gail - that's made me feel a bit better 🙂

SQLZ - thanks loads, very useful!

Paul - heh, I was having the exact sentiments about the -1 offset until SQLZ came...

Thanks a bunch Gail

I should have surmised this from BOL myself, actually *blush*, I don't know why that didn't make sense when I read it earlier. Good job it's Friday

On...

WayneS (6/20/2009)

---

mazzz (6/20/2009)

---

Happy Saturday, everyone

I appear to have won a year's licence for Quest's Spotlight for Sql Server, after filling in my details at their booth at the SQLBits conference!

Does...

Paul White (6/20/2009)

---

mazzz (6/20/2009)

---

Happy Saturday, everyone

I appear to have won a year's licence for Quest's Spotlight for Sql Server, after filling in my details at their booth at the SQLBits...

Happy Saturday, everyone

I appear to have won a year's licence for Quest's Spotlight for Sql Server, after filling in my details at their booth at the SQLBits conference!

Does anyone here...