Exactly.

Every job I've had in the last 10 years (including the one I'm starting at tomorrow) has been a personal referral. Not from someone looking at the alphabet soup of...

It's a pretty safe setting. Worst it can do is slightly increase the number of compiles if you happen to have ad-hoc queries that do get sent multiple times (identically)

Those two are redundant, you don't need both, but you do want to set the variable to something before concatenating. Otherwise it's NULL and NULL + Anything = NULL.

Ed Wagner (10/31/2013)

---

GilaMonster (10/31/2013)

---

Jeff Moden (10/31/2013)

---

GilaMonster (10/31/2013)

---

Last day of freedom. Starting dev job tomorrow. Hopefully will go well...

I'm unlikely to be around much during the week from now on (at...

djackson 22568 (10/31/2013)

---

I think that one reason idiot MVPs are so bad is because their focus was on the title and not the knowledge. That (the focus) is kind...

krowley (10/31/2013)

---

Sigh , I hate the whole job hunting process and was sort of hoping a short cut at least existed. Not that I would have been able to take...

Jeff Moden (10/31/2013)

---

GilaMonster (10/31/2013)

---

Last day of freedom. Starting dev job tomorrow. Hopefully will go well...

I'm unlikely to be around much during the week from now on (at least for a...

If you want to change data, you use a procedure. Functions have a requirement of having no side effects.

krowley (10/31/2013)

---

MVP is an award for community contributions. That's it. It shouldn't guarantee a DBA job any more than spending time at Toastmasters should. It's about how much you share...

krowley (10/31/2013)

---

Now for me at least, it seems like the MVP is the closest there is to a top level certification that truly means you are an expert at the...

How have you identified that the log backup is the blocker? What is the lock type that it is holding? What is trying to get that lock?

Last day of freedom. Starting dev job tomorrow. Hopefully will go well...

I'm unlikely to be around much during the week from now on (at least for a while), so could...

tony28 (10/31/2013)

---

slower queries are important but i think the CPU time = 78 ms, elapsed time = 79 ms are ok no??

or do you think that is it problem ?...

Logical reads are reads done from memory. Not necessarily scans.

Slower queries isn't important to you? Really?