What would be the fastest way to update these reprocessed records in the big table? Since the clustered index is not changing, will SQL 2000 do an "Update...

Use BEGIN/END in IF/ELSE, you'll never go wrong.

WHILE @currentpos <= LEN(@workstring) ...

Try formatting a bit your code, or nobody will take the time to read it:

DECLARE @sql VARCHAR(8000),

@ThreeMonthsAgo VARCHAR(10),

@FourMonthsAgo VARCHAR(10),

...

Linked servers are quite tricky to work with...

If you want the best performance, you have to use OPENQUERY and move everything you can in the remote query, in order...

Maybe you could be interested in this article:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

This is what Chris meant with his post...

Ok, I think I got it:

CREATE TABLE #InventoryStage(

[SerialNumber] [varchar](20) NULL,

[TagNumber] [varchar](8) NULL,

...

Is this the code you tried?

--Not duplicated rows

INSERT INTO Inventory (

InventoryID,

SerialNumber,

TagNumber,

UnitCode,

ItemNumber,...

AFTER triggers fire after changes are applied to the underlying table, INSTEAD OF triggers fire when you try to update the underlying table, but, instead of applying changes, only the...

Animal Magic (8/4/2008)

---

weirdly this seems to be down to the name of the trigger?? If i create exact same trigger but call it [dbo].[UPTrg_StatusChanges] it seems to work fine?!?

I...

I think there are thousands of replies to a question like this in the forums.

The point is: why no primary key? Is there any good reason not to add a...

For some reason MS Visual Web Developer 2008 will not apply the formatting {0:F2} even with HtmlEncode set to false so I thought maybe the better approach would be for...

It took me 4 sentences to say the same thing... maybe synthesis is not one of my best qualities!:D

I had the same problem working with triggers and ADO when SET NOCOUNT ON wasn't in the procedure, but, as I see from your previous post, the instruction is there.

You...

I would say that "database optimization" means turning on the right settings and indexes on the database to allow applications to run as fast as possibile, while "Performance tuning" means...

It would be interesting to know how he could delete a LDF file with the service running...

What's the database recovery model?

You could try to attach the database with a...