... and then I really wanted to add "And I'm sure that during your undergraduate and graduate studies you had to know how to do independent research. This is...

May I also suggest you take the time to read about these things in Books On-Line. It is FULL of useful information that may answer many of your questions....

Best place to start is in Books On-Line, locking.

Looks like a permissions issue.

And now it also works for an empty table. Just ran a test with the code here at home.

And with that, Bruce, you can also remove the TOP 1 as shown below:

create table dbo.UserStats (UserID int);

insert into dbo.UserStats

select 1 union all select 2 union all select 3 union...

The compression is being done on the fly, as it is being written to disk. The compression occurs in memory faster than the writes to disk, this results in...

Good catch Bruce. I wasn't testing with enough values. Mind isn't quite on it at the moment.

Florian Reischl (5/6/2009)

---

Lynn, please correct me if I'm wrong but the original code would only once insert the @UserId if does not yet exist. Your code seems to create a...

Well, if you really want to know, I think you should read this The Flip Side.

It will give you a very good idea of why you should provide as much...

Alex Prusakov (5/6/2009)

---

There is no place that is perfect in every way. It is pure math and normal that a lot of people just want a paycheck but not an...

Original code:

BEGIN TRANSACTION

SELECT * FROM UserStats WHERE UserID = @UserID

IF @@ROWCOUNT = 0

BEGIN

INSERT INTO UserStats (UserID) VALUES (@UserID)

END

COMMIT TRANSACTION

What I would do:

insert into UserStats

select

@user-id

from

...

I saw the OP's reply before I saw your warning. Obviously the force was not with us at the time.

Technically, I'd say yes. You may want to consider licensing the other server on a per CPU license as well.

Alvin Ramard (5/6/2009)

---

Alvin Ramard (5/6/2009)

---

Lynn Pettis (5/6/2009)

---

Alvin Ramard (5/6/2009)

---

Lynn, let me know if you understand the OP's last reply in the thread about the rolling 12 months. I don't...