Jack Corbett (3/6/2014)

---

Working through the example you posted now. The issue is around using the Multivalue parameter. I'm pretty sure you can't just use the "IN"...

Working through the example you posted now. The issue is around using the Multivalue parameter. I'm pretty sure you can't just use the "IN" in the filter. ...

ananda.murugesan (3/6/2014)

---

Hi,

I checked unused index, As per that script result return value only two column in NONCLUSTERED

total 4 NONCLUSTERED index values as below and Remaining all the...

GilaMonster (3/3/2014)

---

rodjkidd (3/3/2014)

---

Almost posted last night that site was up. But apparently we shouldn't have noticed...

I haven't read the article that Perry posted so I don't know if this is in there , but have you verified that remote connections are enabled on both SQL...

Depends on what you mean by test.

A development and unit test environment?

A QA environment?

A performance/load testing environment?

For the 1st I recommend using SSDT to setup a database project and...

I'm not really familiar with accessing MySQL from a linked server, but I'd suggest converting the @advisor to a compatible data type when passing it to sp_ExecuteSql

Based on that query you aren't looking at range_scan_count or singleton_lookup_count so it looks like you don't know if this index is used by selects. I prefer to look...

Take a look at this blog post by Kendal Van Dyke. I think it might help.

I would recommend taking the Manager Role out of the db_owner role and manually add all the permissions needed to mimic it. You can use sp_dbfixedrolepermission and/or sys.fn_builtin_permissions to...

Some times it's just a matter of hitting the right terms. Usually I'm on your side of the search where nothing comes up for what I'm looking for.

RBarryYoung (3/5/2014)

---

Jack Corbett (3/4/2014)

---

Hey Barry, interesting question.

I'm pretty sure you can do this, but I doubt your security people would allow it. You could even test it...

David,

I can't duplicate your issue, can you post the query and rdl? I'm attaching an example I put together that I think matches your scenario, but I'm not seeing...

Dwain,

Cool solution.

Hey Barry, interesting question.

I'm pretty sure you can do this, but I doubt your security people would allow it. You could even test it with your own SQL Server...