Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between temp table and table variable?
- 8 Answers
- 26856 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
Explain the stored procedure?
Can an automatic recovery be initiated by a user?
What do you mean by data integrity?
Explain about thread and memory management process of SQL?
what changed between the previous version of sql server and the current version? : Sql server database administration
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What are some examples of schemas?
Does a full backup include transaction log?
what is package and it uses and how can u call a package
What is the maximum rows in sql server table?
Describe in brief sql server monitoring ways.
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
When multiple after triggers are attached to sql table, how to control the order of execution?
What is 2nf normalization form?
What is store procedure?
