Like..

I will shrink the File & rebuild via wizard..

But for alter statement

(ALTER DATABASE runal_jagtap MODIFY FILE (NAME = 'runal_jagtap_data', SIZE = 50GB))

i have to execute this for all db's...

thanks Anthony, me still confused regarding the last Alter statment.. will study more on this and will come soon to ask you more on this post:-)

anthony.green (2/1/2013)

---

Well if they are at 25GB and they cant grow past 25GB then why bother shrinking? Do you need the space back to the OS for some reason?...

Thanks Anthony..

U see i have a DB and maximum it grows upto 25 GB. thats the max volume.. sounds very less.. but i have DB's upto 25 GB only

Now runal_jagtap...

Na Didnt understand the above query.....

anthony.green (2/1/2013)

---

Your options to release the space from the file is 1 of 2 ways. DBCC SHRINKFILE or create a blank database then transfer the objects.

If you go for...

I ran the DTA tool on testing server considering that SP & that DB,

I got some object names in Index Recommendation & Estimated improvement = 0%, partition Recommendation =...

Also please tell me how do i set the execution plan for that Stored procedure so that i will suggest developer to look into the specific query which is slowing...

Update statistics?

Hmm i have never done Update statistics on Database yet..

Please correct my belwo plan..

Sunday no one wotks on the Database

will perfom the below activity..

1) Full Backup - Using manitenencae...

I am totally :w00t: now

Will look in to this tomorrow.. thanks all for helping & assisting me

Perry Whittle (1/23/2013)

---

Execute the following against your database and substitute the table name in the WHERE predicate and post the results back please

SELECTOBJECT_NAME(i.object_id) AS TableName

, ISNULL(i.name, 'HEAP') AS IndexName

, i.type_desc...

Microsoft SQL Server 2005 - 9.00.5000.00 (X64)

Dec 10 2010 10:38:40

Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2

(Build 3790: Service...

Are u sure i need to do

Alter Table tablename Rebuild???

Error -Invalid syntax near Rebuild...

In Database Properties Auto Shrink = False

Its Heap & how do i check for Auto Shrink?