Jeff Moden (8/1/2014)

---

You could disable them which drops all of the data from the index but keeps the meta data and see if peformance suffers. Of course, you need...

Jeff Moden (7/31/2014)

---

murnilim9 (7/31/2014)

---

Thanks for your kind response . Appreciate...

Thanks for your kind response . Appreciate it!

Here is the...

SQLRNNR (7/29/2014)

---

murnilim9 (7/28/2014)

---

SQLRNNR (7/28/2014)

---

Your query mandates a table/index scan. There is no filter/predicate/where clause on the query so it will return all records from the table. For the...

SQLRNNR (7/28/2014)

---

Your query mandates a table/index scan. There is no filter/predicate/where clause on the query so it will return all records from the table. For the query, an...

HowardW (7/25/2014)

---

murnilim9 (7/24/2014)

---

Hey ... I just applied OLA'script in my testing server and it works fine 🙂 but in his example of "EXEC stored proc such as :

EXECUTE dbo.IndexOptimize

Stuart Davies (7/23/2014)

---

murnilim9 (7/23/2014)

---

I have checked on that script ..but dont u think it is very complicated and difficult to be understood ? if i dont understand all the statements...

pdanes (7/23/2014)

---

murnilim9 (7/23/2014)

---

pdanes (7/23/2014)

---

murnilim9 (7/22/2014)

---

pdanes (7/22/2014)

---

murnilim9 (7/22/2014)

---

pdanes (7/22/2014)

---

twin.devil (7/22/2014)

---

I think you should consider Jeff suggestion, as he described above that if your 1st column have very low number of value,...

Stuart Davies (7/23/2014)

---

murnilim9 (7/23/2014)

---

I have checked on that script ..but dont u think it is very complicated and difficult to be understood ? if i dont understand all the statements...

I have checked on that script ..but dont u think it is very complicated and difficult to be...

pdanes (7/23/2014)

---

murnilim9 (7/22/2014)

---

pdanes (7/22/2014)

---

murnilim9 (7/22/2014)

---

pdanes (7/22/2014)

---

twin.devil (7/22/2014)

---

I think you should consider Jeff suggestion, as he described above that if your 1st column have very low number of value, which i...

ChrisM@Work (7/22/2014)

---

-- change the index to support a nested loops join between rs and r

-- with seeks to r on id and residual predicate of RNT and Man:

create nonclustered...

pdanes (7/22/2014)

---

murnilim9 (7/22/2014)

---

pdanes (7/22/2014)

---

twin.devil (7/22/2014)

---

I think you should consider Jeff suggestion, as he described above that if your 1st column have very low number of value, which i can see...

pdanes (7/22/2014)

---

twin.devil (7/22/2014)

---

I think you should consider Jeff suggestion, as he described above that if your 1st column have very low number of value, which i can see in the...

pdanes (7/21/2014)

---

murnilim9 (7/21/2014)

---

twin.devil (7/21/2014)

---

If you are loading large data in that particular table where you have created the index, then you can use disable and restore approach which can increase...