Alan.B (9/25/2013)

---

In SSMS you can right-click on the job, select "Script Job as" > "Create to" > ("Query Window" or "File"). This will produce the DDL to create each job....

"Final" specifications

You need to find out what the differences are between test and production. Perhaps you have a bad plan cached on production? Perhaps you have a missing index...

Richard Moll (he was the bailiff)

Koen Verbeeck (9/26/2013)

---

I'm thinking about getting a Kindle. Anyone experience with it?

I have some PDFs lying around, can it display those as well?

Is it good for reading technical books (screenshots,...

I prefer actual books because you can flip back and forth more easily than in electronic media. There's also something nice about unplugging and just getting into it. ...

I assume basic SQL knowledge. At the start of most procedures, I state the reason for the procedure - why it exists in the first place. I then...

GilaMonster (9/25/2013)

---

Indeed. Though it's good to know...

Nice question. I can't tell you how many times I got hit by that before it was driven into my head! 🙂

No problem. Glad I could help.

GilaMonster (9/25/2013)

---

stevewes (9/23/2013)

---

our Help desk ticketing application gets lots of email request into a particular table and seem to break when it gets to 100 !! so it's so we...

Is this what you're looking for?

update dutyrostershift

set dutyrostershift.savedduty_id = savedduty.id

from savedduty

where dutyrostershift.vacationtype = savedduty.name;

One thing worth pointing out is that savedduty.name is a varchar(20)...

I've never even considered using a DELETE using a CTE. You made me think about something new, so thank you.

As for the semicolon before the WITH, that's not necessary....

GilaMonster (9/23/2013)

---

And now that the paperwork has been signed....

November it's good bye consulting, back to full time grind. Starting at a software development house as a technical lead. Focusing on...

wolfkillj (9/24/2013)

---

I'm thinking a model rocket motor embedded in a potato specially carved...