Right. Check out this recent SSC article[/url] for more information.

Mebbe he was sitting in an interview for a DBA position and had to post to SSC quickly to get the answer...someone walked in just as he was about to...

Have you determined what is actually taking the most time in the job? Is it taking forever to purge the old records, but loading the new rows is quick?...

Daniel Bowlin (5/3/2012)

---

-The next report actually has an update statement as part of the query that updates the user acceptance table to approved or yes or true or whatever works...

I dunno...maybe it was a philosophical question: What IS documentation? Where does it come from? How can we best experience documentation...that sort of stuff...

Hopefully it would either have those two steps wrapped in a transaction or drop the table first, then delete...

I actually had this happen...

hbtkp (4/13/2012)

---

i think i will lost my job , i am on dead linequote]

hbtkp (4/13/2012)

---

i...

I'd also question the business requirement of once-per-month uploads. Depending on the amount of data being transmitted, it might be better to have a shorter, daily, upload instead of...

+1

I've always been impressed by candidates who took it upon themselves to learn a new...

Oh, gosh, what if someone types in "2br in erith" or "2bd in erith" or "two bedroom in erith" or "2rm in eriht" (note misspelled word)? You can't fix...

Something else to decide is how all those disparate databases might be linked. And how you might find/fake the connections if they don't really exist...a huge challenge. Is...

I would think you'd want to have the script component to keep track of what PO value you're processing (as was suggested earlier), then a split/loop to write the header...

Brandie Tarvin (3/29/2012)

---

Just spent time in a meeting being reminded that people using the same terms do not always mean the same thing. Interesting effect that has on a project....

This is one of those "how high is 'up'?" questions, and the answer(s) depend on your specific needs. You can go with the free-as-in-beer solutions like SSIS/SSRS/SSAS or punch...