I wouldn't expect to see a difference unless the NOEXPAND hint was used, forcing the query to run without allowing the where clause access to the underlying indexes.

homebrew01 (1/10/2014)

---

We have some semi-static reporting databases that run long queries. Some of them use nolock to avoid one report blocking another. In this case, the data was refreshed over...

The fastest way to have your reports have up to date information is not using a warehouse, period. Hook to the source DBs.

The next fastest way is transactional replication,...

Well, since I can't run test code since I don't have a sample I can directly use, best I can offer is an idea of the code:

SELECT

vendorno,

MIN(datetime)

FROM

table

WHERE

...

Instead of dropping the table, simply TRUNCATE it. That'll reset all your seeds and the like and you won't have to redefine the schema constantly, which fries dependencies and...

The confirm metadata/etc options are...

RonKyle (1/7/2014)

---

I don't ever recommend dropping and recreating the warehouse from scratch, although I've seen that as a solution from some consultants. It's faster to develop but ultimately (and...

Mountain Steve (1/7/2014)

---

I keep having a long running profile shut down because the C Drive is full. I am saving the output to a table so is there a...

To do the row sampling, afaik it still loads the entire sheet into memory, which is why you stall after you select the source sheet. The cache is too...

Do you have the step logging on? That truncated version (which you got from the history window) doesn't have the full story.

You need to open the step log and...

I realize you don't want to redesign your system, but this is code-parsing at best, painful at worst.

There are a few components you need here, particularly if you want to...

I'm confused as to the problem. Are you trying to initiate the package from one server, but have it run locally on another?

Basically... you don't. You need to...

You can report off OLTP systems with a light touch as long as you're not looking for significant aggregations and the like. My guess is they're not, not yet.

What...

SQL Agent. Doesn't do everything that you're looking for but we have a centralized...

Grant Fritchey (1/6/2014)

---

Looks like I picked a bad week to stop sniffing glue... Oh wait, I'm in the UK all week where it's "cold" and rainy. I'm practically in shorts...