Answer Posted / maskfriend

Normalize the data from the detabase.It reduces by the
normalisation rule like(there are 4 normalization rule and
BCNF)

What is the difference between SQL notification and SQL invalidation?

1187

---

What is dknf in normalization form?

1052

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1952

---

How to defragment table indexes?

992

---

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1053

---

What is a primary index?

924

---

How to update multiple rows with one update statement in ms sql server?

1204

---

What are temporal tables in sql server 2016?

884

---

How adventureworkslt tables are related?

927

---

What are different types of views?

948

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1119

---

What is sparse columns of sql server 2008?

1057

---

What are indexers?

1086

---

How to optimize stored procedures in sql server?

1185

---

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

1009

---