SQLSACT (1/23/2013)

---

Grant Fritchey (1/23/2013)

---

There's a pretty focused set of requirements for forced parameterization to work. It's a lot more expanded than simple parameterization, but it does not include ALL ad...

Can't see the plan. I'm getting encoding errors. If you save the plan as a .sqlplan file, you can attach it. Then it can be downloaded.

Just on what I can...

So, instead of 5-10 machines you'll have 5-10 instances? While that makes migration of connection strings pretty straight forward, you might have performance maintenance worries. Instead of a single instance...

Have you checked the execution plan to see what is being referenced from the query? It might not be using the view at all. Or, it's possible that, despite the...

Depending on your level, I helped write an introductory level book on SQL Server 2012, Beginning SQL Server 2012 Administration.

There's a pretty focused set of requirements for forced parameterization to work. It's a lot more expanded than simple parameterization, but it does not include ALL ad hoc queries. Microsoft...

So you're not changing the basic SQL Server backup process? No worries then. Dedupe is pretty cool technology. More and more use is being made of it.

Last time I reviewed some of that stuff, the laws in Germany regarding data were pretty good. But, that was several years ago. Things may have changed and the gods...

This is the first time I've looked for the backup command in sys.dm_exec_query_stats, and you know what? It's not there. So no, I would not say this is a good...

Bhuvnesh (1/15/2013)

---

yes i have also realized that for smaller set , we can see...

You'll have to change the compatibility level.

Updating statistics can cause a large number of reads if you're doing a full scan. But the number of writes is extremely small.

Backup and restore are almost exclusively I/O operations....

Nothing like getting thrown into the fire. Welcome. We try to help out here as best we can.

From the sounds of it, no constraints especially, you're going to be dealing...

And for more you can go to the books. SQL Server 2008 Internals by Kalen Delaney is one of my favorites.

Yes, it's going to be a little bit random in the number of rows it returns. However, for a given set of inputs against a constant set of data, you...