Answer Posted / the smart one

constraint is something that is restricted or prohibited
for example.
1. Not driving with a license

2. partying after hours if 17 or younger.

Which data type columns are the best candidates for full-text indexing?

1026

---

What are the built in functions in sql server?

1030

---

What's new in sql management studio for sql server? : sql server management studio

1129

---

What are different types of collation sensitivity?

1029

---

what is memory-optimized nonclustered indexes

1067

---

What is meant by referential integrity?

1050

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1161

---

Explain different types of Normalization.

1908

---

Explain activity monitors

1132

---

What is the rdl file?

141

---

What is the bookmark lookup and rid lookup?

1037

---

Is port 1433 secure?

1042

---

How to insert data into an existing table?

1031

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

1027

---

Explain the working of sql privileges?

1146

---