Is there a column that you can use for something like "Where ID between 1000 * (@Iteration-1) + 1 and 1000 * @Iteration"? @Iteration = 1 for the first...

Is it always in the format number-measure? And are the measures consistent?

For example, would it ever have, "weeks 5, days 3", or will it always be "5 weeks 3...

There can also be a difference depending on the number of rows that fit the criteria you selected, since returning the data is part of the excution time. Might...

If you strongly type the XML, index it, and define it with schemas, it can be pretty efficient and can query pretty rapidly. Plus, if reporting becomes a big...

I'm sorry you found my question destructive, or whatever. I'm just trying to understand what you need. When I've nested loops in SSIS,...

Well, I'm glad we helped speed it up.

What's your query look like at this point? Might be other aspects of it that can also be sped up.

I think we're talking about two different kinds of rows. I'm talking about rows in the table. You seem to be talking about having a return character in...

Just for a speed test on a large number of rows, I did this:

set nocount on;

go

create table IPs (

ID int identity primary key,

IPAddr varchar(15));

go

insert into dbo.IPs(IPAddr)

select top 1000000 cast(abs(checksum(newid()))%256+1 as...

I don't have pictures, but isn't it just a matter of dragging and dropping the icons in the right place on the screen?

Considering that "null"...

Why is all that going into a single text field? Why not have one row per keyword? That'll be a LOT easier to work with.

Yeah, scale can make a huge difference. While it sped stuff up on the small dataset, it slowed it down on the big one. That's why I like...

Test it and find out, in a dev database. That's what I'd do. If it actually matters which it will do, is there a reason to not use...

Steve Jones - Editor (4/23/2009)

---

GSquared, actually the whole technique is great. Give them a server in a VM, what's wrong?

A good way to see how people go about their...

Yeah. Like you, of all people, need to pad your posting stats. 🙂