Without seeing the code that's calling the backups, it's hard to tell you why it continued after you killed the process. However, in terms of stopping the backups, there's no...

If you showed what your WHERE clause is, it would be easier to answer this question.

There are a bunch of ways to move a database into Azure and you don't have to use Management Studio for all of them. The method within SSMS is to...

In SQL Server 2012 and earlier, if the value falled outside the range of statistics, the optimizer assumed that the number of values returned was 1 row. This changed in...

Sorry, been on the road.

First, you have OPTION RECOMPILE on your query. Whether your update your statistics or not, you're going to get a recompile every time that query runs....

It doesn't matter if there are 50 great presentations. My favorite intro topic is backups. Why? Everyone has a backup book, article, blog post and presentation, so what is one...

And that'll work, sort of. You'll have to resolve the counts on executions between each set of data collection. You'll have to sweat queries that aren't stored in cache so...

OPENQUERY and passing the parameters to the remote server versus just connecting the tables and letting all the filtering occur wherever (SQL Server can, sometimes, figure out how to filter...

You should be able to spoof the query so that the views behave as if they were just a cross-database query. It won't be. It'll be a cross-server query and...

mcopa (2/25/2016)

---

What exactly do you mean by this: "if you really need to know exactly how many queries are run against the database, you need to set that up...

Jeff Moden (2/25/2016)

---

Agreed. Setting it up to find the name of the proc...

Views is probably the best approach. You could also look at synonyms, but I'm not sure they'll work the same way in this situation.

Kalen Delaney's book, SQL Server Internals, covers all this extremely well.

I agree with Gail, doing this stuff in Azure is the way to go. You're going to see more and more people in a hybrid environment anyway, might as well...

Alexander Suprun (2/24/2016)

---

tony28 (2/24/2016)

---

I tried now on few tables and I cannot see some effect during production and we are working in real time, so some little delay and I...