Sean Lange (8/9/2012)

---

Woohoo!!! Vacation starts in about 7 minutes. Meeting my wife's parents, her brother and another close family friend for a long weekend in Chicago. 16 people in all....

In theory, non-indexed views are supposed to be broken down into their component pieces and eventually reassembled as a huge nested query.

In reality, those huge nested queries, even when directly...

Lynn Pettis (8/8/2012)

---

I can relate but in a different way. One of the bloodest projects I had was automating an invoicing process at a former employer. I...

In addition to the above question, completely variable names could end up with something like this:

ABC_20120605_Rewrite_20120701_abcd.def

Which date gets used in something like that, or are you guaranteed to only have...

Yep, this'll do that if it's closed and the closed date is after that.

Abu Dina (8/8/2012)

---

You're spot on once again. I had a meeting with the Director of Software development and she made a point about the data services team being afraid of...

-- Ignore this, bad joke that's not going to work as planned... I'm not going to get it wordy enough without copy/pasting a phone book or something...

Optical Character Recognition. Basically: Your scanner takes the blobs on the page and attempts...

bsclyde,

I'm preparing a response to this but I've been a bit overwhelmed at work lately so I haven't had the time to sit with it until this morning. If...

Since we haven't heard from Steve, and I agree it may just be for the politics, the owner of the pic may just not have wanted a forum insta-display img...

SQLSACT (8/7/2012)

---

Hi All

I'm trying to understand something regarding SQL Server security

If I have a SQL Login and that Login is also a user on a database. What happens when that...

It sounds, personally, like there's actually two primary stages to this process. Standard and Custom. Right now they're rolled into one.

What I would recommend you do is create...

Jason-299789 (8/6/2012)

---

1) Is the SysId in the PK on the #lookup table pointless? As the col1Id is Unique by default so it doesnt need the additional column to make it...

Primarily because that's how they get them from business users and hope we brought...

Were you having network issues or similar problems at the time? You won't get a cache hit rate if there's no activity as far as I remember, but page...