sys.sysdepends has the dependency information.

We can't see your XML because of the < and > in the code. You need to edit is to use the replacement text for them.

Do you...

antonio.collins (4/1/2008)

if you added an indexed identity column to the table, using ident_col % N = 0 will not use the index and you'd still be table scanning but at...

I don't if it will reduce the size used of the plan in cache, I would guess not as it will build the same plan for the query, but I...

Usecounts tells you how many times a plan has been used since the last SQL Server restart. YOu can find out the sql executed by using this query:

Select *...

Ashwin,

Your example queries are definitely different and will have different plans. The IN operator is basically a shortcut for writing where column1 = x OR column1 = y OR...

GSquared (3/31/2008)

---

Don't use autoshrink. It's a...

That is where the Where U.key_fields is null comes in, U.key_fields...

Cory Ellingson (3/31/2008)

---

Well said - I am in that boat as well...I am nearly 33. Taking one class a quarter would take about 7 years...Do I want to be...

Wayne,

You don't mention which version of VB is being used, but if it is the latest bersion of VB.NET don't let them read anything about Linq until you get them...

Thanks for the nice words Jeff. I just try to be realistic.

Cory,

Certainly having a degree won't hurt you, but I know several very good programmers and SQL Server people who do not have a Bachelor's, but an associated from a...

I have nothing against getting a degree, but, as Jeff said, I am not sure what you gain on top of your experience. Do you feel green because the...

Jeff Moden (3/29/2008)

---

As Jack did, I second the recommendation that Barry gave. But (Jack, don't kill me), anyone who thinks that performance is not as big an issue as...

There is not an option in SSMS, but earlier this week I saw a tool on a blog that enabled what you are looking for. Unfortunately I did not...