Lots of null columns. Lots. Without the query it's hard to comment, but I'll bet it's doing a table scan. Have you looked at the execution plan for the query?

You have an index, but is it being used properly? What do the execution plans look like? What's the selectivity of the data in that index, meanin, how unique is...

akeelm_uk (5/22/2008)

---

If you didn't know something didn't exist, how could you ever learn about it?

That is one area where I feel certification can be good, it encourages you to...

I'm not actively against certifications, but I sure don't care about them. I'm much more interested in what you know and how you show it than that you passed a...

Also, while lots of people may have one piece of knowledge or another, maybe a full set of the knowledge has never been put in one place before. I wrote...

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