Not me. I'm...

Scans are only one indicator of poor performance and are actually not even always a good indicator. SQL Server will run faster using a scan instead of a seek on...

But you have a good backup you can go to and retrieve everything, right?

If not, why not?

Except for what Gianluca has posted, you're in trouble. However, going forward, you might try getting a copy of this tool from Red Gate. It can help with exactly this...

And is it working for you?

The thing is, you're assuming that your data has no rows below 2004. I'll bet it's not what you think it is. Logically those queries are not equivalent. Best thing...

You're comparing where the Year is less than 2010 or where the Year equals 2004. There are five other year values possible in the first query than the second query....

I'm not sure what procedures do for monitoring. they're a way of executing tSQL on the database. So in answer to your specific question, no, don't use procedures.

But in terms...

Another vote for wordpress and a suggestion for a blog post. Write about backups. It's a sure fire winner and people can't possibly learn enough about backups.

Also, check sqlsaturday.com for an event near you. This is another way to learn DBA skills, from the best, for free.

PS: Mr. Shaw there just ran an event in Colorado...

And look at when it was created. You have that information in the sys.dm_exec_query_stats DMO.

The cost of an execution plan is just an estimate based on how many CPU and I/O resources that the query optimizer estimates that query will use.

You can use this...

azdzn (1/9/2012)

---

You can find a few information in DMVs (sys.dm_exec_query_stats) but there will not be that many details.

You will only know how many times it has been called since last...

You can have the identity column increment up, or down, but not both at the same time. To have it increment to negative numbers, set the increment value as -1...

And only run the shrink one time after dropping all the tables. If you run it multiple times you're going to be fragmenting your files a lot.