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...

I'm just lulling you into a false sense of security.

To query the plans in cache you need to use the dynamic management views. Something along these lines could work:

SELECT deqs.execution_count,

deqs.total_elapsed_time,

...

According to what you're showing, both indexes have been used. One has been used in seeks and one has been used in scans. Don't worry about updates. Any update to...

Have you looked at the execution plans to determine how the optimizer is resolving the existing queries. As Gail said, APPLY doesn't seem like the right tool here.

Instead of a restart have you tried dropping the procedure plan from the cache to see if it's just a case of bad parameter sniffing? In a development server you...

I'd also suggest checking the error logs to see if you can tell why the database is offline.

ramana3327 (5/25/2014)

---

Thanks Grant.

One more doubt. Suppose if I have 2 indexes on a table with almost with similar columns. How can we find which index needs to drop and which...

You have to have a page file. So yeah, you're going to have it. Size and location are the only discussion points.

Development should be the path to production, so yes, everything you're going to do on production should be done on development first.

And never, ever trust the DTA. Test everything it...

On the 50 ms of savings before you apply an index, Let's say we have an index that runs in 30ms. Does it need an index if we can shave...