Adi Cohn (2/4/2009)

---

You need to find the max rating for each bookid. Then you can use this number as the first key in the order by clause. Here...

Maybe I didn't explain clearly my request.

I will give another sample.

Create table #t(rating int,bookid int)

insert into #t

select 97, 201

union all

select 96,100

union all

select 95,300

union all

select 50,100

union all

select 10,201

union all

select 30,300

need...

thanks for reply.

But in this link, It said, one array, one logical drives has high performance. I am so confused.

http://h20000.www2.hp.com/bizsupport/TechSupport/document.jsp?lang=en&cc=us&taskId=110&prodSeriesId=415598&prodTypeId=12169&objectID=c00622089

An issue has been identified on the MSA1000, MSA1500...

our new server is production server. It will be heavily loaded. In my plan, even though we will develope DW, it should be considered to use a seperated server. not...

I didn't get SID using your query, just return empty recordset. I guess I passed the wrong parameter.

I still try to get result from your query. actually it is the...

Thanks for your reply.

I have permision to logon to AD server. But I don't know how to retrieve SID for this user.

Another thing I just noticed is that error...

Very very good article. From here I learn how to use Tally table, QuoteName, Grouping.

Thank you!:D

I met this problem before. I just applied Sp2 to Client tools, then every thing is ok.

Thanks for all replys.

Actually, I did meet Check DB problem when I run scheduled maintenance job to do integrity check. It only check master database. For this problem, I guess,...

What authentication mode do you use?

Can you connect to this server using IP address?

I understand your saying.

but if not implement replication between two clustering active/active nodes or just two seperate nodes (no auto failover) , what 's the best way to do...

Thanks for your reply.

Web users just query most databases. Internel users maybe occationlly change table structure/add Sps/DML. For my databases, Changes in one part is manually updated. using Merge replication...

this is a dedicated server. ram is 8G. 4 CPU.

Only this SP got cachemiss, others are ok.

Carl Federl (6/26/2008)

---

"The Log, TempDB, and Data files all need to be in RAID5 configuration for optimum performance"

You need to find a real expert.

Here is an approach to confirm if...

select d2.data_size_mb - d1.data_size_mb,d2.data_size_mb,d2.run_Date

from db_size d1 ,db_size d2

where d1.data_id<d2.data_id and

d2.data_id in (

select min(data_ID) from db_size

where data_id>d1.data_id

)

order by d2.data_ID