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.

Do you know what guidelines should be followed to help minimize deadlocks?

1 Answers  

---

What are approximate numeric data types in ms sql server?

1 Answers  

---

What is inline variable assignment?

1 Answers  

---

What is a livelock?

1 Answers  

---

What is dimension table? : sql server analysis services, ssas

1 Answers  

---

What are “phantom rows”?

1 Answers  

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1 Answers  

---

What are the disadvantages of using the stored procedures?

1 Answers  

---

What is the recovery model?

1 Answers  

---

How do I shrink an ldf file?

1 Answers  

---

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1 Answers  

---

how to define testing of network layers? : Sql server database administration

1 Answers  

---