Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between temp table and table variable?
- 8 Answers
- 27131 Views
- Microsoft, I also Faced
- E-Mail Answers
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
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
User wants only to display only pdf as export option in report manager. How to achieve this?
How can you list all the table constraints in a database?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What is the difference between the 2 operating modes of database mirroring?
How do I find the sql server database version?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
When would you use a before or after trigger?
Is sql different from sql server?
Why do we use non clustered index?
What happens when converting big values to integers?
What is schemabinding a view?
What is rank function?
What is the bookmark lookup and rid lookup?
