Maybe there is a permission granted to Public to select from that table?

I remember what my teacher told me when she first taught us about index. "Index works the same as index section in a book. It helps to go to a...

By doing this, you know that you are clearing all the caches execution plans... Right? That will have a performance impact...

I know one more index..... It is the thingy that is always on a book or magazine....

I have seen this being used by GSquared quite often if I am not mistaken.. 🙂

Hey Grant, I did not know that you brew your own beer... :w00t:

I was planning to write another article (Another miserable try 🙂 ) but that will have to wait....

If I am not mistaken, In SQL 2005 there is a default trace that audits all DDL statements. I think you might be able to use it.

Paul White (5/27/2009)

---

Right then.

Given the wealth of knowledge and talent around these parts, who's up for writing the perfect collaborative-effort book on indexing?

We could all get fabulously rich!!!...

Well, Trigger is something I am always vary off... I have seen people write whole business logic on triggers on a high transaction DBs and mess up the performance.... Maybe...

Control F5 did the trick. I was getting withdrawal symptoms of not able to see the site... :hehe:

Hey, How are you all getting on to the site? The only page that works for me is this. Rest of them gives me a zonal error. 🙁

Best thing would be to search this site itself. There are lots of articles written by Brian Kelley, one of the best SQL Security guys you can find.

Cricket too its the same. Even if the umpire makes a mistake, you cannot question the umpire. Else you might be banned for the next game or 3.. 🙂

Cant you use profiler? It will catch everything

or maybe I did not understand your question properly

Hey Lynn, I am not an expert in this, but couldn't the Index fragmentation and the fact that the query is trying to retrieve all columns make the query engine...