You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  

---

i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

What is the difference between a local and a global variable?

5 Answers  

---

What is the difference between getdate and sysdatetime?

0 Answers  

---

write the query for taking database restore in sql?

2 Answers  

---

What are window functions in sql server?

0 Answers  

---

What is a dbms wizard?

0 Answers  

---

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

0 Answers  

---

How to recompile stored procedure at run time?

0 Answers  

---

How to retrieve data from log files in SQL SERVER ?????

1 Answers  

---

How to execute multiple stored procedures at one time in sql server?

0 Answers  

---