After I submitted my last post I noticed you were really asking for performance. Really the only thing you can do is index and update stats. If your...

Do you mean that you replaced the WHERE with an AND to put the t.phonenumber is null part of the ON clause of the LEFT OUTER JOIN?

If this is what...

The only problem with using BETWEEN is that it evaluates to >= and = and = '9/1/2009' AND

theDate < '10/1/2009'

[/code]

Usually this means you have an object that extends beyond the borders of the page. It's usually something being wider than the margins of the page. Preview is...

Sounds like a security issue.

I personally think encrypting sp's is a waste of time. If you are concerned about your IP or proprietary business logic it should go in the application or use...

As usual it depends. If your business logic requires rbar you should have it in SSIS. If it can be don in a set based fashion use sp's.

I'm a fan of artificial keys for reasons already mentioned. Remember that SQL server defaults the pk to also be the clustered index so that data is also contained...

Is this a stored procedure or adhoc SQL? If it is a stored procedure you might be dealing with parameter sniffing.

In some cases option recompile might be the...

Grant Fritchey (9/24/2009)

---

You definitely do. ...

Awesome! Another...

GSquared (9/23/2009)

---

Silverfox (9/23/2009)

---

Gianluca Sartori (9/23/2009)

---

If he insists killing processes without knowing what they do, let him do it.

He already has decided to increase lock timeout and kill process, so, why...

Grant Fritchey (9/22/2009)

---

Jack Corbett (9/22/2009)

---

Anyone want to take a look at this one? It's about statistics aging and query performance. I gave an answer, but I'm not sure...

I don't think you need a temp table. You just need to take out any reference to the server name from the query.

You can restore msdb like any other database, http://msdn.microsoft.com/en-us/library/ms190749(SQL.90).aspx, if you have a backup. You can also restore master as well, http://msdn.microsoft.com/en-us/library/ms190679(SQL.90).aspx, if you have a backup.

If you do...