I wasn't sure either, so I had to look. Yes, please let me know how it goes. I am curious.

I have no experience with replicating partitioned tables but this article makes me believe it's possible.

http://msdn.microsoft.com/en-us/library/cc280940(v=sql.105).aspx

What is "almost" live data? An hour, 5 minutes, a couple seconds behind?

If it's something like an hour would a snapshot of a mirror work? I'm guessing it's...

No problem. Thank the Jason's. They provided the solution. I just provided an alternative if modifying the proc wasn't an option.

To answer your questions above. The...

Now that you know parameter sniffing is the problem you may want to consider putting the recompile option in the proc if you haven't already. There might be several...

You don't have to change the query in the stored proc. Just execute the proc with the recompile option.

EXEC lloyds.up_qmc_Report_E4247_112_RBNSAtStartOfYear 2012,3,197,2,20120630 WITH RECOMPILE;

Just a personal preference but I prefer laurie's solution. Never liked seeing ISNULL used in that fashion.

Store it in UTC time...what you're asking can end up becoming a huge pain in the you know what.

I don't see what's wrong with your query other than you don't have a loannumber column. It is loan_number.

Post the ddl and sample data for TableC and give expected...

I would take a look at SQL query stress by Adam Machanic.

http://www.datamanipulation.net/sqlquerystress/

Someone got their hands on a delorean.

To add to what you have and what Grant said, I like to look through the SQL agent jobs as well. Figure out when they run, how often they...

An entry level position that requires certs? That's just a little contradictory.

If you want to keep the temp tables in place, I would try joining them to your deletion table on eventid instead of using the IN with a subquery and...

Instead of @@Error, try using a try...catch block. It's a significantly better way to handle errors.

Check out http://msdn.microsoft.com/en-us/library/ms175976.aspx