Interested to Buy Any Domain ? << Click Here >> for more details...
If we shrink the Databse and Files, how much size is
decreased?
- 1 Answers
- 3731 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Mention the 3 ways to get a count of the number of records in a table.
How do I find sql server instance name?
How to delete multiple rows with one delete statement in ms sql server?
What does truncate do?
How to define output parameters in stored procedures?
What is the importance of three tier architecture?
How many partitions a clustered index has by default in sql server 2012?
Is sql server 2016 free?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What do you understand by the data quality services in sql server?
How to modify an existing stored procedure in ms sql server?
What are the differences between substr and charindex in sql server.
What the class forname () does?
How to rename databases in ms sql server?
What is the process of normalising?
