SQL Server Performance

Search Results

Search Again
  1. RedDevils

    How can I optimize the multiple case statement in this stored procedure?

    Post by: RedDevils, Jan 21, 2009 in forum: SQL Server 2005 T-SQL Performance Tuning
    It would be preety good idea to use Dynamic SQL in this case using CASE statement instead. -Abhijit, MCP
  2. RedDevils

    Script to delete duplicate records in a table.

    Post by: RedDevils, Jan 21, 2009 in forum: Getting Started
    check this blog....www.sqlity.blogspot.com -Abhijit, MCP
  3. RedDevils

    Covered Index vs. many indexes on single columns

    Post by: RedDevils, Jan 20, 2009 in forum: SQL Server 2005 T-SQL Performance Tuning
    Before sugestion any idea Can you tell us in SELECT clause which columns you are considering (Table1 / Table2 / Table3 / Table4). -Abhijit, MCP
  4. RedDevils

    XML data into sql server 2005

    Post by: RedDevils, Jan 20, 2009 in forum: SQL Server 2005 General Developer Questions
    Its always a best practices to write your Business logic in stored proc, so if any changes occur (in future) logic the only thing is you have to...
  5. RedDevils

    Need faster query for multiple left join

    Post by: RedDevils, Jan 20, 2009 in forum: SQL Server 2005 Performance Tuning for DBAs
    Can you summarized the output result set so we will get an idea what output you require?
Showing results 1 to 5 of 5
Search Again