ScottPletcher (6/14/2016)

---

My advanced knowledge, "tricky" q is:

In autocommit mode, when can an UPDATE statement partially complete, some UPDATEs made, some not, where SQL does not roll it back?

Edit:...

GSquared (6/14/2016)

---

I do ask trick questions. One of my standard tech-screening questions is:

And here's the trick question: You have two tables, A and B, and you want all the...

It wouldn't hurt anything if they simply query specific system tables, so long as they don't do something stupid like set transaction isolation level to serializable, use a TABLOCK hint,...

vliet (6/14/2016)

---

If two users are changing the same text simultaneously and the stored procedure does not produce an error in that case, one update will be lost without further notice...

DELETE + INSERT will probably result in more reads, writes, page fragmentation, and transaction logging, so for that reason I'd suggest an UPDATE | INSERT. The less "stuff" that's going...

I'm not sure if legal procecution is appropriate, unless it can be proven that executive management were grossly negligent or perhaps a rogue employee implemented or helped facilitate the data...

MikeS. (6/10/2016)

---

It's funny you should bring up the subject of 'nolock' -- at most places I've worked, it's a big no-no. At my current job, you'll get your hand...

I'm not saying that string manipulation is a bad question. It's just that for a one hour...

You can use SSIS or the SSMS Import Data wizzard to copy from source table to target table. You'll want to disable foreign keys on all target tables before the...

Sean Lange (6/9/2016)

---

Eric M Russell (6/9/2016)

---

patrickmcginnis59 10839 (6/9/2016)

---

Eric M Russell (6/7/2016)

---

Luis Cazares (6/7/2016)

---

Was I too late for April fools' day?

This is what happens when you trust a forum to answer...

patrickmcginnis59 10839 (6/9/2016)

---

Eric M Russell (6/7/2016)

---

Luis Cazares (6/7/2016)

---

Was I too late for April fools' day?

This is what happens when you trust a forum to answer questions that you should answer...

GSquared (6/9/2016)

---

Sean Lange (6/7/2016)

---

Jeff Moden (6/7/2016)

---

I think it's a great question. It shows whether or not...

I predict that within 5 years the Internet of Things, Social Media, and Big Data will be passé. Companies just can't find a way to build profitable business model around...

A cursor or any other "sequential row by row" construct to isn't needed to insert rows from one source table to a destination table, and it's actually the least efficient...

Lynn Pettis (6/8/2016)

---

Just saw a message from the recruiter, Jeff....