In our day to day life with SQL Server, We refer web for many reasons.

This includes understanding new SQL Server features or Recollecting syntax of rarely used commands or to check solutions for unfamiliar errors.

While searching what we need on Web, We may have to come across lots of irrelevant and incomplete pages before finding the right one for us.

But In some instances, quite few pages gain our attention. Those pages not only answer our questions but take our knowledge to the next level.  I see them as pearls in the Ocean.

In this post, I would like to share some of the pearls with our SQL Server Community.

Below links might be familiar for experts. But I feel proud to continue sharing this list with SQL Server Community at regular interval.

1.       13 Things You Should Know About Statistics and the Query Optimizer

http://www.simple-talk.com/sql/t-sql-programming/13-things-you-should-know-about-statistics-and-the-query-optimizer/

2.       Debunking myth about T-Logs in full backups

http://www.sqlskills.com/BLOGS/PAUL/post/Debunking-a-couple-of-myths-around-full-database-backups.aspx

3.       Lock Escalation by Sunil Agarwal

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/05/17/lock-escalation.aspx

4.       Important checklist collection by Brad Mcgehee

http://www.bradmcgehee.com/2010/06/sql-server-operating-system-checklist/

http://www.bradmcgehee.com/2010/06/sql-server-hardware-checklist/

http://www.bradmcgehee.com/2010/08/sql-server-monitoring-checklist-2/

http://www.bradmcgehee.com/2010/10/sql-server-database-maintenance-checklist/

http://www.bradmcgehee.com/2010/06/sql-server-instance-checklist/

5.       Great SQL Server Debates: Lock Pages in Memory

http://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/

6.       SQL Server 2008 - Summary of Training Sessions By Jose Barreto

http://blogs.technet.com/b/josebda/archive/2009/04/12/sql-server-2008-summary-of-training-sessions.aspx

Have a nice day !!!