How display code or Text of Stored Procedure using Sql query in Sql Server ?
How to perfor If the table running time is taking 2hours and table is having 10 rows in it?
What are the factors you will check for the performane optimization for a database query?
7 Answers CarrizalSoft Technologies, DELL, SoftSol,
logshipping is Any difference 2000 and 2005?
What are different types of collation sensitivity?
What are the tables in sql?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Explain various On-Delete options in a DB table. Which is the default option?
0 Answers Akamai Technologies,
Explain trigger classes i.e. Instead of and after trigger?
What is a heap?
What protocol does sql server use?
What happens if you insert a duplicate key for the primary key column in ms sql server?
What is logshipping and its purpose?