I agree with SQLRNNR - SQL Sentry Plan Explorer is a good product. There's a free version and a paid version, which is pretty cheap. It gives you...

So you probably have a deadlock situation - both pieces of code are waiting on a lock to the same object. I believe the X in the last part...

Whenever I have a wait stats question, I look up Paul Randall's list: http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

According to this page:

This is simply the thread waiting for a lock to be granted and indicates...

Anthony is right - please look at the MSDN page for how to execute the sp_send_dbmail procedure. He gave you a link to the page. This is one...

You shouldn't be using QUOTENAME on the disk location. Just enclose it in single quotes.

You aren't passing any of your parameters to the EXECUTE sp_send_dbmail statement.

Thanks.

What is IFI?

It seems like maybe what you really need is an appointments table. You can figure out the open time slots using the gaps and islands logic. In other words, if...

I would think it would be multiple doctors, each of whom works a different schedule on different days of the week. Then they'd have their own appointments of varying...

Your database is 1/2 TB in size and you have less than 1% unused. I don't see a problem.

An point worth considering here is that sp_send_dbmail is a system stored procedure provided by MS with the product. Customizing it may result in your functionality "just going away"...

First, I would just refer to a temp table by its name and not fully qualify it.

Second, it you're in a loop, you may not need to create and drop...

I really like batch files and I've used them for quite a few years. They can accomplish a lot and are quite a useful tool to have in your...

The database mail system itself has proven itself to be quite reliable to me. We send lots of outgoing mail and it does a pretty good job. The...