You need to look at the execution plan of the query to understand which indexes it accessed. If query time increased, then adding that index did not help.

Just remember that the number is an estimate. This means it can be wildly inaccurate. But, it's the only number you get, so you're going to use it, just don't...

There must be another process blocking your query. That's the only thing that makes sense.

The real question is not what can be backed up. The real question is, what can be recovered. If you take a system backup once a day, then you can...

You can't directly control what gets created in statistics, but you can create specific types of statistics. Try creating a filtered statistic. I'm not sure what you'd filter by in...

No, no, no. I am the pretty guy...

All my experience with replication was transaction replication. In that, if we modified the publisher outside of normal data access, we had to completely rebuild the publication. It was a...

weberharter (11/26/2012)

GilaMonster (11/26/2012)

What I said was

"Typically a scan is a full scan (in the absence of TOP or other operators that give row goals)"

Hence, if you see a scan and...

There are lots and lots of new things in SQL Server 2012. Here's a fairly complete listing. What specifically are you after?

I have not seen a single point with a collection of all the updates. I have updated my book on execution plans. It includes a bunch of new stuff for...

Instead of log shipping if you're looking at offsite, check out mirroring. It's much more resilient.

In general, you're doing things right. There's two issues when it comes to backups, RTO...

I've never seen this one unless you're doing a system restore, not...

Since these are two different queries, you have to examine what they're doing in order to understand what the execution plan is representing to you. One is doing a MIN,...

I'm with Jeff. Just because you have change control and auditing in place doesn't mean you can't do your job. In fact, you can do your job better under that...

If you just take away the timestamp, as Jeff says, you can overwrite the backup. I'd suggest though, you should be nervous about doing that. If your backup fails during...