What is difference between standardization and normalization?

0 Answers  

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  

---

What is the difference between a stored procedure and a user defined function in sql server?

2 Answers   Millennium,

---

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,

---

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

0 Answers  

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,

---

What are sp_configure commands and set commands?

0 Answers  

---

What is the fastest way to permanently delete a 1 million row table named customers?

0 Answers  

---

Explain the relational database management system (rdbms)?

0 Answers  

---

Can group by be used without aggregate functions?

0 Answers  

---

Why use “nolock” in sql server?

0 Answers  

---

What is table constraint?

0 Answers  

---