How to change server name in sql server?

0 Answers  

---

What is a non-clustered index?

0 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 is a heap?

0 Answers  

---

What command would you use to add a column to a table in sql server?

0 Answers  

---

how many joins we can write if at all we have n no of tables

5 Answers   Tanla Solutions, TS,

---

Tell me the phases a transaction has to undergo?

0 Answers  

---

How to delete all rows with truncate table statement in ms sql server?

0 Answers  

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

---

What are the advantages of using sql server over ms access or why should one use sql instead of ms access

2 Answers   CMS, Impetus,

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  

---

What are the different types of indexes?

0 Answers   Blue Star,

---