SQL Administration Part 1
Here are some SQL Administrative queries:
|
1 |
SELECT SERVERPROPERTY('IsClustered') |
sp_configure Use Type the following to see the options the system sproc “sp_configure” has available to…
Read MoreAuthor: Lincoln Bovee'
T-SQL Basic Command Examples
Some of these snippets are useful when scripting schema changes, as opposed to using the GUI tools. For example, we have several instances…
Read More
How to Find the last Execution DateTime for a Sproc
Have you ever wanted to find out the last time a stored procedure was executed, if ever? Here is a T-SQL snippet that…
Read More
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 More
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