Sign in
|
Join
|
Help
Home
Blogs
Media
Forums
Groups
DevCast
Keith Rull
»
All Tags
»
SQL utilities
(
RSS
)
ATTENTION
: I've decided to put the upgrade on hold due to a compatibility issue of our server environment with the latest CS installer package. CS 2008 now requires SQL Server 2005 as the backend DB but our database server currenlty has SQL Server 2000 installed on it. I'll resume the upgrade once I figure out when Telligent is releasing a patch to the schema compatibility issue. For now, we will continue to use the old version of CS while waiting for the said patch. If you have any questions about this process, please don't hesitate to post them on our forums and I'll answer them as soon as I can. Thanks for your patience and support guys! I'll let you know as soon as this is resolved. -
Keith Rull
Browse by Tags
Keith Rull
Home
About
Contact
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go
Recent Posts
sp_recompile is your friend
Tags
.NET
.NET How To's
ASP.NET
Blog News Node
C#
Contest
Filipino Developer
Filipino Podcast
Filipino Programmer
Fun Stuff
Geek Fun
Generics
GridView
How To
Java
My .Net Exploits
Pinoy
Pinoy Podcast
Pinoy Programmer
Promos
Site News
SQL
Tutorial
VB.NET
Your Career
View more
News
Badges
Archives
November 2008 (1)
October 2008 (4)
September 2008 (8)
August 2008 (4)
July 2008 (2)
June 2008 (8)
April 2008 (4)
March 2008 (8)
February 2008 (8)
January 2008 (9)
December 2007 (9)
November 2007 (23)
October 2007 (3)
September 2007 (5)
August 2007 (5)
July 2007 (1)
June 2007 (3)
May 2007 (11)
April 2007 (1)
March 2007 (9)
February 2007 (8)
January 2007 (2)
December 2006 (2)
November 2006 (1)
October 2006 (8)
September 2006 (9)
August 2006 (5)
July 2006 (1)
June 2006 (10)
May 2006 (10)
April 2006 (11)
March 2006 (9)
February 2006 (20)
January 2006 (17)
December 2005 (7)
November 2005 (1)
October 2005 (4)
September 2005 (4)
August 2005 (4)
July 2005 (4)
June 2005 (4)
March 2005 (3)
sp_recompile
SQL
SQL Helpers
SQL Tricks
sp_recompile is your friend
I've been doing a lot of code deployments lately and I've come across several occasions wherein my stored procedures wouldn't run as fast as expected compared to it's previously known execution time. The problem lies on the statistics...
Published
Tue, Aug 08 2008 11:47 AM
by
keithrull
Filed under:
SQL
,
sp_recompile
,
SQL utilities
,
SQL Tricks
,
SQL Helpers
Copyright DevPinoy 2005-2008