Clustered and Nonclustered Indexes Described
Clustered Clustered indexes sort and store the data rows in the table or view based on their key values. These are the columns…
Read MoreCategory: SQL Server
All things SQL Server
SQL Server Roles
SQL Server-level Roles • SysAdmin: Allows users to perform any activity on the server. • ServerAdmin: Permits users to manage configuration options on…
Read More
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 More
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
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
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