Answer Posted / ashwini

SQL query will be compiled everytime it is executed.
Stored procedures are compiled only once when they are
executed for the first time.

What are the different Topologies in which Replication can be configured?

1183

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

1005

---

Which are the third-party tools used in sql server and why would you use them?

911

---

What is create statement?

951

---

What kind of problems occurs if we do not implement proper locking strategy?

1402

---

Define primary key?

1138

---

Can we store videos inside the sql server table?

979

---

How many types of cursor type are there?

1090

---

Explain indexes disadvantages?

1083

---

Do you know the different ddl commands in sql?

1052

---

what is the difference between Delete and Truncate command in SQL

1147

---

How many databases can we create in a single server?

207

---

What is a cursor, index in sql?

1069

---

What does sql server mean?

1063

---

What is difference between order by and group by?

1006

---