Here is a start:

Tips on Optimizing SQL Server Clustered Indexes

the syntax to tell if a column was updated is:

IF update(Column_Name)

but I don't understand what are you trying to accomplish? 

Sorry try this!

Select number 

from MyTable

order by

  ISnull(cast(parsename(Number + replicate('.0',3 - len(Number) + len(replace(number,'.',''))),4) as int),0)

 ,ISnull(cast(parsename(Number + replicate('.0',3 - len(Number) + len(replace(number,'.',''))),3) as int),0)

 ,ISnull(cast(parsename(Number + replicate('.0',3 - len(Number) +...

CREATE PROCEDURE up_GetAccountNumber

@TypeFlag as varchar(3),

@CostCentre as varchar(5),

@AccountNumber as int OUTPUT AS

begin

SET NOCOUNT ON

UPDATE tblnumberingsystem SET @AccountNumber = nmb_latest= nmb_latest +1  WHERE nmb_type=@AccountType AND nmb_costcentre=@CostCentre

end

After ALL are completed!!

... worked equally fine with <= 4.............

if you have four dots('.') (IP addresses)

then

Select *

from Table

order by

  cast(parsename(ColX,4) as int)

 ,cast(parsename(ColX,3) as int)

 ,cast(parsename(ColX,2) as int)

 ,cast(parsename(ColX,1) as int)

I am in shock!!! These are unbelievable close answers

Not sure why you want to do that but:

declare @sql varchar (1000)

declare @tablename varchar (50)

set @tablename = 'a'

SELECT @sql = Replacte(strSQL,'@tablename',@tablename&nbsp

Let me warn you that this sort of code is not good when  multiple rows are affected !

Not sure if after_total is a running sum or not but here is my first guess:

Update  P 

          Set [after_sum]= A.Tot

From

    product P

   join

  ( select  id, int_Product,...

I liked that one

Apparently we'll be crossing Filghts! I am going to London 2 weeks before I go to PASS

I have tested his many many times for skeptic developers  that needed proof all the time and I can assure you that there are no performance benefits whatsoever in searching!! I/O...

The ones that I've tried lately are comming with only one almond