GilaMonster (10/11/2010)

---

I have, but it's hardly a cheap...

Adding in, the indexes are much, much, smaller (typically) than your data. So if you are scanning these, it is quicker than scanning the CI (as Gail noted).

Licensing highly depends on company size. Some companies get Enterprise agreements that allow upgrades at minimal cost.

SQL 2008 was supposed to be the same upgrade cost as moving to 2008,...

If you search index rebuild on this site, there are numerous scripts to help here.

I believe these are full text indexes in 2005.

Does this help? Look for the moving full text : http://msdn.microsoft.com/en-us/library/ms345483.aspx

For some reason "California Girls" runs through my head when I read that

"...Daisy Dukes, bikinis on top..."

JenMidnightDBA (10/8/2010)

---

Steve,

Both in person and in your editorial today, you directly addressed the elephant in the room, the subject we all skirted: sex, and the issues surrounding it. ...

This help?

http://www.sqlservercentral.com/scripts/foreign+keys/69110/

ManyHats11 (10/8/2010)

---

This was a great series of posts and I am going to risk controversy by saying that the post Steve wrote was the easiest to relate to - probably...

Please don't post questions about SQL Server 2008 R2 in this thread. That is a separate product and has completely separate patches.

There is a build list here for SQL...

You can look up scripts for each of these items. There isn't a comprehensive script I'm aware of that will do all of these.

You shouldn't have to monitor SQL Server...

You can use Performance Monitor to check the memory being used by SQL Server.

You are welcome, and glad things worked out for you.

I would agree this is not a bug. What you are doing is done very, very rarely. Therefore it's not something that you necessarily would want to impact performance by...

You are showing separate rows, not columns. If that what you mean?

Is this a string you are splitting or are these columns somehow that have data in them?