Jeff Moden (9/23/2008)

---

Heh... include my post in your report on usage potential advising against using it.

The only time I even come close to Hungarian notation is that I'll use a...

Have you made sure the alerts are set up with a working DB Mail account and all that?

I haven't run into that, but my best guess it that I would check which jobs were on schedule 64 and see if there's any issue with any of them....

Will Summers (9/26/2008)

---

I am in the process of upgrading our main production box from 2000 to 2005. I know 2005 has been out for a while, but we finally...

I kind of assumed the original post wasn't about 64-bit, since that would kind of make the question pointless.

I would log perfmon to a file, then import that into Excel and analyze it there. If I ever found that I needed to do more complex analysis, I'd...

For me, it depends on what I'm accomplishing or contributing towards. I've worked for causes that were saving lives, and for those, I worked long weeks, long shifts, missed...

Luke L (9/24/2008)

---

While yer testin, if you wouldn't mind running the original again with the dateadd(datediff)) bit instead of the cast(floor)) I'd be interested if that might not eliminate the...

I modified the test as follows, to limit by year:

alter table dbo.SomeTable

add Col6Year as datepart(year, col6);

drop index IDX_Col6Cleaned on dbo.SomeTable;

create index IDX_Col6 on dbo.SomeTable (col6year, col6cleaned, col1);

create table #Dates (

BusinessDay...

Yeah, linking servers using domain security should be easier. It's a pain. Using mixed authentication is the easiest solution to it.

Oh, and just to test the original idea:

declare @Col1 int

select @col1 = col1

from dbo.sometable

inner join #dates

on CAST( FLOOR( CAST( (col6) AS FLOAT ) ) AS DATETIME ) = businessday

/*

SQL Server...

I just ran a test on this.

alter table dbo.SomeTable

add Col6Cleaned as dateadd(day, datediff(day, 0, col6), 0) -- Just the date, no time

create index IDX_Col6Cleaned on dbo.sometable(col6cleaned)

create table #Dates (

BusinessDay datetime...

Since you're on Windows Standard, you can't go above 4 Gig of RAM in use anyway, so there's no point to AWE. I don't think you can even enable...

Perfmon should do what you need.

Leave them in regular files. If you need to slice and dice the data, import it into an analysis cube, or relational tables, but...

Have you tried setting it up as an Access project instead of an Access application?

A project connects directly to the database, no linked tables, and can use stored procedures and...