SQL Server Performance

Search Results

Search Again
  1. bbains

    Tool for determining index usage

    Thread by: bbains, May 6, 2003, 1 replies, in forum: Third Party Tools
    Hi Again! I'm trying to optimize a database that has just tons and tons of indexes. I've already identified several that don't need to be there...
  2. bbains

    Dynamic SQL Question

    Post by: bbains, May 5, 2003 in forum: T-SQL Performance Tuning for Developers
    Hi All, Thanks for the useful tips. The Negative's COALESCE solution works fine for columns where you cannot have NULLs. I also agree that using...
  3. bbains

    Dynamic SQL Question

    Post by: bbains, May 2, 2003 in forum: T-SQL Performance Tuning for Developers
    You know, I never even considered using COALESCE. Let's see if I understand your solution correctly:<br /><br />When @var1 is NULL, then field1 =...
  4. bbains

    Dynamic SQL Question

    Thread by: bbains, May 2, 2003, 27 replies, in forum: T-SQL Performance Tuning for Developers
    I have a query that handles searching through an activity log table. The users can select any of about 20 parameters to use in the search (multiple...
Showing results 1 to 4 of 4
Search Again