Sorry guys,, i can't really amend the stored procedure as it gets fired every minute when certain events happen.

Hence i am taking this approach.

The result i get is:

exec ee_updatestatus12,1,2009-06-19 11:02:59.923,5,0

exec...

Thank you Joe,

It does make sense after reading the article.

Thank you for ur reply joe, but i am still not clear.. What do u mean it can be used for sampling?? Could you provide me with some examples.

Many thanks.

Thank you for ur reply John

Does this mean that i can get rid of those indexes where there hasn't been any seeks, scans or lookups,,eventhough there has been updates. What...

Thank you abhay for your response.

i don't really want to amend my existing stored procedure or create a new stored procedure.

i tried the following:

select 'exec ee_updatestatus',assetid,',', '1',',', getdate(),',', '5',',' ,'0'...

Thank you all again for ur responses;

Managed to get a planned downtime to restart the sql server.

Also i added the estimate only clause to CheckDB on our teste...

thank you pradeep

Thanks for ur responses again.

I have full backup running every week, incremntal back up every night and then transaction log back up every 10 minutes.

But also every week it...

Thank you guys for your responses;

the mdf is 11GB and the log file is 2 GB. So it's using 13GB of the Drive space. Total drive space is 19 GB....

Thank you for your reply.

Will shrinking the file have any affect on the scheduled jobs that i've got set up.

You can use datediff to get the number of days;

select datediff(dd,'2001-01-01 00:00:00','2001-12-31 00:00:00')

this is what i think ( Maybe SQL experts can shed more light on this) as i am only a newbie.

indexing the column used in your foreign key is a...

Example

DISABLE TRIGGER employee.uAddress ON Employee.Address;

GO

ENABLE Trigger employee.uAddress ON Employee.Address;

Syntax

ENABLE TRIGGER { [ schema_name . ] trigger_name [ ,...n ] | ALL }

ON { object_name | DATABASE | ALL SERVER }...