can a database be shrunk with users active? : Sql server administration


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is difference between oltp and olap?

0 Answers  


how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,


What is the minimum recommended amount of ram for sql server 2012 enterprise?

0 Answers  


How to sort the query output with order by clauses in ms sql server?

0 Answers  


What is the use of tempdb? What values does it hold?

0 Answers   Abacus,






You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  


What are the different types of collation sensitivity in sql server?

0 Answers  


What is difference between process and thread? Explain lazy writer funcationality.

2 Answers   Microsoft,


Explain about unique identifier data type in sql server?

0 Answers  


What is sql server profiler?

0 Answers  


How to add code to the existing article (using improve article)?

0 Answers  


How to stop log file growing too big?

0 Answers  


Categories