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? : Sql server administration

0 Answers  

---

How does index makes search faster?

0 Answers   QuestPond,

---

Explain collation?

0 Answers  

---

Explain cdc and sql injection?

0 Answers  

---

Introduction of rollup clause using sum and group by clause?

0 Answers  

---

---

How and why use sql server?

0 Answers  

---

what is maximum size of temp db?

4 Answers   iSoft,

---

What are the restrictions that views have to follow?

0 Answers  

---

How do I view a script in sql server?

0 Answers  

---

I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,

2 Answers  

---

What is the syntax to execute the sys.dm_db_missing_index_details?

0 Answers  

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---