What exactly are you trying to find out ??

This post has been posted on 2 locations 🙂

Yes it is possible in SQL server, For an example, I run a SP, that will take 3 parameters ad produce 5 Best matches for the parameters provided, this SP...

that's right Andrew, but how much large the table is, if its properly designed and indexed and the SP is tuned, then this is a small task, as you said...

Check connections from studio and the reporting server, if there is a problem with SP, they try running on SQL and check the time, there must be any index missing,...

I have faced the same problem, all you have to do is to wait until SQL completes the operation, if its shared by some other process try to kill that...

100 k/Day not that much data, this shouldn't cause any problems, the way you do is fine, other ways are having a backup and restore, which will leave you with...

28 Million records, that's a huge table for this process, i would suggest to take a backup, since i can remember once when i did this sort of operation, SQL...

How big are the transactions, how often you are running this SP, that moves data from production to reporting, can you post the SP so we can see if there...

I had one bug on log shipping with SP2, that was been fixed with SP3, apart from that i have installed SP3 on my warm server, dint roll out...

Hi

What is the database recovery model ???

http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx

Hope this information helps 😀

Try using RANK() function , this might help.

how about

select top 4 * from table order by newid()

just out of curiosity, which version has got this XP, i cant see this on SQL 2005 😀