SQL Server Performance

Search Results

Search Again
  1. Steven Mie

    How do you construct a Dynamic Stored Procedure with more than 8000 chars

    Post by: Steven Mie, Sep 18, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning
    Thankyou so much. You are completely right. Thanks for looking at the code.
  2. Steven Mie

    How do you construct a Dynamic Stored Procedure with more than 8000 chars

    Post by: Steven Mie, Sep 13, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning
    None of the values passed into the EXEC would have NULL. How does using print help me debug?
  3. Steven Mie

    How do you construct a Dynamic Stored Procedure with more than 8000 chars

    Post by: Steven Mie, Sep 12, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning
    I have tried this with the EXEC.... ALTER PROCEDURE [dbo].[SearchTenderMultiRegions] ( @whereclause nVarChar(MAX), --4000 chars...
  4. Steven Mie

    How do you construct a Dynamic Stored Procedure with more than 8000 chars

    Post by: Steven Mie, Sep 12, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning
    I have tried using the varchar(MAX), but in some instances I have 20,000 char's in the query and it gets truncated. Also when trying to do the...
  5. Steven Mie

    How do you construct a Dynamic Stored Procedure with more than 8000 chars

    Post by: Steven Mie, Sep 11, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning
    SQL Server 2005
  6. Steven Mie

    How do you construct a Dynamic Stored Procedure with more than 8000 chars

    Thread by: Steven Mie, Sep 11, 2007, 18 replies, in forum: SQL Server 2005 T-SQL Performance Tuning
    My problem (excuse me for being a novice) is that whenever the query becomes complex in the @whereclause (and it does) it cant exceed the character...
Showing results 1 to 6 of 6
Search Again