What’s the distinction between dropping a info and taking a info offline?

0 Answers  

---

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,

---

Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  

---

What kind of problems occurs if we do not implement proper locking strategy?

0 Answers  

---

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,

---

Can group functions be mixed with non-group selection fields in ms sql server?

0 Answers  

---

What is the difference between getdate and sysdatetime?

0 Answers  

---

What is table constraint?

0 Answers  

---

What are mdf,ndf,ldf files and how to see the data in those files?

6 Answers   Accenture,

---

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  

---

What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

---

what changed between the previous version of sql server and the current version? : Sql server database administration

0 Answers  

---