James A Skipwith (2/22/2013)

---

In the long run, especially with examples of having 7,500 active out of 20M, you will want to move to partitioned views if you stick on standard...

ScottPletcher (2/21/2013)

---

Did you try just putting the Status column only in the index? SQL can still use that index to do a key lookup back to the main table....

rice.tx (2/21/2013)

---

We have a very similar situation, and are looking forward to upgrading and making use of filtered indexes.

It's not clear to me... did you try using filtered indexes with...

That is correct, and one of the limitations of this solution. In my scenario the maintenance of the index does not add a lot of overhead but I could see...

cmille19 (10/22/2008)

---

Thanks for the updated info, I wasn't aware R2 changed the max memory. Do you know if clustering is supported in Windows 2003 R2 Standard? It wasn't in Windows...

cmille19 (10/22/2008)

---

One other correction, the article states:

"...differences between a say 32 bit 2 GB RAM SQL2000 Standard on NT4 Server and a 64 bit 32 GB RAM SQL2005 Standard on...

I went for a tinyint in the end, and have learnt a lot more about bit fields, thanks.

I had indexed a couple of bit fields up to now as I...

MS have notification services planned for SQL server on dot net framework solution but its still in beta I think. Might be worth a look.

http://www.microsoft.com/sql/NS/overview.asp

I implemented a messaging...

Another Fox user since Fox/Dbase came out.

I can not think a text file would be better(?) in any circumstances other than ease of data interchange

We have rewritten our entire line...

Thanks for your help - I am going to use a different way as suggested rather than sp_oa calls.

I never did get the code to work even as sysadmin either...

The functionality would be used infrequently , say once per day it would probably run. I have tried to avoid automation up to now as it does look klunky but...

I agree with other contributors and add the following info from real usage in a very similar scenario.

The maximum number of (SQL2000 merge) simple 'transactions' I have down over a...

Do you have a service running called Performance Data log. This is the service version of performance monitor (and can be very useful). I installed it on my workstation many...

In my original reply I meant to say WAN instead of LAN, sorry !

I have seen this a few times - in my cases it was always due to 1)poor network connectivity across a LAN or 2)the Windows NT/2000 'server' process which runs...