Erland Sommarskog (7/31/2013)

---

Grant Fritchey (7/31/2013)

---

So much for my stupid Cartesian product statement. You do have that problem. First warning right at the top of the plan indicates you don't have...

christopher_rogala (7/31/2013)

---

Let me start off by saying, I agree that temp tables are much more efficient that variable tables; and try to exclusively use temp tables. That said, you...

So much for my stupid Cartesian product statement. You do have that problem. First warning right at the top of the plan indicates you don't have JOIN criteria. Apologies Kevin.

I'd...

With that, I suppose it would then be possible to successfully break things down. It still depends on accurate entry, but having a mechanism to validate the entry changes things...

My suggestion... don't do that. Unless you're building some sort of address reporting engine that counts the number of references to street vs. road in official address usages, you will...

You can pretty quickly set up extended events to capture the query and it's performance and then recapture it after adding the index. You can also capture the execution plans...

It doesn't look like you have cartesian joins. You have defined join criteria. A cartesian is when you don't have join criteria defined and every row is joined on every...

You'll have to work with the vendor to either supply you with the information of how your system is configured, or get them to give you read privileges to the...

That will show you what is currently in the cache. It is an aggregation of executions for each of your statements in cache, the number of times called, average CPU,...

If you don't have monitoring in place to track disk space and disk usage, there's no way to tell. Nothing within SQL Server will automatically remember that on Jan 1...

SQLRNNR (7/30/2013)

---

Koen Verbeeck (7/30/2013)

---

SQLRNNR (7/29/2013)

---

L' Eomot Inversé (7/29/2013)

---

I...

Welcome!

Keep your hands and feet inside the vehicle at all times and enjoy the ride.

Bhaskar.Shetty (7/30/2013)

---

Hi all,

I am facing a weird problem since couple of days, When we tried to execute the any SP (Randomly) sometimes throws the error "The definition of...

No, you'd need to script it. But, if you have a fairly consistent naming or storage mechanism you should be able to script the scripting, write dynamic T-SQL to build...

I would not assume they're identical in all respects. You need to identify specifically why the query is running slowly. I'd start with sys.dm_exec_requests. That will show you if the...