our db is still on recovery\read only mode, do you have query on that? or codes to execute this method you suggested: "delete entry from sysdatabase system table.

"

we could not execute detach or dropping because the db is on recovery\read only mode, and we tried also the sp_detach_db but no luck..

thanks

sir we restore the file from the bin then the status of the db is in recovery\read only, what would be the next step cause when we try to right...

whether it is intentionally or accidentally what we need is the solutions if there is..if there is none then we will going to reinstall the sqlserver that's our last option...

i asked again the person who did this, he told me that he took the db to offline then he delete the file manually where it was stored and then...

we dont need that database anymore but it causes our server to hung up..how can we detach that database on the sqlserver..

thanks

yes the mdf and log file deleted on the drive where he is stored..

THANKS MR PAUL I JUST REVISED MY SCRIPT USING THE DENSE_RANK() AND I GOT THE RANKING BUT I WILL OBSERVE THIS FIRST IF THIS WILL CONTINUE ON A CORRECT RANKING...

HELLO SIR I TRIED TO RUN YOUR QUERY BUT IT HAS AN ERROR.. THIS ARE THE ERROR ON THAT QUERY

Msg 156, Level 15, State 1, Procedure TestView, Line 10

Incorrect syntax...

i read the book and its good but the sample there does not meet my expectation, i dont even see where could be the columns that will provide for...

hello mrdenny that link where i posted my screen shot on execution plan and query result..thanks

sir mrdenny its very difficult to attached an image here can i ask your email add so i can send there the execution plan and the query result..thanks

thank your mrdenny for your valuable info. our set up in our server is 400 gigz harddisk,12 gigz of ram and quad cpu(4x4), sir i love to know more on...

hello mrdenny thank you so much for the info. i love to know more on how you set up your database tables and indexing, if you dont mind sir, what...

sir mrdenny how many minutes did your query goes for a hundreds of millions records? what was your method or way to accomplish a good performance please help