What is the disadvantages of index?

3 Answers   TCS,

---

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

2 Answers   Sparsh,

---

How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes

1 Answers   INDUS,

---

what are constraints? Explain different types of constraints? : Sql server database administration

0 Answers  

---

What the different components of Replication and what is their use?

0 Answers  

---

How will u get 5 years back record?

5 Answers  

---

How to create a view using data from another view?

0 Answers  

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

What is usually the first word in a sql query?

0 Answers  

---

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

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 the class forname () does?

0 Answers  

---