How do you load large data to the SQL server database?

2 Answers  

---

What is Trace flag?

1 Answers   Wipro,

---

how you can list all the tables in a database?

0 Answers  

---

What are the steps you must follow to hide sql server instances?

0 Answers  

---

What is self contained multi valued query?

0 Answers  

---

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 Answers  

---

What are the differences between union, intersect, and minus operators?

0 Answers  

---

What do you mean by 'normalization'?

0 Answers   Ernst Young, Thomson Reuters,

---

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 three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

How do you delete a data source?

0 Answers  

---

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

0 Answers  

---