What is the difference between temp table and table variable?
Answer Posted / nalla
Temporary variables logs very less into transaction log, so
compare to Temp tables, temp varaibles are good in
performance wise.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of a table?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
How will you optimize a stored procedure optimization?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What are logical/boolean operations in ms sql server?
What do you need to connect php to sql server?
What are joins in sql and what are the different types of joins?
What are the types of stored procedures in an sql server?
Is mysql the same as sql server?
Can truncate be rolled back?
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?
Please explain what is “asynchronous” communication in sql server service broker?
What is the difference between rank and dense_rank?
What is the order in which the sql query is executed?
Write a code to select distinct records without using the DISTINCT keyword.