t.mounika01 (3/6/2015)

---

Actually, what i meant was that I just have thereotical knowledge and I have been practicing queries on ssms installed in my laptop. I want to know how...

It sounds like a blocking or resource contention issue. Let's assume that your queries are tuned, but they suddenly start timing out. It's likely that there's one resource of query...

What is the cost of the query as it currently exists?

Setting your threshold to 5 might work, but only if the cost of that query is over 5. If it's...

ChrisM@Work (3/9/2015)

---

The optimiser has difficulty with more than seven or eight tables in the FROM list regardless of how they are joined. More than that and you are very likely...

Most tables in most systems (and by most, 99% plus a few extra digits) should have a clustered index. It doesn't have to be unique as defined, although it's better...

Assuming no data manipulation, you might also be able to use a scalar function. Due caution, testing, your mileage may vary, etc. But, it'll make the code a lot easier...

Bouke Bruinsma (3/9/2015)

---

I myself an against views altogether. The current view is part of an application. I can change...

Without seeing the query and the plan, just speculation, but, timeout means that the optimizer went through the number of optimizations that it determined should arrive at a good enough...

First option, use a table valued parameter. Here's documentation on how that works.

Another option, use Jeff Moden's scripts to turn comma delimited lists into a table. Here's documentation[/url] on that.

Your process is not hung on CPU. You may need more memory, faster, or more, disks, or a faster network. You can use sys.dm_os_wait_stats to understand what precisely is causing...

Eirikur Eiriksson (3/6/2015)

---

Great meeting you all, Ola, Erland, Itzik, Grant, Rodders, Gail, Dejan and and all the others, missed Steve although I did catch a glimpse captain America, looking forward...

Well done sir.

Pretty much what Jeff says. Actually, that's just a good rule to live by.

WHOOP!

That's...

Lynn Pettis (3/1/2015)

---

Thank you. It is good...