Funny you should ask this because the newest version of Access is running SQL Server. The Jet engine is gone. It's just a really fancy GUI on top of SQL...

Ah, Templar photo-bombing at it's best. WHOOP!

Still back to mine and Lynn's original answer. The view has fewer columns than the base tables and that alone can make the difference. Also, it's possible that the statistics...

Yeah, pretty much. The execution time and the resources used are reasonably accurate measures. The estimated costs are just that, estimates. They are the only numbers we have within execution...

sivapragasam2000 (5/6/2013)

---

Old topic but still relavent...

In my previous job, I always used CTEs and they were much faster when compared to temp tables.

In the current place, strangely enough Temp tables...

If we're talking about a table that records the transaction and a table that stores the list of transactions, assuming you want to automatically generate the ID on the transaction...

I'm not sure which query we're talking about (i looked at and commented on the other post), but the whole idea behind creating an indexed view is to take advantage...

Two points.

Those costs are estimated costs. They don't necessarily relate in any way to reality. You really can't compare two queries through the costs. Not realistically.

Having multiple queries in...

Jeff Moden (5/6/2013)

---

Grant Fritchey (5/6/2013)

---

Just remember that if you have a clustered index that is not unique, then SQL Server makes it unique through an internal process called a uniquifier....

A single straight update statement all by itself can't cause a deadlock with another update/insert/delete statement. So, other statements within these query batches must be involved. Since you're on 2008,...

Just remember that if you have a clustered index that is not unique, then SQL Server makes it unique through an internal process called a uniquifier. It's additional storage and...

I think this might be posted on Ask.SQLServerCentral too. But you want to use sys.dm_tran_session_transactions. That will let you get transactions for a session or a session for a transaction.

Forgot about this article[/url] completely. It's got the same title as your question, part of why I alerted to this one.

Jason has it right. Unless you're running differentials, you can just run a regular full backup.

Since you're just getting going, you might want to check out Shawn McGehee's book on...

Jeff Moden (4/30/2013)

---

L' Eomot Inversé (4/30/2013)

---

Anyway, I'm at a loss to think of a good role to assign to DBAs in the worlds of science fiction and fantasy. Of...