Jared,

I just point that out because a user can input "",".","mary" or anything can fetch too many records depending on OP data.

In addiction to input validation (maybe) you can put a TOP clause to prevent too many records to be fetched.

If its a web or web like app you can take...

To compare between machines use a dump from the prod server (if possible)

Comparation between 5 millions of nulls or small strings is faster than comparing 3 milllions large strings...

Anyway the...

As I said, maybe you can change the desing, not only the implementation.

Since you are "cleaning" the table do find duplicate rows, you must run a join over itself (all...

Hi,

Well, I dont worked too much (just read it one time) in it so it's only a guess...

The problem lies in:

1) The sub querie is performing a cross join in...

I started not seeking answers more than new questions (I'm afraid we hjjacked this topic) but these are good fair points and nicely...

Jeff Moden (3/8/2012)

---

By the same token, I hate table names with abbreviations in them because people are rarely consistent with their spelling. I also hate table names like "cus",...

MS SQL Server already have a mechanism to find dead locks.

What's you goal?

Its a home work?

And why is it a great question?

Why UNION (ALL) is basic but very...

Misunderstoods ill happen.

Unfortunately humans dont speak in Context-Free Grammar (and that's why I prefer to work with computers :-P)

By I dont considered this option in my previous post.

And I'm no...

Great article! Thanks for the tip Gail.

In my defense I never told BCHR is the only counter to check.:-D

In fact no single counter ill tell the whole history.

Reading the article...

It dont mean performance problems per si (in fact I believe its a normal behaviour).

You must check Buffer Cache Hit Ratio and others counters.

Try find some "memory pressure" articles.

there are...

Only assefam can tell but

Sometimes bizarre or non trivial requirements arrive at my desk and sometimes they are valid.

Sometimes I cannot tell they are valid but there are cases where...

If a chunk of data was used there are a chance it ill be used again so why flush it?

Memory ill be flushed by demand since to erase memory is...

No problem with your sugestion.

It's realy a nice one.

I just wondering if there are some trick to pass objects names as parameters to a dynamic SQL.

As fair I know its...