OK, that helps some. Sounds like you want to do a count of the true (or false) values in a boolean (bit) field.

Two ways. One was just suggested above.

1) Use...

Your question is a bit unclear. What are the two new boolean columns you want to add? How do you intend to use them?

As was just said, it's frequently quicker to let SQL index the entire table once the data is in it,...

pablavo (3/24/2010)

---

I should have added that the main table will be truncated before every import and the new data added to it. So you suggest that it's a good idea...

Using stored procedures CAN help...

I would echo everything Gianluca said -- and add to that a) decisions on your security model (who gets access to what), and b) how you are going to do...

Not sure I completely follow what you're asking, but let's see if this helps...

Inside of your Order table trigger, you could always do a lookup on the Customer table to...

In the Maintenance Plan wizard, the Backup Database task, you can use the 'Back up databases across one or more files:' option to specify a specific file to write your...

Lynn,

Wow. Very cool, very clever....but with all of the SUBSTRINGing, CHARINDEXing and concatenating going on, is this really more efficient than a simple while loop? (Oh dear, I may have...

I do know that SSRS passes field(parameter?) lists as a string of comma-separated values. That doesn't require dynamic SQL or even a cursor/while loop to split it apart quickly,...

You could simplify the query *somewhat* by using a couple of conditionals in the WHERE clause (which would at least leave the SELECT portion of the query common to both...

JDixon-385826 (2/24/2010)

---

Well I guess it is my opinion that replication is not the place for archiving (Datawarehousing) as far as writes to the disk. Yes it would be the same...

JDixon --can you explain further? How is using SSIS less of an administrative nightmare than using Transactional Replication -- and how does it cause less fragmentation? If one wants to...

Thanks for the reply. We never (at least in normal processing) ever delete anything anyway -- it will get flagged as 'inactive', but will never leave the db. That's part...

That's what I had thought would work. We're proceeding down this path...at least until we run up against an insurmountable problem. So far, so good.

Thanks for your input.