Re: How to make a SQL run longer?
- From: Raj <jkamaraj@xxxxxxxxx>
- Date: Wed, 27 Jun 2007 15:00:31 -0700
On Jun 27, 2:33 pm, Erland Sommarskog <esq...@xxxxxxxxxxxxx> wrote:
Raj (jkama...@xxxxxxxxx) writes:
Thanks for replying. My challange is that I can pass only one SQL
statement at at time.
Huh? What environment is this?
Is there a function that I use like this:
select a, b, c
from table_a a, table_b where a.cid = b.cid and delay(0:0:1)
You could write one that calls xp_cmdshell and the uses a wait command
in the shell.
But hopefullly you can also access the database from a regular query
window. In such case you can start a transaction that locks one of the
tables in your query. After a minute you commit/rollback that transaction,
so that the other process is let go.
--
Erland Sommarskog, SQL Server MVP, esq...@xxxxxxxxxxxxx
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Thank you. I will try this and then update the thread.
.
- References:
- How to make a SQL run longer?
- From: Raj
- Re: How to make a SQL run longer?
- From: Roy Harvey
- Re: How to make a SQL run longer?
- From: Raj
- Re: How to make a SQL run longer?
- From: Erland Sommarskog
- How to make a SQL run longer?
- Prev by Date: Re: How to make a SQL run longer?
- Next by Date: Re: How to make a SQL run longer?
- Previous by thread: Re: How to make a SQL run longer?
- Next by thread: Re: How to make a SQL run longer?
- Index(es):
Relevant Pages
|
