Jeffrey Williams (11/7/2008)

---

Matt Miller (11/7/2008)

---

Are you SURE you have SP2? As best I can recall, those thing didn't show up until SP2. I'd reapply/reinstall my client tools, and...

Tom - the challenge is that you're providing so few details as to what you're doing (who these rows you need to insert are being provided to you, do you...

Here's a way to test it:

create table fragtable (gid uniqueidentifier default newid() primary key clustered, fun int)

create index bob on fragtable(fun)

go

insert fragtable(fun)

select rand(checksum(newid()))*75

from sys.all_columns

go 30

dbcc showcontig('fragtable')

ALTER INDEX bob on fragtable...

Are you SURE you have SP2? As best I can recall, those thing didn't show up until SP2. I'd reapply/reinstall my client tools, and then repatch the machine

Hey - it's a Friday....no biggie!!!!

Speaking of which - time to replace the caffeine drip..:)

With indexes as small as you're showing (27 pages), it's not likely that a rebuild OR a defragment will do anything. the Defrag and rebuild operation focus on improving...

Matt Miller (11/7/2008)

---

IN or NOT IN turns into a series of equalities or non-equalities. Which means NULL is a killer, since that will alway return FALSE (since "NULL...

IN or NOT IN turns into a series of equalities or non-equalities. Which means NULL is a killer, since that will alway return FALSE (since "NULL is neither...

Well - you can do it a few ways. The easiest is probably to simply use the isnull function on the columns AFTER the pivot operation (i.e. in...

If you don't add in the WITH TIES, you will only get one record (even if three trainers have the same highest count).

Instead of using MAX, look into using TOP 1 with TIES.

SELECT Top 1 WITH TIES

[Booking].[Staff_Id] ,

...

I haven't been receiving any particularly creative spam recently so I've decided to GET creative with the spam I DO get.

So - I forward all of the penis...

The documenter is basically an instance of the old "you get what you pay for". It's free, therefore you get to live with its limitations.

You will get substantially better...

Elisabeth Rédei (11/7/2008)

---

Hi,

I can see how it would be true for a handful of pages (less than 8) but since the index is created from scratch, I for one cannot...

1. If I'm reading your results correctly - your index is only 233 pages big. So - while the table might be large - your index is apparently...