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 are acid properties of transaction?
Define left outer join?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What is plan freezing?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What is the native system stored procedure to execute a command against all databases?
What is replication and database mirroring?
Explain about Views?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
how many triggers you can have on a table? : Sql server database administration
What is Cross Join and in which scenario do we use Cross Join?
What triggers long term care?
What is the contrast between sql and pl/sql?
What is 'Join' and explain its various types.