Stored Procedure
Tag details
Welcome to the 'Stored Procedure' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'Stored Procedure'.
Latest blogosphere posts tagged “Stored Procedure”
-
Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime
IT answers —
Authority: 457
New Question Created by Pushan12346 days ago -
AS400 stored Procedure,what is the maximum parameters
IT answers —
Authority: 457
New Question Created by AmuthaTPT6 days ago -
SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table
Journey to SQL Authority with Pinal Dave —
Authority: 538
It is very easy to find out some basic details of any table using the following Stored Procedure. USE AdventureWorks GO EXEC sp_spaceused [HumanResources.Shift] GO Above query will return following resultset The above SP provides basic details such as rows, data size in table, and Index size of all ...2 weeks ago -
SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table
Visit SQLAuthority.com —
Authority: 128
It is very easy to find out some basic details of any table using the following Stored Procedure. USE AdventureWorks GO EXEC sp_spaceused [HumanResources.Shift] GO Above query will return following resultset The above SP provides basic details such as rows, data size in table, and Index size of ...2 weeks ago -
Find a stored procedure containing
Microsoft Technology, .Net, BizTalk, Sharepoint & etc. —
Authority: 119
Quite often you need to find which stored procedure contains key word. I find this blog and use SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE %foobar% AND ROUTINE_TYPE=PROCEDURE3 weeks ago -
SQL SERVER – Stored Procedure are Compiled on First Run – SP taking Longer to Run First Time
Journey to SQL Authority with Pinal Dave —
Authority: 538
During the PASS summit, one of the attendees asked me the following question. Why the Stored Procedure takes long time to run for first time? The reason for the same is because Stored Procedures are compiled when it runs first time. When I answered the same, he replied that Stored Procedures are pre-compiled, ...3 weeks ago -
SQL SERVER – Stored Procedure are Compiled on First Run – SP taking Longer to Run First Time
Visit SQLAuthority.com —
Authority: 128
During the PASS summit, one of the attendees asked me the following question. Why the Stored Procedure takes long time to run for first time? The reason for the same is because Stored Procedures are compiled when it runs first time. When I answered the same, he replied that Stored Procedures are ...3 weeks ago

