you may want to refresh statistics before you go on ...

print

'-- Usage ' + db_name()...

- it's useless to create the index if there is only one value. The chance of it being used is fairly equal to 0

you are always performing a full table scan because you did not provide an index for [ProducerId]

This way (b)locking and waits will occur !!

Jus create an index on...

- Is this meaning you want your column "workfunction" to be a bitmap ?

    check out the implications !!

    - http://www.sqlservercentral.com/columnists/dpoole/usingbitstostoredata.asp

- you would need a function with cursor (or temptb)...

Thats exactly what SQLAgent is doing !

Enterprise Manager / Management / SQLAgent / Jobs

Create a new job, add a jobstep containing your SQLscript,...

Works fine overhere ...

CREATE TABLE [BillPayment] (

 [billpaymentId] [int] IDENTITY (1, 1) NOT NULL ,

 [billPaymentDate] [datetime] NULL ,

 [newBillBalance] [float] NULL ,

 [billAmount] [float] NULL ,

 CONSTRAINT [PK_BillPayment] PRIMARY KEY  CLUSTERED

 (

  [billpaymentId]

&nbsp

can you post your DDL ?

I like the article, but concering the newsequentialid ...

can someone find the flaw in my testquery which proves they'r not sequential ???

Declare

@test-2 table

...Do note that you CAN include varchar(max) fields in indexes but you cannot create and index on a varchar(max) field itself....

Indeed, including the varchar(max) column, you would aim for an...

- keep in mind to rebuild all tables / indexes and to run sp_updatestats and DBCC updateusage.

- indeed sp1 takes longer than the actual upgrade

- IMO dts-migration has been enhanced...

... 5. Concerned about something I read in the Resource Guide. It seemed to indicate that any syntax referencing something like dbname.dbo.tablename would need to be corrected to boname.sys.tablename. Yet,...

- you can deny the users rights to any object in the database. Check BOL !

DENY

    { ALL [ PRIVILEGES ] | permission [ ,...n ] }

    {

        [ (...

Scott Coleman explained it very clearly

may i add that you cannot index a varchar(max) column...

- I hope you're performing SQL backups using the T-sql backup statement or a maintenance job from sqlserver

- If a db is "to big" that my have two causes :

  ...

Thanks for the feedback.

in this case, you didn't get the answer overhere, but now others will !