What is #temp and @table variable in SQL server?

0 Answers  

---

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

0 Answers  

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

Can we create clustered index on non primary key column

20 Answers   ABC, CTS,

---

What is fill factor and pad index?

0 Answers  

---

In the primary key have a multiple field or not?

8 Answers   TCS,

---

Explain what are the database objects? : SQL Server Architecture

0 Answers  

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

0 Answers  

---

what is the Enterprise manager(2000) and management studio (2005)?

2 Answers  

---

How you can get a list of all the table constraints in a database? : Sql server administration

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,

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

---