:blush:

shump66 (11/19/2010)

---

This is the method I us I have a SPROC that I just past the statement and tran ct one thing you need to remember that the where clause...

A better query plan is produced if you make the following small modification:

SELECT DISTINCT

attribute_id,

Val...

You also learnt that SQL Server is the wrong place to format dates into strings.

There is a complete explanation and script in the following SSC article by Lynn Pettis:

http://www.sqlservercentral.com/articles/67898/

The article covers deleting...

GilaMonster (11/18/2010)

---

Jeff Moden (11/18/2010)

---

Actually, that's not the best advice. IIRC (Gail, please correct me if I'm wrong), Temp Tables have space reserved and the definition is preserved for a...

The CONVERT(varchar(4),YEAR(x0_0.DateEndedStandard) expression in the DateBegun column returns a type that is being implicitly converted without a style parameter. Lay the code out neatly and pay particular attention to...

All that said, until you can do the migration, these are my thoughts given the information provided so far:

1. My choice for unique clustered index would be (SchedDateTime, ID)....

jordantx (11/17/2010)

---

The table has 5.6 million rows and is growing quickly. It's also very wide with 75 columns, many of which are VARCHARs. I'm looking into partitioning and...

jordantx (11/18/2010)

---

As a test...while leaving the PK clustered on ID only, I created a new nonclustered index on ID only (...) Why does having the same index twice, both clustered...

Craig Farrell (11/19/2010)

---

Hm, I had though the key lookup would seek the index, for groups, not single row loop. Interesting. I'll have to explore more deeply into that....

Set the...

Use a filtered unique index:

CREATE TABLE dbo.Appointments

(

patient_id ...

This seems wrong to me - surely the row count...

No! Let me explain why:

The TOP is the...