Try executing one by one statement. Its working for me.

Your condition for delete is not really deleting the table. Please check.

You may have to check leaf_ghost_count for those deleted.

SELECT leaf_insert_count

,leaf_delete_count

,leaf_update_count,leaf_ghost_count

FROM sys.dm_db_index_operational_stats(DB_ID(), OBJECT_ID('t1'), 1, NULL)

No delete will really delete the records. (This is for better performance. it will just mark the...

If you are not using FILESTREAM, then you do not need to add file gorup.

It is always better not to use FILESTREAM for smaller size of image for streaming performance.

Only standard Varbinary(MAX) has limit of 2GB. FileStream does not have. Please consider using Filestream Varbinary(MAX) if you have relatively larger size of image file(1 MB) else it can be...

Any error message you are getting?

You can always script out your constraints through wizard. Whats the difficulty you facing here?

No. Its not required.

Please have a look at the value of Is_Dynamic for the below :

Select * From sys.configurations

Switching the recovery model will break up your log backups chain. So when you switch recovery model from full to simple then tyou should have a full backup immediately other...

A Good twisting question...

Okei thanks!!!just to confirm, the following would list the last FULL backup datetime?

SELECT Database_Name,

CONVERT( SmallDateTime , MAX(Backup_Finish_Date)) as Last_Backup,

DATEDIFF(d, MAX(Backup_Finish_Date),...

Use Substring and charindex for ' ' character and split the string into three.

you can go thorugh the script section of SSC. There are quite many useful scripts. Apart go through the system functions and DMVs that would really help you out from...

update a set userid='Amolr' from wuser a inner join cliente b on a.fid = b.fid where b.c_number =a.c_number and userid = 'Amols'

and status in('OPEN')

Try this...(it will work if am not...

Can you just try to recompile the sp . Meanwhile we would be able to check the execution plan.

Can you updates stats on the table and try rebuilding the indexes? Just a thought...