90% of databases are inactive mode :w00t: ? i am also curiuos ?

Yes you will take this...

you can go some optimal settings according to your asking requirements in that index like MAXDOP or SORT_IN_TEMPDB

these might help you.

http://sqlblog.com/blogs/tibor_karaszi/archive/2007/12/12/backup-compression-in-sql-server-2008.aspx

http://www1.unisys.com:8081/eprise/main/admin/corporate/doc/41371394.pdf

then how did you resolve it ? compression or zip ?

right click the maintenance plan...

@sudhakara,

If you are running short of space on disk , then you should go for shrink. Shrinking data file should be done with very intelligently, for genuine cause as it...

You can do one thing , dont drop/create index instead , DISABLE it before purge process ( it must contain

INSERTION into destination table ) and then REBUILD it...

SELECT TOP 1 Stock FROM Tb_Item_Cost_Ledger WHERE (ItemId = Tb_Item.CoA_ID) AND (Vdate <= '20100101')

AND ISNULL(stock, 0) > 0

ORDER BY Vdate DESC

can you explain the output logic, what you are trying to get ?

i don't think this is complete query as there is no stock > 0 clause , post complete query

.Additionally where are the table definition part ? that can...

there is a column "last_execution_time", check with it

USE following query for every concerned table dbcc showcontig( 'tablename')

for more details google "dbcc showcontig( 'tablename')"

🙂 for that Microsoft has to hire me. jokes apart , in sql 2008 there is feature of backup files compression

Jeff Moden (8/18/2010)

Bhuvnesh (8/18/2010)

Anamika (8/18/2010)

SELECT * FROM [font="Arial Black"]SYSOBJECTS[/font] WHERE XTYPE = 'P'

output of this query gives the new SP name.

My problem is while getting the create script for the...