And your reads/writes ratio is based on pages or just the number of times referenced? If the latter, I'm not sure I'd care. If the former... again, still not sure...

You have to remember that SQL Server Database Tools (SSDT) is an overloaded term within Visual Studio & SQL Server. There are actually two distinct tool sets that define SSDT....

How often is the read query called? Did that cause blocking or contention with other resources while running? yes, there are always added writes when creating an index, but how...

Yep, percent complete is an incomplete figure. There's really no options for the position you're in. You need to wait it out in order to run the restore of a...

Fast recovery applies to crash recovery and failovers as part of mirroring. This is not applicable to a restore operation. There is no special setting you get for the restore....

Security is just the start. I'd suggest modifying the cost threshold for parallelism. I'm just learning about modifying the system_health extended events session to only write to file and not...

Enjoy it. See you when you get...

I've checked in with the powers that be. I suspect pretty strongly that you're misinterpreting that statement, but someone should get back on this, soon I hope.

Since you have more than one date value, that's returning multiple rows in a place that can only have one. Instead of using MAX date, use TOP 1 with an...

You need to do two things. Look into all the common code smells of T-SQL, like this:

Isnull(functionalunit, '') <> ''

That's a function on a column which will lead to...

Age has nothing to do with it. It's down to knowledge and experience. Unfortunately, that's usually accumulated with age. So, it's not that you're too young, it's that you may...

Unless you're pushing the outer bounds of what large hardware is capable of, the days of easy rejection of virtualization are over. In fact, I'd say, in most cases, virtualization...

I have not heard about anyone having issues, nor have I. As with Gail though, CTPs are installed on VMs (or, better still, spun up in Azure).

But the indexes you showed were not identical. And, if they're not identical and both...

ramana3327 (5/27/2014)

---

They ask me to find the exact duplicate and partially duplicate Indexes. Also I need to drop the indexes that are duplicated either exactly or partially. So I have...