"The site is supposed to randomly order these rows every time the page is loaded"

So, we can't select that option

• This reply was modified 4 years, 11 months ago by  M&M.

Easy question. But I was a little careful while answering just to make sure it is not a trick question 🙂

Refer this.

https://www.mssqltips.com/sqlservertip/2502/limit-snapshot-size-when-adding-new-article-to-sql-server-replication/

Nice Read, thanks Andy.

Yes, that was a hint which made the answers look obvious. 🙂

Awesome.

Learnt something today 🙂

Brilliant question. We need more questions like this which tests the basics.

Easy points 🙂

Does it mean there is no MCSM program for SQL Server 2012 too?

Did you try some suggestions from this LINK

Nice question. We need more like this 🙂

Good one.

I have noticed this sometimes when full backups occur at night. May be due to network bandwidth issue. But this has not posed a problem to me so far.

Got tricked 🙂