Explain candidate key, alternate key, and composite key?

0 Answers  

---

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

0 Answers  

---

What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?

7 Answers  

---

What are the requirements for sql server 2016?

0 Answers  

---

is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

How to use values from other tables in update statements in ms sql server?

0 Answers  

---

What is schemabinding a view?

0 Answers  

---

List the advantages of using stored procedures?

0 Answers  

---

What are the differences between stored procedure and view in sql server?

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,

---

how to rename the table

3 Answers  

---