hiii ramesh

query provided by u is not fulfilling the requirement ,

just read above posts

& suggest soln

Thanx in advance

hiii Rbarry

got error

Msg 8120, Level 16, State 1, Line 1

Column 'db_size.dbname' is invalid in the select list because it is not contained in either an aggregate function or the GROUP...

hiii dan

i want O\P in foll. format

dbdate dbname datasize_MB

====== ======== ...

fire

select @@version

and post the output here

GilaMonster (2/19/2010)

---

sanketahir1985 (2/19/2010)

---

Obviously first one

because in first query both the table will be scanned only for condition a.name=b.name

In second query whole table2 will be scanned then it will...

best way is to run upgrade advisor

just go thru attachment

Obviously first one

because in first query both the table will be scanned only for condition a.name=b.name

In second query whole table2 will be scanned then it will be compared...

Have u changed any sp_configure settings?

sply min memory,max memory

Hii

Do not change any configuration settings without having the root cause why RAM is getting utilized. ByDefault sql server uses available RAM.

2ndly run the perfmon in peak hrs...

many options are avasilable

use import export wizard(for one time movement)

u can use ssis package too(For daily moving data)

thats what i replied

first query gives u windows operating system service pack

second query gives u sql server service pack.

why?

thats how microsoft has liked to do the things.

if u r...

Or if u want to do manual work,then foll. script will collect all the data from ur sql server.

go thru attached rtf to create rdl for preparing reports, u will get some idea

fire Sp_updatestats on the database (considering this is test server)

then use database

Try to find out the queries which are taking more IOs using profiler