Gary Varga (9/8/2016)

---

David.Poole (9/8/2016)

---

djblyth (9/8/2016)

---

Yeah, I wanted to say the same but i thought it might sound too 'high brow'.

Actually though, I think techies often begin with the expectation...

patrickmcginnis59 10839 (9/7/2016)

---

Jeff Moden (9/7/2016)

---

patrickmcginnis59 10839 (9/7/2016)

---

Jeff Moden (9/2/2016)

---

On 2)

A lot of people will answer yes or no on this without clarifying and it could be a trick question. ...

Hmm.... I tend to find files more appropriate for streaming data that might not necessarily break down into clean transactions or might not relate directly back to records in the...

Creamy

Lynn Pettis (9/1/2016)

---

xsevensinzx (9/1/2016)

---

David.Poole (9/1/2016)

---

My definition of good enough would be significantly lower if the"we promise to fix this if it causes problems" was a firm commitment rather than an...

Derek Slinn (9/1/2016)

---

I think the answer is wrong,

Both are stored in tempdb database.

technically table variables can just be in memory if there is only a small amount of data in...

Aaron N. Cutshall (9/1/2016)

---

I totally agree. As a data architect, I get frustrated when development managers are only concerned with right now...

Indianrock (8/31/2016)

---

In general, we need to shift the focus away from new features in the application to performance. Along those lines, I’ve been pushing the idea of a QA...

What exactly do you mean?

The only loop I can find doesn't have a fetch next so yes it's going to be broken.

And please indent your code, my poor poor eyes.

Yet Another DBA (8/31/2016)

---

I try and get the developers to see the sprocs as an interface much like a RESTful or api. So easy to setup testing or mocks against...

The only time to every shrink a log file would be after running an exceptionally large job, other than that your log backups should be happening frequently enough that the...

Ed Wagner (8/25/2016)

---

I didn't make it the whole way through, but I...

Dead

Steve Jones - SSC Editor (8/25/2016)

---

Eric M Russell (8/25/2016)

---

Federal contractors, at least within the realm of IT, farm the actual work out to sub-contractors anyhow, and I can tell you...

Someone's address can be sensitive, but why store it if you don't need to? And why the hell would you store the entire credit card number???? You can ask them...