Prev: User id executed stored procedure
Next: Simple model and T-log
From: MN on 20 May 2010 14:27
Hello,
I am trying to troubleshoot a stored proc which as increased it's execution
time from 2hrs to 9hrs. The original code was written for SQL 2000 and I've
found an update stmt with the syntax above.

I've not seen the "option (shinkdb plan)" before. Does anyone know what it
is and what it does?
From: Erland Sommarskog on 20 May 2010 17:57
MN (MN(a)discussions.microsoft.com) writes:
> I am trying to troubleshoot a stored proc which as increased it's
> execution time from 2hrs to 9hrs. The original code was written for SQL
> 2000 and I've found an update stmt with the syntax above.
>
> I've not seen the "option (shinkdb plan)" before. Does anyone know what
> it is and what it does?

Never seen it before, and it is not in Books Online. Furthermore, when I
try to use it, I get

Msg 1003, Level 15, State 2, Line 3
Line 3: SHRINKDB clause allowed only for DBCC.

Would it be possible for you to post the entire UPDATE statement?

--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: User id executed stored procedure
Next: Simple model and T-log