can you any body tell me why are go for the rebuild the
master database.what is the reason?
Answers were Sorted based on User's Feedback
Answer / bru medishetty
My Sincere request is to properly phrase the questions and
post the questions. Since the question you mentioned has no
meaning, only the guy answering has to properly phrase the
incomplete words and guess the question.
I guess the question is How to rebuild the Master Database
and what is the reason for rebuilding.
Rather than I answer this, may I suggest you to the below
link
http://msdn.microsoft.com/en-us/library/bb545450.aspx
Read as much as you can to know about SQL Server,almost all
of the questions you would need will be available.
I actually replied to another question in the same website
about the same question of Master rebuild, so please do not
post the same questions multiple times.
Thanks,
Bru Medishetty
www.LearnSQLWithBru.com
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vasu
Since the master database cosists of total server level
information like logins, sys table etc....
| Is This Answer Correct ? | 0 Yes | 0 No |
What is trigger and different types of Triggers?
i want table name basis on column name.
What Are Three Rules to UseĀ UNION IN SQL SERVER
Explain concepts of analysis services?
What is the difference between count () and rowcount ()?
What will happen when a Rollback statement is executed inside a trigger?
1 Answers Flextronics, Hexaware,
what is the difference between Delete and Truncate command in SQL
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What is the difference between distinct clause and group by clause?
Do you know what is a with(nolock)?
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?
Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)