jcrawf02 (10/15/2008)

---

jpowers (10/15/2008)

---

Steve Jones - Editor (10/15/2008)

---

I'm not sure there was a lot of forcing loans. There have been numerous interviews from lots of brokers that were making upwards of...

The entire meltdown, crash, implosion or whatever you want to call it came about and could have been avoided but for 1 simple human principal; the 'Me First' principal. ...

Using the text MSSQLSERVER worked for me as well.

Maybe I'm being too harsh or picky buit it seems to me that if a product (the upgrade advisor in this scenario)...

Gail,

Thank you for the reply and info. I'm reading thru more in BOL about Indexes in general but it's not made very clear or at least not easily clear,...

OK here is one for you with regards to the table being to small.

I am seeing the same problem on a table that has millions of rows and is hundreads...

Thanks for the info Matt; I would have never thought of that even though it makes a lot of sense.

Thanks Gail! Although at this point, with as many of my posts as you have answered, I can't help but wonder if I should ask for a billing rate...

sblock (9/30/2008)

---

If you are using a field to determine what type of data is being stored in a row, I suspect that your data is not normalized. If it...

.

Steve -

The problem with sticking with hosting discussions of the articles on their home site is that often those sites either offer no discussion forum/hosting or if they do,...

Wow! I had no clue that was there. Thanks for pinting this out Steve!

Now if we could just get teh orginal post to show; perhaps in...

Thanks to each who have replied so far. Currently I am testing this using the TNYINT data type and I now feel better seeing others respond with a suggestion...

I second that and would add that it would be best if when replying you could see at a minimum, the original post and the post you clicked Reply on...

Big thanks to all! I knew I remembered seeing it somewhere.

Hmmm... Have you considered table partitioning? Partition on the base numbers for the transactions and then, under the covers, it will be like each transaction type has its own table....