Answer Posted / senthilkumar
The syntax is : sp_helpdb 'tempdb'
db_size of a tempdb is 8.50 MB in sqlserver 2005.
| Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
What are the different acid properties?
What is a livelock?
What is the difference between mysql and sql server?
What is raid and what are different types of raid levels?
Does the order of columns in update statements matter?
What different steps will a sql server developer take to secure sql server?
Explain system functions or built-in functions? What are different types of system functions?
What is data mart? : sql server analysis services, ssas
Can group by and orderby be used together?
How to create function without parameter in sql server?
What is correlated subquery in sql server?
What is mscorsvw.exe - process - microsoft .net framework ngen?
how would you improve etl (extract, transform, load) throughput?
what types of replication are supported in sql server? : Sql server database administration
In which tcp/ip port does sql server run? Can it be changed?
