How to make a SQL run longer?

Hell All,
To reproduce one of our cusotmer's probem, I need to make the SQL to
run for more than a minutes before it returns the result set. I do not
have large amount of data in the database to simulate the dealy.

Is there a way in SQL to cause the delay while returning the result
set

Thanks for the help.

Regards
Raj

.

Relevant Pages

  • Re: Problem opening stored procedure that contains cursor
    ... SET NOCOUNT ON ... In order to reproduce the error I think that is enough to create a stored ... procedure that use a SQL CURSOR to create a temporary table. ... -- This is executed as long as the previous fetch succeeds. ...
    (microsoft.public.data.ado)
  • Re: How to make the SQL to run longer?
    ... To reproduce one of our cusotmer's probem, I need to make the SQL to ... Is there a way in SQL to cause the delay while returning the result ...
    (comp.databases.oracle.server)
  • Re: Whats the deal with PAGEIOLATCH_SH? - PAGEIOLATCHIssue20040426.zip (0/1)
    ... After a great deal of help with Microsoft/PSS we finally isolated the issue! ... a reproducible table - the key driving factor to reproduce the problem is table width. ... Thanks to everyone for their help - I learned a great deal about SQL queries :-) ... >from the temporary table and loop. ...
    (microsoft.public.sqlserver.programming)
  • Re: How to make the SQL to run longer?
    ... To reproduce one of our cusotmer's probem, I need to make the SQL to ... Is there a way in SQL to cause the delay while returning the result ...
    (comp.databases.oracle.server)
  • Re: How to make a SQL run longer?
    ... To reproduce one of our cusotmer's probem, I need to make the SQL to ... have large amount of data in the database to simulate the dealy. ... Our is an reporting application that can connect to either SQL server ...
    (comp.databases.ms-sqlserver)