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…

SQL Administration Part 1

Here are some SQL Administrative queries:

sp_configure Use Type the following to see the options the system sproc “sp_configure” has available to…

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…

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:…

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…