Mention the differences between local and global temporary tables.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How to install sql server 2005 express edition?

0 Answers  


How to test a dml trigger in ms sql server?

0 Answers  


Explain the relational database management system (rdbms)?

0 Answers  


Is it safe to delete log files?

0 Answers  


Explain primary key and foreign key constraints?

0 Answers  






What is pessimistic concurrency?

0 Answers  


Does table partitioning improve performance?

0 Answers  


What information is maintained within the msdb database?

0 Answers  


Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

0 Answers  


What are the main differences between #temp tables and @table variables and which one is preferred?

0 Answers  


When you should use a low fill factor?

0 Answers  


What is dbcc? Give few examples.

0 Answers  


Categories