Interested to Buy Any Domain ? << Click Here >> for more details...
If we shrink the Databse and Files, how much size is
decreased?
- 1 Answers
- 3770 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 data source in connection string?
Does index slows down insert statements?
Explain index in sql server?
How do I find information about the install locations for the various instances running on a computer?
What is the need for group functions in sql?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
can a table be moved to different filegroup? : Sql server administration
What is row_number function?
What is for xml in sql server?
Explain multiserver query
Can we use max in where clause?
Can we rewrite subqueries into simple select statements or with joins? Example?
-
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)
