Oh me, oh my... Is that a Triangular Join (or as Microsoft calls it - a comparison non-Equijoin) I see? From Jeff?

hehe.....:P:hehe::crazy:

This is one of those cases where your WHERE clause is turning your OUTER into an INNER....

You're only allowing for non-null "right" records (based on the WHERE clause, so it's...

What about different schemas? Meaning - grant this person "straight" datareader permissions on the default schema, but create/update/delete within a separate schema.

Edit: nice thought in theory but it...

Express has no agent/job functionality.

Also - the SSMS that comes with Express is incompatible with other instances of SQL server (i.e. you can't connect to a Standard/workgroup/Enterprise edition instance from...

did you put the sub-report in the group footer section (which you have to "show" through the "edit group" options)?

I just noticed you get REALLY funky stuff if...

From what I've seen - the fillfactor persists until you specifically change it, so it will use the last specified value..

So if you create the index with a 90% fill,...

As of right now - the way to have 2 actives and one passive is to have 2 instances being serviced by 3 machines. Meaning - the two nodes...

Jeff Moden (1/11/2008)

---

Careful... that's only guaranteed to work correctly if one of two things happen...

1. You have a rock solid clustered index on the correct columns and you have...

Agreed - it can be a tradeoff like Troy mentioned. With one small caveat: uniqueness is not part of the tradeoff, meaning - it's the one attribute he mentioned...

One more restriction: UDF's can't modify the DB permanently in any way. So - besides not being able to change the table structure, you also cannot update/insert data.

On the...

Jeff Moden (1/7/2008)

---

Yeaup, we all need rules... but to keep from becoming a non-thinking "SQL Clone", ya gotta read about the "5 Monkeys Experiment"... you'll see what I mean... 😉

http://www.lanebaldwin.com/v03I8.htm

Dunno...

I'd be nervous about that new approach, since you're now mixing RAID 1 and RAID 5. (meaning - half of the files in the filegroup would be on RAID1,...

I just noticed - the reason your subreport solution isn't working is that you haven't parameterized the sub-report. You need to set up named parameters to pass the grouping...

Then try my suggestion #3: do the same thing as ROLLUP - but manually, with a UNION.

See if this jogs anything (manual version of previous example, but by changing the...

Actually Jim -

I was just trying to point out that you could avoid the "self join", by adding in the display fields you wanted into the CTE declaration. That...