Any chance in getting an execution plan?

Kurt

I've been using a procedure written by Gregory A. Larsen. It will display the top worst performing queries. It comes in quite handy and may help you out....

When faced with a situation like this there are several things I'd need to know. How long does the Agent Job take to run? Are there going to...

So I had a little time to play with this script. I found where you introduced a bug when you added the square braces around your table name, where...

CREATE TABLE #IndexFrag(

database_id int,

object_ID int,

index_id int,

name varchar(max),

page_count int,

avg_fragmentation_In_Percent real )

Change your NAME column to varchar(max) and I think your code will work.

Kurt

pillar

I've run into this issue before and the way I was able to get around this was to create a batch command file w/i the job that starts by mapping...

I have to move data from a production copy of a database to a development copy. I do this by using an Import Data task and literally move all...

If I were you I'd poke around to find an index manager that looks at the indexes that exceeds a threshold of fragmentation. Typically there is a much smaller subset...

I use the Auto_Fix option on sp_change_users_login to fix orphan users.

Kurt

If I were you I'd poke around looking for an SOP for setting up tempdb. It is worth reading and you will learn a lot. I'd also suggest...

distort

Jeff Moden (12/2/2013)

---

For the record, I don't actually use Maintenance Plans to do backups. I've developed my own stored procedures that are scheduled as jobs. Maintenance Plans just...

I wrote a stored procedure that creates a temp table which I use in a calling stored procedure. You cannot declare an output variable as a user defined table...

Lowell (11/27/2013)

---

... i saw an article in the news that said that this year is the first time Thanksgiving and Hanukkah fall on the same day, and it won't happen...