This is a very well presented article which explains how we can obtain the query plan - estimated execution time for a query in SQL Server. It is also very useful because we can see in detail the process of registering and calling a .NET assembly from within SQL Server. Applies to: Microsoft SQL Server 2005 and Microsoft Visual C# .NET, but most likely will be possible to use a similar or even the same process in SQL Server 2008 and later.
http://technet.microsoft.com/en-us/library/ms345130.aspx
No comments:
Post a Comment