John Colby (11/12/2009)

---

I routinely work with tables where the entire table is a PK, name and address and five other fields. these are just mailing lists, but HUGE -...

You made a very important piece of information public there: GL transactions. In my experience with financial data GL rows are almost never updated/deleted. That means record...

You really do need to know your data access patterns in order to be able to answer the question you pose. One big question is how many forwarded records...

Bet that isn't the only query to hit the table(s) though. ...

Business Objects by any chance? I have made a good bit of money from helping others clean up performance messes from that awful system.

1)

AND (((COALESCE(StatCTE.clicks ,0) <= 1000.0))...

The percentage at which you have an issue with performance related to index fragmentation??...

I am often-times disappointed that I cannot have more than one clustered index. Do you think they will ever put this most useful feature in SQL Server Gail?? ...

Jim, first off, welcome to the wonderful world of SQL Server! Also, what is your primary RDBMS - i.e. from whence do you come to us? 🙂

Andrew Gothard-467944 (11/11/2009)

---

Paul White (11/10/2009)

---

Just for anyone who's really into this: http://blogs.msdn.com/raulga/archive/2006/03/11/549754.aspx

One might even persist the first few characters of the unencrypted value and index that. It all depends...

GilaMonster (11/10/2009)

---

TheSQLGuru (11/10/2009)

---

1)

That is incorrect. While you cannot do an index SEEK, a...

GilaMonster (11/10/2009)

---

TheSQLGuru (11/10/2009)

---

1)

That is incorrect. While you cannot do an index SEEK, a...

I think that is a bit of a stretch. There is almost always at least some performance benefit (often dramatic), both...

Yeah - "Enterprise Developer Edition" is poorly worded.

1)

That is incorrect. While you cannot do an index SEEK, a query can...

In this particular case I think Chris mentioned that the query plan xml actually contains missing index...