Thanks a lot.

Regards,

Sushant

DBA

West Indies

Is there any way other than shrinking??

as I want to avoid it.

HAPPY NEW YEAR AHEAD.

Regards,

Sushant

DBA

West Indies

I successfully deleted the unuseful rows from the table.

I used sp_spacesused 'tablename' to see how much space was freed up , and it was 10 gb.

The earlier size (of database)...

thanks a lot

Regards,

Sushant

DBA

West Indies

@ Gianluca

Thanks a lot.

Regards,

Sushant

DBA

West Indies.

I tried to do that, It threw an error:-

Msg 15600, Level 15, State 1, Procedure sp_serveroption, Line 177

An invalid parameter or option was specified for procedure 'sys.sp_serveroption'.

Regards,

Sushant

Does education (bachelor's or master's) also influence the pay in case of SQL server DBA ??

Regards,

Sushant

@ Lynn

I heard in INDIA, its growing very fast...

The average package for sql server dba 3yrs exp would go around 7 lac INR (15,555 $)annually

Regards,

Sushant

this thread is 15 months old..

the figures would change now as that time it was recession and

now the market is growing very fast..

Regards,

Sushant

DBA

West Indies

@ ninja

Hey buddy, I am not telling to u, i am just telling in general.

Thanks for googling for me .

I appreciate that.

Regards,

Sushant

isint it too much..

they asking for giving 4 exams??

Its better that i give other exams.

🙂

Thanks.

Sushant

If you are unable to do anything, why dont you restart your sql server?

More options :-

http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/7b45f0de-2aa3-4de0-930b-d9d0fe931b3a

Regards,

Sushant

did you try to shrink it thru SSMS gui?

Regards,

Sushant

@mvillegascellar

I had the similiar case as you and i use this code to shrink the tempdb.

USE tempdb

GO

DBCC SHRINKDATABASE(N'tempdb', 10, TRUNCATEONLY)

DBCC SHRINKDATABASE(N'tempdb', 10)

Regards,

Sushant

Idera's SQL diagonistic manager has been good in the fields you are requesting.

Regards,

Sushant