That best practice is for TempDB only, and it's only really necessary if you have high volumes of temp table creation and/or are seeing blocking on the allocation structures in...

Could you explain more please.

GSquared (3/19/2008)

---

If you're using transactions to reduce the workload on the server, then yes, short transactions are good. If you're using transactions to control data integrity, sometimes you have...

Please don't cross post. It wastes people's time and scatters replies. Many of the regular readeers read all the forumns.

Please direct any replies to the following thread.

http://www.sqlservercentral.com/Forums/Topic472063-338-1.aspx

Thanks

Please don't cross post. It wastes people's time and scatters replies.

Please direct replies to the following thread

http://www.sqlservercentral.com/Forums/Topic472055-150-1.aspx

Thanks

Shorter transactions means less blocking and less chance of deadlocks. In turn means less work to do. Always a good thing. 😀

I have no problem using table variables if the rowcount is low (100 rows is around my threshold) or I'm just going to do a straight select * from @tbl...

Are there any errors in the sQL error log from around the same time?

does that domain group have access to the DB in question?

I'm going to go and dig out "Songs of Distant Earth" Both the book and the soundtrack that Mike Oldfield did

Partially. Is it related to estimated duration as well as to the resources used by the query execution. Look at it as an aprox measure of how much work SQL...

The cost is an estimate created by the optimiser of how expensive the query is to run. It's not just execution time, also CPU, memory and IOs.

My personal preference, when...

Jeff Moden (3/18/2008)

---

I'm sorry that Microsoft ever added them to the mix. I'd much rather they had allowed the use of Temp Tables in UDF's especially since...

Matt Miller (3/18/2008)

---

I'd have to agree. Just about the only thing preventing NOLOCK would be a schema-lock, or something changing your DDL. Do you have something routinely modifying...

Have you checked what the statements are that are involved in the deadlocks?

Matt Miller (3/18/2008)

---

GilaMonster (3/17/2008)

---

Yup. And that,...