You'd need to show the actual execution plan in order to make any guesses at what's needed to tune the query. One suggestion, see if there are ways to limit...

sukhoi971 (5/18/2012)

---

my stored procedures are running very slow, probably using wrong execution plans,

there are 100s of tables

if i take backup and then delete the database will it improve perfomance?

since...

john.p.lantz (5/17/2012)

---

Sounds similar but it's old - going back to SQL 2000. I did look at the order of my JOIN's and it is picking the INNER first, so...

Lynn Pettis (5/17/2012)

---

Jeff Moden (5/17/2012)

---

Thomas Stringer (5/16/2012)

---

I tried searching for some explanation before posting, but I found nothing close to what I'd like to know. Ask SSC seems to...

Try moving the WHERE clause into the ON clause of the OUTER JOIN.

Also, make sure your statistics are up to date.

Start capturing execution metrics. This will at give you some indications as to what is regularly referenced and what isn't. Be prepared to capture a lot of data though. Since...

The length of time it takes is completely dependent on the resources available, the size of the tables, contention with other processes... the list goes on. There's no easy way...

RBarryYoung (5/17/2012)

---

Grant Fritchey (5/17/2012)

---

The defaults for the 2012 install should be for traditional. If not, go to Tools, Options, Keyboard & change it to the default. That's one fight with...

The defaults for the 2012 install should be for traditional. If not, go to Tools, Options, Keyboard & change it to the default. That's one fight with the development team...

Gullimeel (5/17/2012)

---

None of these Optimize for wont work when you want different plan based on your criteria. Once a plan is generated then that plan will be used unless it...

Gullimeel (5/17/2012)

---

What is other better way to remove parameter sniffing aprt from the recompile.I would like to know. This s only when you have skewed distribution.When optimizer is not doing...

Security of their systems, not the ones being built would be why you wouldn't want to give people permission to create stored procs. Still weird.

And then what do you do when the distribution of the data changes?

The basic idea behind having both is that some people absolutely loathe the conversations that take place here on SSC. So, a place has been provided where a specific question...

I know you said the permissions are correct, but when backing up the server, the process doesn't your logins permissions. Instead it uses the permissions of the SQL Server service....