This is what happens when an OP doesn't post the correct requirements.

Sam... please read and heed the article at the link in my signature. I'm pretty much all...

Andrew Gothard (10/3/2008)

---

You just described the code at my new job... 😛 except instead of cursors, it's...

I believe everyone knows what I'm going to say... good code can save a "slow" machine. I've seen too many people go down the primrose path of buying more...

Heh... the need for "bins" also explains the "Sort in TempB" option when rebuilding indexes. 😉

Sure... first, you have to know what a card sorter is...

http://en.wikipedia.org/wiki/IBM_80_series_Card_Sorters

Then, read the part that says...

Multiple column sorting is done by first sorting the least significant column, then proceeding, column...

TheSQLGuru (10/2/2008)

---

Jeff: Don't ever let the defaults for auto-growth on a database occur... it takes 73 disk fragments just to reach 1GB using the default settings.

I believe you are...

Heh... No... I'm saying the following is wrong...

FROM sys.tables AS tbl where tbl.[font="Arial Black"]Name[/font] = CAST([font="Arial Black"]object_id(@TableName)[/font] AS VARCHAR(100)) ORDER BY 1

😉

Jackal (10/2/2008)

---

Hi Jeff,

The following article contains a sample test.

http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/hitsandmisses/1776/

When I replicated the test (in SS2K), it did appear to be as the article listed. However, re-doing the test this...

Andrew Gothard (10/2/2008)

---

J (10/2/2008)

---

"'dbo.selectthisandthat"

For my taste, I find this harder to read (mid-50 eyesight and all), it requires more attention to figure out the meaning of the name. I feel...

Jackal (10/2/2008)

---

Hi J,

I'm not saying that a dba's views would be ignored and I dont want to wonder off track. It's just in situations I have worked in, business...

Jackal (10/2/2008)

---

Hi Jeff,

No problem, let me your views when you've had a look.

Just on another point, ANSI 89 vs ANSI 92, do you know where I can find a quick...

John Oliver (10/2/2008)

---

Thankyou Jeff for the vote of confidence. It is good to know I also have a like minded person somewhere out there.

It is always troubling when you...

Jackal (10/2/2008)

---

J (10/2/2008)

---

"This way I can just tell the developer to run stored procedure 'dbo.selectthisandthat' and not have to worry about them calling 'dbo.SelectThisAndThat' and getting potential cache misses."

Would it...

John Oliver (10/2/2008)

---

You have found one of my little bug bears here. There is no excuse for producing badly formatted code. Just because code has to go in...

Thanks, Jackal. I sure appreciate it. I'll take a look.