Yep, ran 3 seconds for me too, when I was asking for the Actual Execution Plan. If I turned that off, the query returned in less than a second.

Using Jack's query, try adding the following index and let us know what happens.

create index IX_tbllogs on #tbl_logs (

[fk_tbl_visits_id] asc,

[date] asc

)

include (

...

Rereading the posts, you were asking the wrong question, well actually you weren't asking the complete question. Please look at the following code as it more closely matches what...

jamiejulius (5/7/2009)

---

Thanks. I'm familiar with Books Online. It seems to me that the proposed SQL would be considered an implicit transaction. It would be run under the default isolation mode...

jamiejulius (5/7/2009)

---

Thanks. I'm familiar with Books Online. It seems to me that the proposed SQL would be considered an implicit transaction. It would be run under the default isolation mode...

... 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...