Sorted it. Cheers ;)
I have a stored procedure that I want to search an array of values.
I am passing the following string to the procedure:...
Sorry, what is DTA?
I have looked at the execution Plan and the SQL optimizer says to add an index as it takes 97% of operation time, however when adding this...
I beleive COUNT_BIG() allows you to use ORDER BY or GROUP BY.
I will wait till I get to the office and check the execution plan
To index a view you cant use aggregate functions or options in the query.
I have checked the execution plan and nothing really stands...
Hi, I have a query that is pulling information from tables and populating a search filter. This query is quite slow. I can't actually post the query...
Separate names with a comma.