If we shrink the Databse and Files, how much size is
decreased?
Answer / lmr
The primary data file cannot be made smaller than the size
of the primary file in the model database.
for eg. while creating a db having size 10 MB
N GREW 100MB
then max the can be shrunk to 10MB.
| Is This Answer Correct ? | 0 Yes | 0 No |
what type of indexes physically sort data?
Explain how to send email from sql database?
Explain activity monitors
when would you go for denormalization? : Sql server database administration
What are the built in functions in sql server?
What is the fillfactor concept in indexes?
How to verify a user name with sqlcmd tool?
What is the difference between Procedure and Function
4 Answers Accenture, Nagarro, TCS,
Explain about remote stored procedure?
what is joins please explain breffly ??
Tell me about Triggers?
How to create new databases with "create database" statements?
Oracle (3253)
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)