One question, you wouldn't have an outer join to the customer table would you? You have to have a customer to have a call right?

If so, this should work just...

From what you're saying, dynamic TSQL is probably the way to go.

In a system where anything can be queried, any way, at any time, performance is usually an issue. It's...

I would run a server side trace (which can be generated through the Profiler tool, but shouldn't be run through it) to capture the calls against the database. Once I...

GilaMonster (1/6/2009)

---

Maybe for you. 😉 I play D&D. The 20-sided dice is the most important one.

I have 4, 6, 8, 10...

Jeff Moden (1/6/2009)

---

Grant Fritchey (1/5/2009)

---

WITH...

URGENT!

How do you pick indexes... Oh lordy

http://www.sqlservercentral.com/Forums/Topic630357-360-1.aspx

I didn't see anyone mention it, but if you're moving scheduled Agent jobs, just script them out on the first server and you can run them on the second. Edit...

nairsanthu1977 (1/6/2009)

---

Dear All,

Can anyone give me some tips on creating indexes in sql server 2005. when to created index on single/multiple columsn etc...

I...

There are some stress tools out there for when you get past the basics of query performance troubleshooting. Quest offers one called Benchmark Factory. Idera used to have one, but...

nitinpatel31 (1/6/2009)

---

I am sure this is interview question. But merge and hash join are Oracle terminology. It is not good idea to ask this question here.

Any way here is the...

My rule of thumb is the same as Jeff's with one exception.

I've found some queries that are only, ever, doing a full scan of the temp table can run faster...

If you think these queries are bad, you should see the stuff coming out of nHibernate. I've only seen a few so far, but they're pretty horrifying. It does implicit...

I expected it to perform the join inside a sub-select and then select from the result set as a single set of values. That would have helped explain why it...

I'm not sure, I haven't worked with Entity Framework much. What does it do when it has to do a JOIN between two tables?

I'll bet the execution plan for both is the same.

It's a messy way to write procedures, at least for really simple things like this, but it's not going to add...