Wow, I'm amazed at all the folks that have dishwashers at work. The only time I've ever had one was when I was working from home full-time.

My current job...

Does the file already exist in the remote location?

I typically recommend against sub reports. You can have different data regions on the same report that use different datasets or share a dataset. A table, list, or...

Without seeing the queries and the execution plans it is pretty much impossible to say why a query with fewer joins is taking longer. You've changed the text so the...

GilaMonster (6/13/2014)

---

Thought process of last 10 minutes.

- Tune a proc quick, then go home

- Wait, it's got user defined functions

- Wait, the UDFs have cursors

- I'm...

So what you want returned is something like this:

Pediatrician Parent Student

6062 6063 6064

6062 ...

No you can't use "USE" to connect to a linked server. That would be cool if you could, but USE only allows you to change database context on the...

Sounds like an issue because the report is initially rendering to pdf when running the subscription instead of rendering to html and then exporting to pdf as in VS. ...

I just did a quick test and created a connection to my VS Online collection with VS 2010 and created an SSIS project that was connected to VS 2013 online...

I would guess that it does cache the Exchange connection information somewhere. Glad that is was an "easy" fix.

I'd be talking with the Exchange admins. Can you send an email from Database mail successfully?

According to this blog post you can only audit on columns returned by sys.fn_get_audit_file and that is only 2012+. There are no predicate on Server Audits before 2012.

I wouldn't use a linked server, I'd use SSIS. I'd probably do something like this:

<ul>

<li>Load Data into archive data in current database</li>

<li>Copy data from local archive table to remote...

First you have to define what you mean by fast.

My first suggestion would be to batch the updates using explicit begin and commit tran statements and do Top N where...

Good article and a great, practical use of extended events.