what is normalization? what is denormalization?

9 Answers   Satyam,

---

Can we insert data if clustered index is disabled?

0 Answers  

---

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

What are different types of Keys? Please explain all the keys with a suitable example.

4 Answers  

---

What is difference between aggregate and analytic function?

0 Answers  

---

How do I start sql server?

0 Answers  

---

Mention the differences between having and where clause.

0 Answers  

---

What is sqlcmd?

0 Answers  

---

What are the transaction properties?

0 Answers  

---

Can sql servers link to other servers?

0 Answers  

---

how to count datewise data in sqlserver

4 Answers   CarrizalSoft Technologies, IndusInd Bank,

---