Mine is simpler, but it ends up reversing the group order on that sample of data:

create table #T (

Item1 char(1) not null,

Item2 char(1) not null,

constraint PK_T primary key (item1, item2))

insert...

Logical vs Physical, on the IO stats, is data queried from the in-RAM cache (logical) or from the actual HDD (physical).

The first thing I noticed is that you have your...

If you can swing getting one more HDD into the server, you could split to 3 RAID-1 arrays, partition one of them for OS and backups (drives C and D),...

Jeff Moden (6/20/2008)

---

Just a thought... Sometimes, it's faster to export the data to a file, transmit the file to the other server or put the data in an area accessible...

We were having a periodic timeout issue recently, replaced routers and switches, replaced NICs, all to no joy. Then found one of the cables had a flaw in it....

I guess I'd have to see the data to figure it out, in that case. It looks correct.

Can you modify the query to a union statement of the two...

If you need the indexes to accomplish the data population efficiently, then create them before. Otherwise, after.

For example, if one of the tables you need to populate depends on...

What you're doing will work. The locks it's talking about are with regards to reads from the database, not the data you're updating.

The code looks like it should work. I'd rewrite the joins and Where clause to the ANSI-92 standard, but that shouldn't make a difference in what you're trying to...

Can you post the error message(s)? They may not be meaningless to someone here.

I've upgraded databases from Express to Standard quite a few times. Definitely works. But...

Yeah, it's weird how calendar tables work except on those days. 🙂

Seriously though,...

Your packet sniffer seems to be saying you see the outbound packet to the SQL server, per what you wrote. Have you checked to make sure it arrives at...

On the original post, the error from the function is hapenning because of some string being fed into it, where substring(1,8) can't be converted to datetime. You can check...

Don't use <= date + 23:59:59.997. Make it midnight (time 0) of the following day and just use <. More accurate that way. Also deals with the...

The best way is use a calendar table.

If you don't want to do that, you'll get an approximate number (accurate in most, but not all cases), by using:

select datediff(day, date1,...