Read Dirty To Me...Isolation Levels in SQL Server
http://www.littlekendra.com/2011/02/08/isoposter/ (Kendra Little - FREE Poster!)
http://www.littlekendra.com/resources/isolation/ (Excellent reference page)
http://michaeljswart.com/?p=604 (Transaction Phenomena)
Nolock info:
http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
http://www.windowsitpro.com/article/news2/beware-the-nolock-hint
Visualizing Your Indexes: The Science Behind The Art
http://sqlchicken.com/sql-university/ (Grant Fritchey's Series on Indexing)
http://www.jasonstrate.com/2010/12/can-you-dig-it-missing-indexes/ (Jason Strate, finding missing Indexes)
http://performance.sqlpass.org/PresentationArchive.aspx (Paul Randal presentation)
http://sqlfool.com/2010/12/disposable-indexes/ (Michelle Ufford)
http://www.midnightdba.com/Jen/2009/12/get-index-included-column-info/ (MidnightDBA)
http://www.sqlteam.com/article/sql-server-indexes-the-basics
http://www.mssqltips.com/tip.asp?tip=1452
http://msdn.microsoft.com/en-us/library/dd171921(v=sql.100).aspx
http://www.mssqltips.com/tip.asp?tip=1339
http://technet.microsoft.com/en-us/library/cc917715.aspx (Indexed Views)
http://msdn.microsoft.com/en-us/library/ms191475.aspx (Reading Pages)
http://msdn.microsoft.com/en-us/library/ms177443.aspx (Clustered Indexes)
http://www.sqlservercentral.com/articles/Fill+Factor/70827/ (Fill Factor)
http://technet.microsoft.com/en-us/library/cc280372.aspx (Filtered Indexes)
No comments:
Post a Comment