After the fact it's going to be hard to track down. You can try using sys.dm_exec_query_stats to see which queries have the most worker_time. That will give you some indications...

stuart.holloway (1/4/2013)

---

We had issues with Functions taking a long time to run when using parameters where the scope might change each time it's run.

To resolve the issue, it was quicker...

anthony.green (1/4/2013)

---

1 - No, just execute permissions on the proc will be enough. They dont need access to select from the table or views

2 - Yes as long...

Resender (1/4/2013)

---

Hello I've gotten 3 questions where I can't find an answer for, 1 should be simple but my managment studio refuses to cooperate

1)A user has select rights to tables...

What are your top 5 wait stats from sys.dm_os_wait_stats? If they are not memory related, then I doubt memory is the cause of the slow performance.

I wouldn't stop the log backups over night. Maintenance routines will add to the transaction log and you've got a data load running that's absolutely adding to the transaction log....

I'd be willing to bet that you're joining this function to other tables or other functions. Multi-statement table valued user defined functions are notorious for this sort of bad behavior....

Statistics are one of the primary drivers to execution plans. And yes, if your statistics are out of date, the plans generated may be inappropriate. Maintaining statistics appropriately within a...

samalex (1/3/2013)

---

Grant Fritchey (1/3/2013)

---

Just so you know, many of the Red Gate softwares are licensed per user. This means, as long as it is you using the software, you can...

Just so you know, many of the Red Gate softwares are licensed per user. This means, as long as it is you using the software, you can install it on...

Maintenance plans and SQL Agent jobs are stored within the system databases on the your server. So, with a failover cluster where the databases are the shared item between the...

That is not something I've run into during any of the upgrades I've done. Have you looked to see which specific jobs are missing? Is there anything unique about them?

Happy New Year Threadizens.

Be safe out there.

You'll have to CAST one of the data types to one or the other in order to combine them.

Determining the "best" tool really is a part of determining what your needs are. The different tools out there are all pretty good, but they do things differently and delivery...