Viewing 15 posts - 9,346 through 9,360 (of 9,387 total)
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...
February 6, 2013 at 6:32 am
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...
February 4, 2013 at 11:10 am
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...
February 4, 2013 at 8:38 am
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...
February 4, 2013 at 6:41 am
You shouldn't be using QUOTENAME on the disk location. Just enclose it in single quotes.
February 1, 2013 at 9:57 pm
You aren't passing any of your parameters to the EXECUTE sp_send_dbmail statement.
February 1, 2013 at 9:53 pm
Thanks.
February 1, 2013 at 1:22 pm
Also, btw, turn on IFI unless for security reasons you can't. That will dramatically speed up data file growth on all databases, including system ones.
What is IFI?
February 1, 2013 at 1:08 pm
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...
February 1, 2013 at 1:06 pm
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...
February 1, 2013 at 1:04 pm
Your database is 1/2 TB in size and you have less than 1% unused. I don't see a problem.
February 1, 2013 at 12:51 pm
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"...
February 1, 2013 at 12:28 pm
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...
January 31, 2013 at 7:40 am
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...
January 31, 2013 at 7:28 am
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...
January 31, 2013 at 7:24 am
Viewing 15 posts - 9,346 through 9,360 (of 9,387 total)