NTILE?

This is the first time I've heard of that one. Thanks, Micky.

Here we go. Tables & Indexes in the below code box. Execution Plan attached.

USE [MyDB]

GO

/****** Object: Table [dbo].[tblTransactionDetail] Script Date: 09/18/2013 07:54:20 ******/

IF EXISTS (SELECT...

I have to scrub the names first. I'll post it in a bit.

BTW, it's not a JOIN. It's an UPDATE on a single table that splits one column into many.

Basically it's:

UPDATE ri

SET col1 = Substring(ri.x), col2 = Substring(ri.x)....col7 = Substring(ri.x)

FROM MyTable ri

WHERE...

Jack Corbett (9/19/2013)

---

Brandie Tarvin (9/19/2013)

---

Thanks, Jack.

Huh. Apparently the Key Lookup shook itself out of the execution plan a bit later on. Now I've got Clustered Index Scans.

Of course,...

Okay, this is interesting. When I run the first two queries in conjuntion with everything else, the first execution plan changes back to a Key Lookup.

When I run them by...

Thanks, Jack.

Huh. Apparently the Key Lookup shook itself out of the execution plan a bit later on. Now I've got Clustered Index Scans.

Of course, I've been playing with these table...

Glad I could help.

My box doesn't have SSDs, so that's probably not it for me... Thanks for the info, though.

EDIT: I am using Windows 7 x64 (just got a new box) with SQL...

And if...

Speaking as someone who has upgraded a laptop from XP to 7 (both Pro versions, though), yes, it is possible.

As far as memory goes... That depends on the edition of...

I know half a dozen ways to do what you've requested. But any easier than the easiest way I posted above?

If you find one, let me know.

Short answer: yes.

You can do this, but it's not simple.

You need a job with three steps, one for each type of backup. Then you need a schedule that will run (at minimum)...

Yes, you can sort out the middle. The easiest way to do it would be to create 2 temp tables. One for worst sellers, one for top sellers. Then join...