There's no record within SQL of how often a row is selected. If you need to do this, then you're going to have to make some changes to your app...

Jeff Moden (12/9/2009)

---

Also, just for reference... I don't believe that the "pin table" setting actually does anything anymore as of SQL Server 2k5. I think they kept it there...

How much of that is in use at...

Post. The. Code.

G33kKahuna (12/9/2009)

---

@Gail: I considered log backup but the monkey wrench is that we have 1 nightly full back up and hourly txn file backup. My DMV would have reported low...

Jonathan Kehayias (12/9/2009)

---

Interesting that you mention checkpoint here. I considered that but couldn't remember enough about it...

No. Triggers in SQL are statement triggers. Fire once per operation and there...

Log backups, full backups, differential backups, transaction rollbacks. Restart recovery. Maybe checkpoint.

What happens if there's more than 1 row in inserted?

Custom-built app or something that has been bought from elsewhere?

I'm in agreement here. That's a lot...

As per Books Online, in detailed mode index physical stats produces one row for each level of the index tree.

As I just said:

Concatenating strings as part of a parameter assignment to a stored proc is not allowed. Define a variable of type varchar, build up the string and set...

At least he's not asking you to do the syntax check for him.....

Concatenating strings as part of a parameter assignment to a stored proc is not allowed. Define a variable of type varchar, build up the string and set the parameter value...