Answer Posted / lekhrajdeshmukh

We have to decrease the size of a log file by shrinking the
large file.

Syntex:-
DBCC dbname
go
DBCC shrinkfile(filename,sizevalue)
go.
for eg I want to shrink the filename data of databse userdb
to 7 mb.

dbcc userdb
dbcc shrinkfile(data,7)

How can we check the sql server version?

1063

---

What is merge?

1018

---

What is mean by candidate key?

1011

---

How will you decide the active and passive nodes?

1128

---

How and why use sql server?

1007

---

How much space does sql server 2016 take?

974

---

What is the recommended total size of your memory optimized tables?

966

---

What is replication and database mirroring?

1047

---

What is database mirroring?

1117

---

When is update_statistics command used?

1042

---

What is the purpose of the master database?

1129

---

Define outer join?

997

---

Does a sql server 2005 select statement require a from?

1019

---

What is query optimizer in sql server?

1020

---

How to create an index on an existing table in ms sql server?

980

---