I tried putting all conditions in cte then left join. but bp results are nulls. there are bp dates that match the range.

So the best query uses left outer...

we cant change to inner because the sd table can be be related to bp or ba or none.

but this query returns nulls for bp date? when I know there are bp dates that match range?

sd_earliest_report_dt bp_check_dt

----------------------- -----------------------

2008-02-18 00:00:00.000 NULL

2008-02-18 00:00:00.000 NULL

2008-02-18 00:00:00.000 NULL

2008-02-18 00:00:00.000 NULL

...

thanks. the data from query looks right when I use the outer join tables or in where. the bp alias has many for entries for this day. but when...

The result is 1

Thanks for the reply.

The only stripe we found in document was xseries sql server 2005, redbook article and it says to use 64kb stripe but for SAN, which we do...

this is for RAID10 data drives.

THe redpaper 64kb setting up with a san which we do not have.

Should be 128 KB block size for SAS (not OLTP)

Thanks for both the comments.

Scott I agree with your comments on problems with RAID0 and will stay with RAID1 or RAID10 for now.  I will move tempdb log to the...

Richard,

spid 6 is "TASK MANAGER". I suspect some conflict between diskeeper and sql. We have diskkeeper set to run after db maint jobs runs every weekend. I...

I can't change use of logins.  I thought of adding security table but the problem is keeping users and passwords in sync between a new table and existing logins. Could use windows domain security...