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 is sql server replication? : sql server replication
explain different levels of normalization? : Sql server database administration
What happens when unicode strings concatenate with non-unicode strings?
New concepts of sql server 2005 use in your project.
Where do you find the default Index fill factor and how to change it?
What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.
what command is used to create a table by copying the structure of another table?
Explain what is analysis service repository?
can a database be shrunk with users active? : Sql server administration
What are the authentication modes in SQL Server?
if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?
What is a rollup clause?