Actually I didn't see anything on how the data warehouse is setup.

Do you have any tables that are partitioned?

How much data are you removing each run?

How much data are...

First off is this just one database you are trying to clean up? How many objects are we talking and is it mission critical? Do you know what objects are...

It has been a while since I had to deal with this myself, but as I recall if you need to run the process under an account with logon local...

I won't say it's great by any means, but I have used QuickBooks just fine in the past. The key thing here isn't necessarily quality though, the point is they...

You are welcome Miles,

I honestly only came across this a few months ago myself. I try to take portions of my code and revamp them based on new available functionality...

nguyenthanh5 (8/20/2012)

---

Hi Jeff,

Sorry I missed the point.

I have created a function in VB.NET to do just that. I tested and it's fast. Could you care to test it? I do...

Very well thought out I have to say, and it can be applied elsewhere. Good job.

Then you have to weigh the fact MS is dumping LINQ in favor or to be deteremined. Many folks are still saying Entity Framework but rumor is that will be...

djackson 22568 (7/12/2012)

---

Antares686 (7/11/2012)

---

The same goes with arguements with the wife, she get's very mad with me becuase I won't just accept she is right if I feel she is...

I see that there is no harm in being wrong. However, just becuase someone say I am wrong doesn't mean I will accept it at face value. I will say...

Jeff Moden (3/31/2012)

---

Dean Cochrane (3/30/2012)

---

Elapsed time includes wait time and is not...

jshahan (3/29/2012)

---

I've been faced with this problem many times and never adopted a standard methodology for dealing it with but am quite sure that my attemps were RBAR.

Would this approach...

First off create an empty MSAccess database somewhere. This will be your template database, especially if you are going to do dynamically going forward needing a scratch database. Save a...

The components of Reporting Services can be installed anywhere including both nodes, it's database can be on the clustered sql server, but the failover between the components of SSRS does...

If I understand correctly you are missing the dll to work with Access? Can you clarify where you are running into an issue?