Please refrain from the use of maintenance plans.

I would recommend the defrag script by Michelle Ufford way before any others offered on the internet based on experience and client experience...

You can try a query like what was in that article. If it returns results, then you have the packages stored in SQL Server (or at least some of...

I have charged them on occasion.

Lowell (6/30/2014)

---

well, first, 26 milliseconds is fast. the difference is pretty minimal for things under 50 milliseconds, i don't know if it's worth investigating much.

...

could it be that because the...

These days my answers are along the lines of...

A DBA - to which they give the quizzical look

Then I say

A Database Consultant - seems to keep the requests for free...

David Burrows (6/30/2014)

---

Actually Lynn's solution looked like...

Hugo Kornelis (6/29/2014)

---

Got it wrong.

I hate these questions where a declaration bad practice is buried under a heap of distracting code. I know that this happens in real code too,...

How long after you wake the machine are you waiting to do this data retrieval?

Long enough to have other tasks run first?

Sean Lange (6/30/2014)

---

SQLRNNR (6/30/2014)

---

Lynn Pettis (6/29/2014)

---

Koen Verbeeck (6/29/2014)

---

Lynn Pettis (6/28/2014)

---

It is scary how people manage to get into working with databases and then expect others to bail them out when...

https://www.youtube.com/watch?v=O0wOD9TWynM

Lynn Pettis (6/29/2014)

---

Koen Verbeeck (6/29/2014)

---

Lynn Pettis (6/28/2014)

---

It is scary how people manage to get into working with databases and then expect others to bail them out when they are in...

When you do the conversion that is an explicit conversion.

If you allow SQL Server do the conversion, that is an implicit conversion.

Common places for that to happen is in joins...

Do you mean convert_implicit?

Have you tried making any adjustments to the provided code to make it work for your scenario?

Lynn Pettis (6/28/2014)

---

It is scary how people manage to get into working with databases and then expect others to bail them out when they are in over their head.

And the...