 Related Questions Assume that I have created a employees table which has 10 records. How to create a stored procedure to export all the records into the log file. Read Answers (3) | Asked by : vani We have used a Stored Procedure having large code in it. If we try to Alter the SP again then the entire code seems to be SCRAMBLED - Why ? Latest Answer : no.because,stored procedures are explicity invoked and trigger is nothing but a stored procedure but fires an event or data modifications occur.trigger is a implicity invoked. ... How optimisation and Performance in Sql Server 2000 can be achieved?What are the steps involved? How we will access a table of one server from a stored procdure in other server? Latest Answer : You can access this through the following syntax[Another Server IP].[Database Name].[Owner].[Table Name]e.g.[XXX.XXX.XX.XX].[myDB].[DBO].[EmployeeMaster] ... How are SQL Server databases physically stored under Windows 2000? How can we improve stored procedure performance? Explain the performance tuning techniques. Latest Answer : 1. Use many WHERE clauses in the SELECT statments.2. Select only those fields which you really require.3. Joins are expensive in terms of time. Join the tables using related fields manly indexed fields.4. Don't use unused ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
