You are magician 😉

Hi

I really didn't understand how output clause will help actually. The schema for all my 12 tables is different. So how can I use it there?

Thanks

dwain.c (4/23/2012)

---

If you've got 12...

I don't think it should be linked server. You added new server in same domain, right?

Unfortunately the time of day is not fixed. It just happens any time. Sometimes 2-3 times a day and sometimes none in a day.

GilaMonster (4/20/2012)

---

If it's a once-a-day thing and...

Sorry if I sounded like I haven't got any help. Sure I got whole lot of suggestions that wouldn't have come to my mind.

GilaMonster (4/20/2012)

---

Wait, what?

We've given you suggestions

Check for...

Thanks so much for your suggestions...I'll check for blockings.

This is like 'once in day' problem. But I am sure checking the blocking will throw light on how blocking are happening...

Well, then is it like hitting the wall? I can't make the transaction small. I can't completely remove the blocking. although I can try to minimize it but there is...

Hi Gail

Why fregmentation won't slow insert?

Suppose I have a clustered index and my indexes are fregmented heavily. That means my indexes are taking more pages. Now for sql server...

Paul

You scaring me 🙂

Index defrag will be done during non peak hours.It's already done once in week. We'll see if changing that to say,3 days, helps.Of course we'll first...

Gail, triggers are not there.

We plan to try two options first:

1.defrag indexes more frequently after checking how much they are fregmented.Currently they are rebuild weekly.

2. Increase CommandTimeout to 40s from...

I am planning to trace it. Since I don't have direct access to this server, I'll need to send the trace to someone to run it.

One question: What can block...

Hi Gail

I understand that but putting definitions and indexes for 12 tables wil make it so big that probably people won't want to see all that.So I tried to put...

I have already checked that. There are not too many indexes on any of these tables.

I was thinking if there can be some other way of handling this kind os...

is there any entry in your host file that points to your local?

Yes Of course:-). So I need to change my habit of drop create...

SQLKnowItAll (4/19/2012)

---

S_Kumar_S (4/19/2012)

---

Ofcourse there is some extra code in script,but it makes sure that when i run it...