PHXHoward (11/30/2015)

---

I get it that they look the same but I did not know that SQL Server was smart enough to use an NCI on a computed column that is...

Try to get the actual query plan attached here. A couple of people have mentioned that before, plus your table definitions. That will go further in helping us to help...

It looks like that Left Join is essentially an inner join... you are filtering the results back down AFTER you are first putting together the bigger recordset. Make this

tbl_documents...

So you are able to change the index on the table and not a query? If you knew for a fact that changing the query will not break anything else...

siugoalie78 (11/25/2015)

---

I am not sure if this is the exact same issue, but I was getting the same error. In my organization, every time there is a schema change we...

Having before and...

You mentioned you have tons of indexes. I hope on of them is a clustered? Lots of indexes ( lets say half the number of columns on the table) can...

I dont know what qualifies as "most queries."...

From MSDN,

"STATIC

Defines a cursor that makes a...

Glad that you were able to get a resolution. Only that uninstalling apps and the pain that goes with all that might get irritating if you run into this situation...

Thanks Ed, I had to look at it for a minute to figure it out. It looks like that single quote is closing the first one in front of ren.....

I dont work with this a whole lot so I was wondering if the single quote closing the double quote is valid, or if it is just covering the...

Are you referring to exporting the data in a SSRS report to Excel ? OR are you referring to a report subscription ?

Please see if the below link helps...

I would approach this by using the SQL in your report (preferably the stored procedure that the report calls).

WITH myTop5 as (

select top 5 customer

from...

Typically a SCD type 2 has those validFrom and validTo fields in the dimension table. You can create your DSV by filtering on only those that have the validTo be...