I'm not a fan of killing sessions, but, instead of loading them into a temp table and then, presumably, using a cursor to clean them out, what about just using...

T.Ashish (9/18/2013)

---

Grant,

What I have learn is, we have a "estimated plan" and a "actual plan". When we execute a query, SQL gives us the actual plan of what it...

Yep, validated. Mirroring is still there in 2014.

You can see a listing of the deprecated features here. There are some that will be immediately removed in 2014 and there...

If by working and not working you mean that putting in single user mode sometimes works better with a single batch than with multiple batches it's down to time and...

The Agent can be running under a different account. Check that.

No, it's not going away after 2012. That's wrong. It's on the deprecation list. The current plans are that once something goes on the deprecation list it should only last...

Just remember that you can only do transaction log backups or full backups with COPY_ONLY on the secondaries. If you're already running everything on the primary and it's not hurting...

I just recently wrote a blog post about execution plan costs[/url]. They are all estimates, not actual measures.

carpainter69 (9/17/2013)

---

So I'm a little confused on what to do, there are good arguments for and against certs. I took a pay cut to get this job because I...

Alex, no question that the format and structure can be an aid to learning. But I remain unconvinced that most people view it that way or use it that way....

gary1 (9/17/2013)

---

so there is no way to list the staled statistics in sql server? other than getting when stats were last updated?

I want to update stats that are staled not...

There's no direct way to know for sure. You can run DBCC show_statistics and see the date the stats were updated, but that doesn't mean much. Maybe the table hasn't...

First, stop using sp_who2. It gives you some information, but not enough. Instead, start using the Dynamic Management Objects (DMO). Start with sys.dm_exec_requests. That will basically show the same thing...

Since the data is critical to the business, I'd suggest two things. First, ensure that the backups are meeting the business requirements. Talk to someone from the business side of...

Thanks!