How to find which stored procedure is currently running in sql server?

0 Answers  

---

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 Answers  

---

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

0 Answers  

---

Can you please differentiate between a primary key and a unique key?

0 Answers  

---

What are a scheduled jobs or what is a scheduled tasks?

0 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

---

What do you mean by acid?

0 Answers  

---

What is the difference between a primary key and a unique key? Are they the same?

0 Answers  

---

What does the on delete cascade option do?

0 Answers  

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

0 Answers  

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---