Ninja's_RGR'us (4/13/2011)

---

mister.magoo (4/13/2011)

---

That is definitely one to remember! Glad it worked for you as well, as there was the possibility in my mind that it might be version specific.

I am...

That is definitely one to remember! Glad it worked for you as well, as there was the possibility in my mind that it might be version specific.

I am using Microsoft...

Ok, so just on a whim, I thought I would try something....Build the string by inserting instead of appending....WHAMO!

Also include the CONVERSION to VARCHAR from NVARCHAR for "name" column to...

Any reason why you don't use this?

Exec sp_MSForEachTable 'Update Statistics ''?'' with FULLSCAN'

Bearing in mind the length considerations, this code now runs in 5 seconds for me for 9000 tables (the xml type fix doesn't work for me as I have generated...

I have also done a bit of testing and found that after your variable gets to a certain size (dependent on the amount of data you are adding each time!)...

Yet another April fools joke that destroys itself by saying "I'm a joke!"

What is wrong with leaving a joke to it's own devices?

Nice effort, but really - you might as well have enclosed it all in <APRIL_FOOLS_JOKE> tags.

Now CELKO's one I thought had a lot of work put into it and was...

rpfelgueiras (3/10/2011)

---

Hi!!

Today I had a problem with an important table on my database.

Someone updated all rows in that table, by mistake, because he did not put the where clause.

I'm wondering...

Here is a similar but slightly different version that has a get-out clause that allows deliberate global updates...

CREATE TRIGGER PreventGlobalUpdateTrigger ON YourTable

AFTER UPDATE,DELETE

AS

DECLARE @rowc BIGINT;

SET @rowc = @@ROWCOUNT;

-- Test for...

Nice solution Anton.

Hi Peter,

Can you provide some sample data - at the moment it is too hard to understand what you are working with...

It could be that cpu time measurements on something that quick are not reliable...

I have also noticed the same behaviour.

Also try putting two queries in one batch, run them both...

Ok, so based on your latest bit of information, try this:

sorry - hadn't spotted that you are on sql 2000...removed code that won't work for you...

ZA_Crafty (2/24/2011)

---

mister.magoo (2/24/2011)

---

Try this:

select Factor,min(PartNumber) as PartFrom,max(PartNumber) as PartTo

from Factors2Process

group BY Factor,stuff(PartNumber,7,5,'')

order by Factor,PartFrom

And by the way - there is no order by on the query in your cursor...