ScottPletcher (12/9/2015)

---

Create a separate index of just the IDs. Then select a random ID using ORDER BY NEWID(), then use that ID to get the rest of the columns....

TheSQLGuru (12/9/2015)

---

Handling gaps with my mechanism really is simple and efficient. Been there, done that, got the tshirt.

But your new requirement about category makes it much more likely you...

Thank you everyone for the replies, very helpful!!

Unfortunately there's no guarantee that there would be no gaps. Also, I need ti implement a logic similar to this. E.g. pick...

Thank you very much for taking the time to respond. Works perfectly.

Hi, Thanks for your response. Not sure if I want to follow that approach due to the BIGINT data types. I'm looking for a simple way of doing this, performance...

Thank you, I found the solution.

I needed to create the certificate with the /T switch to make it trusted and had to add "TrustServerCertificate=true" to the connection parameters in SSMS.

Thank you very much!

Thanks for your response. What do you mean by "computer account"? Do I have to create a new domain account on the Secondary and assign folder permissions on the Primary...

I'm reporting against a "read-only" db that gets updated every hour from live by an SSIS package.

Thank you very much Alan.

Want a cool Sig (7/21/2015)

---

I believe the query to text file saves as an ANSI but for Russian(Cyrillic) you need to have it encode the text as Unicode(UTF-8).

I'm not sure...

Download sp_BlitzIndex from

http://www.brentozar.com/blitzindex/

and read

http://www.brentozar.com/blitzindex/sp_blitzindex-duplicate-indexes/

Other reports use the exact same data source / connection string without any issues. I can't figure this out 🙁

Cheers Luis,

I can see the "RPC Starting" entry in profiler but not the "RPC completed", looking at the results from sp_who2 during report execution, CPU time and Disk IO values...

Thank you so much for your help.

I'd appreciate if you could show me how to overcome the issue when there are +2 missing records. So if there is no...