If your plan is to loop, you need to reassess the plan. What is it that you're trying to do?

In addition to what the BitBucket asked for, please post the actual execution plans. Since we're not sitting in your chair, it's as close as we can get to seeing...

I'm sorry, I realize I must be thick, but it's still not making sense to me. You're saying that maintaing the availability column in the table for a book, ccdvd...

barryFS (1/27/2011)

---

Everything that has been said thus far indicates that Perfmon counters can be used at a later date, to see what has already happened on a server.

Is it possible...

Schuttberg (1/27/2011)

---

OK following your hints I looked at some properties:

Table Triggers:None

(Check) Constraints:3 x "Default 0"; 1 "Column = 'NN' OR Column ='BST'"" (Simple, I think)

Foreign Key Constraints: None; ...

Jeff Moden (1/26/2011)

---

I'll certainly Google for it but what is the...

sqldba_icon (1/26/2011)

---

I really always ask this question to my self. If there is a native tool like perfmon to capture all the data why do people spend $$$ on third...

sqldba_icon (1/26/2011)

---

I really always ask this question to my self. If there is a native tool like perfmon to capture all the data why do people spend $$$ on third...

Close, very close. Nicely done.

GilaMonster (1/26/2011)

---

Since you seem intent on pulling the whole story out bit by bit, line by line...

I'm just not seeing a future here at the moment. The IT industry is...

Jeff Moden (1/26/2011)

---

Grant Fritchey (1/25/2011)

---

Yes, you should be able to do this from the command line, I've done it before. I'll add this to a list of new articles I'm...

Just know that if you've rebooted the machine or restarted the SQL Server instance, all information is lost from the index usage DMV. There's absolutely no guarantee that will show...

It kind of depends on what the data is. If it's an address, '1313 Mockingbird Lane,' I wouldn't sweat it (although, you can, I've seen systems that normalize street numbers)....

Take a look at the execution plan. On a guess, it's doing scans based on some foreign keys, loading that data into cache in the first query, just reading from...

Just speaking in theory, because without code & structures, it's hard to know what you're going for, you can combine two different result sets using the UNION or UNION ALL...