They're asking the wrong type of questions for a job interview.

Jeff Moden (6/3/2016)

---

Heh... you can't imagine how many times I've seen supposedly "one time" things suddenly become a requirement. 😉 The company...

Many folks botch their phone or in-person interviews because they are too nervous. When you interview, try to maintain a layed-back attitude, and you'll come across as more confident and...

David.Poole (6/6/2016)

---

One of my managers always volunteered to keep the minutes, that way his points were always recorded and inevitably signed off.

There's clearly an art to running a meeting and...

If you're deleting millions of rows, then it's probably the transaction logging, not the actual join or delete operation that's killing you. It's been a couple of weeks since your...

If you don't have a LinkedIn profile, then create one. If you have "SQL Server" anywhere in your profile, then recruiters WILL contact you... frequently... for the rest of your...

SQL006 (6/4/2016)

---

Thanks Eric for the suggestion...it is better than INSERT INTO option. To implement this shall i go with 2nd method where i am using configuration table to store...

Yes, disable your audit triggers before you purge a table.

Failure should always be an option.

Yes, failure is not a worst case scenario. There is nothing more wasteful than spinning your wheels until you have no more energy, financial...

So this would basically be a SSIS workflow consisting of T-SQL tasks; one for each table you want to archive.

Just for illustration purposes, let's assume you have a transactional table called Sales. Create another table called SalesHistory.

use StoreOps;

create table Sales

(

SaleID int not null identity(1,1) primary key

, SaleDate...

David.Poole (6/2/2016)

---

There's a presentation that demonstrates that you may as well not bother with an IT degree because the pace of change is so fast that by year 4 what...

If it's filling TEMPDB during an UPDATE, then it's probably performing a HASH MATCH join between the tables. Look at the estimated execution plan to confirm. To aboid a hash...

Terje Hermanseter (6/2/2016)

---

This is a major problem imo. In my country there are several...

Grant Fritchey (6/1/2016)

---

Eric M Russell (6/1/2016)

---

Enclose each of the queries within the following while you unit test them. This will return statistics such as physical/logical page reads, CPU time, plan...