Hi All, My requirement is to produce xml file from Database. There are many tables in the DB which have relation to each other,I have to make use of the tables and then create a xml file from them. Eg: Table1 has 4 columns ApplicationId, Applicat...

<p>Hi All,</p> <p>I have a query regarding optimization and SQL cache miss..</p> <p> </p> <p>There is a stored procedure which has a parameter @idmember</p> <p>Create proc proc_procname</p> <p>@idmember int = null</p> <p> </p> <p>Question:...