I believe that you are correct in that a processor license is needed for SQL. How are the users connecting to the server? Through the web?

Express could work, but it...

Also, are you local or remote to the SQL server?

With those servers and thinking DR and switchover, clustering will work, but it requires hardware to make work. I'm not sure if you could do a 6 node cluster, either.

I...

You don't need to drop the column and add it back. Reseed it instead, it does the same thing. Just set your seed at a place it won't conflict with...

By default, all of your processors will be used. You can use less if you configure the affinity mask.

Lots of adds and deletes can do it. Our AV program would add in 10k+ every time, and I think it trimmed out values older than a week once a...

What does this mean? "if I want to you only 2 what can i do"

Do you mean only use two processors for SQL Server? You can use the affinity mask...

There are two things to understand about identity.

1. It involves the "next" assigned value for a column.

2. It has nothing to do with existing values. It doesn't ensure uniqueness, it...

They can have Damon, as long as he doesn't go back to Boston. He's getting older, not sure about his defense, but he had some good hits in the post...

Eichpeel,

You can't win that one. If they gave differing amounts to people, new hires feel less important, though they might understand. However how do you quantify who did what? Some...

Nice one, made me smile.

Happy Holidays

Interesting idea. Is there a place where this makes sense or where you want to stream a result set back in your applications?

Does SSMS do this? It seems that I'll...

We had an anti virus program that used identities to note a new scan of a machine. Since we had over 10k machines and this was scanning every 10 minutes...

You can check Performance Monitor/System monitor to see if all 4 CPUs are being used. There is are also a few settings for parallelism.

If you have the affinity mask set...

I would second Lynn's note. If you have more than 16GB on the 32 bit platform, the OS needs quite a bit.