SQL Server Performance

Search Results

Search Again
  1. mahesh2006

    Is it possible to convert rows to columns using CTE in sql server 2005

    Thread by: mahesh2006, Aug 23, 2008, 3 replies, in forum: SQL Server 2005 T-SQL Performance Tuning
    Is it possible to convert rows to columns using CTE in sql server 2005 and i would like to know where will be using CTE and how it is implemented to...
  2. mahesh2006

    I would like to reduce the time taken by these query,It is taking 29 seconds in production enviroment

    Post by: mahesh2006, Aug 9, 2008 in forum: SQL Server 2005 Performance Tuning for DBAs
    Thank you preethi, The Table Item_ledger_entry table as 3 indexes one on Item_ID,Comibination of Item_Id,Document_id and etc. I would like to create...
  3. mahesh2006

    I would like to reduce the time taken by these query,It is taking 29 seconds in production enviroment

    Thread by: mahesh2006, Aug 8, 2008, 6 replies, in forum: SQL Server 2005 Performance Tuning for DBAs
    SELECT TOP 20 II.NAME_FOR_SALES COMPANYNAME, -SUM(TOTAL_PRICE) AMOUNT, 6 GROUPORDER, II.ITEM_ID,II.ITEM_NUM ITEMNUM FROM ITEM_LEDGER_ENTRY ENTRY,...
Showing results 1 to 3 of 3
Search Again