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

You need to change your WHERE clause to something like this:

WHERE

d.VendorRelationStatus = ’On Hold’

AND d.ContractEndDate > getdate()

OR (d.VendorRelationStatus = 'Active'

AND d.ContractEndDate >= dateadd(d, +360, getdate())

)

This WHERE clause now says,...

When using table-valued functions you need to use the APPLY operator. Your example query should look like this:

select FP.* from dbo.pbaseid as PBI CROSS APPLY Fport(PBI.pbaseid,'us',1,'12/31/2013') as FP;