That's an awesome article Jeff!

Now if only I could work out how to run a query that traverses a directed graph with cycles - but where there is a...

Jeff Moden (11/9/2009)

---

It was intended only as posted... I wanted to know why someone wanted to know this level of detail especially since I'm pretty sure they can't change it...

Paul White (11/9/2009)

---

ta.bu.shi.da.yu (11/9/2009)

---

It was the " It's not like you'll be able to change it or take advantage of it." It seemed like a pretty reasonable question to me!...

Paul White (11/9/2009)

---

I think...

So I did. Sorry.

That seems a bit rude!

I'm curious whether truncating the table might not be a better idea here? If there are foreign key contraints that reference the table this won't work, of course, but then...

Wouldn't it depend on the usage?

But funny you should mention this though, I was just reading Karen Delaney's query tuning and optimization book, and she gives the example in...

Florian Reischl (10/28/2009)

---

First let me correct your sample SQL

create table #table1 (colA INT, colB INT)

create table #table2 (colA INT)

insert into #table1 values (1, 567)

insert into #table2 values (1)

insert into #table2...

Sorry... I think I've been unclear... I would like to make the inner join return more than one result (return 4 results, like the subquery).

rbramhall (10/28/2009)

---

I just wish there was another way that when inserting/deleting the 2.5M records in my table it wouldn't do a total table lock and at 2-3 minutes it causes...

There's something I'm a bit confused about here...

It's the following:

AVG_RANGE_ROWS: 176.7533 -- number of records for each distinct value (those within the DISTINCT_RANGE_ROWS)

Now how can you have a part of...

ItalianOlgi (10/19/2009)

---

GSquared (10/16/2009)

---

Because it tastes better that way.

(Others reading this thread, be aware that...

All the Microsoft links point to info about the 64-bit versions of Windows. Is this feature restricted to this platform?

"The best way to handle rights and access is to selectively apply permissions to individuals, matching up their skills with their rights. If a user has problems creating indexes or...