Sorry I wasn't helpful. It's just not inherent in the tool. We have a large number of developers & dba's hitting a large number of servers. I sometimes wish we...

What he said. Sorry I didn't fully understand the problem. The key point is a view is just a mask on top of a table (or tables). It doesn't actually...

I'm not entirely sure what your problem is. The example code won't compile. I ran this:

CREATE VIEW MyView

AS SELECT Col1

FROM MyTable

...

If your query execution timeout is set to zero ("0") in Management Studio, you shouldn't be seeing a 30 second timeout. Are these queries crossing servers in some way that...

I'm not entirely sure, but three things come to mind. First, the engine & optimizer behave differently enough that in this situaion 32 is just better than 64. Second, differences...

As others have already pointed out, to really answer the question you need to post some structures and some sample code.

But, taking a stab at it, it sure sounds like...

Now, now... we're stepping outside the bounds of the experiment.

I'll have to see what I can do with a materialized view though. That's a good idea just to try out.

Or just use good ole' fashioned bcp.

BCP Utility

Yeah. I'm actually working on comparing MAX, TOP and ROW_NUMBER. I was hoping to outline which might be better when.

Ah, partition by... crud. I was bouncing all around it and I just couldn't figure it out. That looks great. I tested it against the single row and large set...

You'll need to look at the queries being run and determine what the most likely access paths are for your data. There you'll want to put indexes. After that initial...

Since backups are just from committed transactions, I doubt you can move the log in that manner. Can't the Log Explorer read from log backups directly? I'm pretty sure the...

Itzik was doing it on demand. It wasn't hard either. He just had to get the queries to run against similar sets of data and he could force the issue...

Actually, according to Itzik Ben Gan and some pretty convincing tests (he gave the presentation at the last PASS Summit), NOLOCK can result in duplicate and incorrect data because it...

The short answer is, it depends. The longer answer is, that in some cases, yes, it makes a huge difference to put the filters into the JOIN instead of the...