Answer Posted / anamika
How to know the size of any database:
Syntax:
sp_helpdb 'tempdb'
db_size of temp db 38.56 MB.
| Is This Answer Correct ? | 6 Yes | 8 No |
Post New Answer View All Answers
Which Model uses the SET concept
What does asynchronous call backs means?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What is an sql server agent?
What are “lock” hints?
What do you understand by user-defined function in the sql server?
What action plan is preferred if sql server is not responding?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What are the different normalization forms?
What are page splits?
How do I save a stored procedure in sql server?
What is the difference between writing data to mirrored drives versus raid5 drives
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
How to include text values in sql statements?