I dont want to do on multiple instances, to get better performance we have isolated these servers. Looks like there is no other go,i may have to get another...

yes, i applied SP3 and even during SP3 installation it gave me a warning message about compatability, do you guys think that is fine. thanks

what do you mean by "update before runnig" , do i have to update OS to 2003 from 2008? I would like to install SQL 2005 on Win 2008 machine,...

what are the limitations i have to observe if i want to use developer edition on my stage for my purpose and what is the cost of Dev edition?

any other recommendations for my scenario to cut down the cost?

OK, here is what i am going to do with DEveloper edition, please let me know if i am voilating anything.

I have a stage server where in i will pump...

I havent started anythign on this but i would like to give some commands like " show statistics" and some other which are not harmfull but provide them information about...

I am trying to make 8 files just so i have better performance. Yes there are lot of activities on tempdb, my users insert millions of records into temp tables...

doubt.. if i configure 8 files each with 10GB and once the 1st file get filled does to jump to the second file or does it grow 10% on the...

yes, i need all columns and empcode is not indexed but many of the columns in the distinct are indexed and i cant change anything, is there any other simple...

i understand the 1st part, can you please explain the part that deals with NULL ?

I have updated my comment above.

Also is it possible that there is a NULL when you select distinct values of a columun which allows NULL ?

does this mean the query will never end in such scenario?

actuallly empid is not a PK but it is pulling from a view (select distinct empid) which allows null ans...

does anyone here compared these 2 features practically.

am i doing something worng here.

select distinct name from master.sys.databases s

inner join empdb.dbo.ldt a on s.name=a.dbname

where is_read_only = 0

and dbname in(select dbname,ntile(4) over (order by planid) as...