Advanced Search

Return to Snippet

Revision: 37812
at December 17, 2010 17:27 by hairajeshk
Initial Code 
recompile the keep the sp in compiled format for better performance.
	UPDATE STATISTICS PriceListTable
	DBCC UPDATEUSAGE (0, "PriceListTable")
	EXEC sp_recompile PriceListTable
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
To make an SP Recompile

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL