Luis Cazares (6/17/2016)

---

Eric M Russell (6/16/2016)

---

In the past there was an ETL process where a standard deviation in record counts based on the previous X runs would flag the dataset...

In the past there was an ETL process where a standard deviation in record counts based on the previous X runs would flag the dataset in staging and prevent it...

Some coding practices, like cursors and SELECT *, are known to be bad and you can spot them just be reading the code or performing a text search across your...

Brandie Tarvin (6/10/2016)

---

Steve Thompson-454462 (6/10/2016)

---

Brandie Tarvin (6/9/2016)

---

Y.B. (6/9/2016)

---

So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you...

ScottPletcher (6/15/2016)

---

Eric M Russell (6/15/2016)

---

Jeff Moden (6/14/2016)

---

Eric M Russell (6/14/2016)

---

You'll rarely ever be asked pop quiz style questions like "What is a clustered index?" or "How do you get...

Jeff Moden (6/14/2016)

---

Eric M Russell (6/14/2016)

---

You'll rarely ever be asked pop quiz style questions like "What is a clustered index?" or "How do you get the current date and...

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...