Peter Gadsby (10/29/2007)

---

Sorry, but that is tosh...... If a CREATE INDEX takes 10 minutes previously and then takes over an hour now, that is NOT bad design that is an...

What your server is doing those 3 mins then?

If not doing disk operations, not computing - then what?

Issues like "process has gradually got slower and slower" have nothing to do with disks, memory, hyperthreading or anything like that.

It's bad design issue.

It was preprogrammed by you System Architect....

Are you sure Tom Carr is an author?

Would you mind to look couple of pages back?

It's just almost exact copy of my script. "+6" is replaced with "-1" - that's...

In EM "Desing Table" there is an icon "Save change script".

After all changes you need to do are completed instead of saving table click on that icon.

Copy-paste to QA.

Enjoy.

Why not include it into calling code?

gayathri (10/24/2007)

---

I use procedure which finally selects from a table variable. This procedure is used in BCP command.

When i Execute the BCP command i get an error saying : BCP...

My SQL Agent doesn't think it's an error.

Many job steps generate this or other messages, they are accessible via Job History, but it does not make the steps (and...

Greg Snidow (10/24/2007)

---

So, Sergiy, I'm looking at the profiler and I see a button that opens something called 'performance monitor', that seems to be akin to the performance monitor in...

Greg Snidow (10/24/2007)

---

Also, I see a column in the profiler called 'NTUserName'. Can you tell me what table that is stored in? I have looked in what I...

Greg Snidow (10/24/2007)

---

What I need, for example is if DEMAND = 80 and FORECAST = 100, I need VARIANCE to be .80. Should be simple, but I can...

tjames (10/24/2007)

---

Sergiy you have peeked my interest. I am sure I am walking into something here, but let me do it any way.

If I do not update a table column...

Greg Snidow (10/24/2007)

---

... one person came to me to say emails were coming a day late, and another person said they were coming right on time. That is what...

How do you know it fails?

If you read several pages...

Hmm...

Actually it was simply an answer on the previous post.

The one from Michael Meierruth.

:ermm: