Search Results | SQL Server Performance Forums

Searching with an Array of values

Post by: Martin Dixon, Nov 16, 2011 in forum: SQL Server 2008 General Developer Questions

Sorted it. Cheers ;)

Searching with an Array of values

Thread by: Martin Dixon, Nov 16, 2011, 2 replies, in forum: SQL Server 2008 General Developer Questions

Hello, I have a stored procedure that I want to search an array of values. I am passing the following string to the procedure:...

Speeding up this query

Post by: Martin Dixon, Oct 13, 2011 in forum: SQL Server 2008 T-SQL Performance Tuning

Sorry, what is DTA?

Speeding up this query

Post by: Martin Dixon, Oct 13, 2011 in forum: SQL Server 2008 T-SQL Performance Tuning

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

Speeding up this query

Post by: Martin Dixon, Oct 11, 2011 in forum: SQL Server 2008 T-SQL Performance Tuning

Hi, 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

Speeding up this query

Post by: Martin Dixon, Oct 11, 2011 in forum: SQL Server 2008 T-SQL Performance Tuning

Yes, however. To index a view you cant use aggregate functions or options in the query. I have checked the execution plan and nothing really stands...

Speeding up this query

Thread by: Martin Dixon, Oct 11, 2011, 10 replies, in forum: SQL Server 2008 T-SQL Performance Tuning

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