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

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 text, etc. for comparison.

SET STATISTICS...

At my old job, I would keep a can of expresso ground Cafe Bustello in my desk, and I would sometimes reload the coffee maker using a double or tripple...

Just like the cast for Hollywood films, TV shows, or the makeup of city councils or corporate boards, you'll find that diversity within IT is hit and miss depending on...