PowerShell 3.0 Notes
We will post all miscellaneous PowerShell scripts, notes, tips and help on this page. For notes from specific books, please look at the…
Read MoreAuthor: Lincoln Bovee'
Execution Plan Notes
Clustered Index Seek: performed where there is a WHERE clause and the search parameter is included in the clustered index. Clustered Index Scan:…
Read More
SQL Server 2012 DMV’s (Dynamic Management Views)
Notes about DMV’s in General DMV data is discarded when the SQL Server service is restarted as it is stored in memory and…
Read More
PowerShell Community eXtensions (PSCX)
TOPIC PowerShell Community Extensions (version 3.0.0.0) SHORT DESCRIPTION Describes the Windows PowerShell Community Extensions (PSCX) module and how to use the contained cmdlets…
Read More
SQL Server 2012 Internals
Life Cycle of a Query The command parser evaluates the query and generates a hash to see if the buffer pool has an…
Read More