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

curious_sqldba (5/31/2016)

---

KSQLDBA (5/31/2016)

---

What is "SQL Fertilization" any links?

its job description. I have googled it and i noticed that many jobs are asking: "Some experience with SQL fertilization helpful" I m...

Yeah, I gess it's best to play it safe. You never know...

RE: "SQL Fertilization"

So, perhaps somone is looking for a sperm donor. If musicians, atheletes, and high IQ university students are in demand, then why not a DBA?