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 |
How to override dml statements with triggers?
What is bcp? When does it use?
How to query multiple tables jointly?
how can u select the Distinct values in the table, table having 20 columns , i want all columns
What’s the use of custom fields in report?
What is the stuff and how does it differ from the replace function?
What happens if the update subquery returns multiple rows in ms sql server?
What is difference between inner join and join?
What are the different types of backup avaible in SQL SErver
What are the restrictions while creating batches in sql server?
How to use transact-sql statements to access the database engine?
how to find 6th highest salary
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)