Interested to Buy Any Domain ? << Click Here >> for more details...
If we shrink the Databse and Files, how much size is
decreased?
- 1 Answers
- 3734 Views
- TCS, I also Faced
- E-Mail Answers
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 is meant by indexing files?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What are indexes in sql?
Which stored procedure will you be running to add a linked server?
What is standby servers? Explain types of standby servers.
Difference between report and query parameter. Why do we need different type of parameter?
How to get @@error and @@rowcount at the same time?
What are the limitation of the Online Index Rebuild Operation?
What is data source view or dsv? : sql server analysis services, ssas
Can multiple columns be used in sql group by clause in ms sql server?
Do you know what is difference between index seek vs. Index scan?
How extra digits are handled with numeric data type literals?
-
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)
