GSquared (12/29/2010)

---

Peter Brinkhaus (12/29/2010)

---

Probably hex values. 0x41 = 65, the ascii-value of a...

Glad I could help 😛

Seriously: as long as you're on comp level 80 (aka SQL 2000), you won't benefit from some of the nice...

tfeuz (12/29/2010)

---

I think that is the issue -- it is set to SQL SERVER 2000 (80)

Should I change it to SQL SERVER 2008 (100)?

TF

I did not install the server ---...

tfeuz (12/29/2010)

---

Lutz,

I tried running the script by Jesse. Keeping in mind we are using SQL 2008

When I run the code against the master db - it says it creates...

I'm not really sure what your question is... What do you mean by "the first record's always wrong"? You have gaps within your sequence. The question is: what is the...

If you're already involved in a...

You already figured creating a new table per user will get you in trouble as soon as your app scales. It's great still having people out there thinking a step...

vinothraj (12/29/2010)

---

Lynn Pettis (12/28/2010)

---

Not sure what you are talking about. The problem you are relating does not appear related to the OPs original question. I suggest posting in...

Duplicate post. Please reply here

tfeuz (12/28/2010)

---

So when you are going through this process do you basically pick apart each individual query and come up with an indexing strategy for that particular query?

It sounds like...

Now we have all the columns in the index we need.

But there's still a Key Lookup. The reason is to filter out rows accoring to the result of ReceivedMailboxAck =...

Ohh... I forgot: We'd still need the actual execution plan, not the estimated. There might be a significant difference... And even if not: we'd have an idea regarding data size...

tfeuz (12/28/2010)

---

Just a second followup --

I tried to include the columns you suggested. It turns out there were already in excess of 10 columns included.

The columns currently...

tfeuz (12/28/2010)

---

Thanks Lutz -- I will try that.

A couple of quick questions (since I am new at this):

1. How did you review the plan and come up with that recommendation?...

Please expand the Nonclustered Index _dta_index_InvoiceHeader_6_1108198998__K64_K65_K4_1 on InvoiceHeader to INCLUDE(STKey,BuyingGroupInvoiceNumber,InvoiceNumber).

Side note: It looks like the estimated execution plan, not the actual....