What is the log shipping?

0 Answers  

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

How to get a list of columns in a view using "sys.columns" in ms sql server?

0 Answers  

---

how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.

1 Answers  

---

how you can move data or databases between servers and databases in sql server? : Sql server administration

0 Answers  

---

What is the process of normalising?

0 Answers  

---

What are different types of collation sensitivity?

0 Answers  

---

Explain what are db_options used for?

1 Answers   InterGraph,

---

What do you mean by a Composite primary key?

0 Answers   Genpact,

---

What is the stored procedure?

0 Answers  

---

What are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---