About Trusted Foreign Key Contraints
I will post some of my findings about trusted foreign keys and constants here since this has become a minor issue at work.…
Read MoreCategory: Queries
Database Availability State Statuses
The possible values in the State and State_Desc columns of sys.databases are: 0 = ONLINE 1 = RESTORING 2 = RECOVERING 3 =…
Read More
T-SQL Querying and Query Processing Order
The order in which we write T-SQL queries happen in this order:
|
1 2 3 4 5 6 |
SELECT FROM WHERE GROUP BY HAVING ORDER BY |
however, the order the Query Processor on SQL Server processes…
Read More
SQL Server coding and naming conventions and best practices and guidelines
Here is a good blog post on SQL Server coding and naming conventions: Database coding conventions, best practices, programming guidelines Views – 2991
Read More
Using EXISTS for Functions, Stored Procedures and Databases
Here is a segment of code you should add to any T-SQL that is dropping a function or stored procedure to make sure…
Read More
A Simple Overview of a SQL Query
Here are the 4 basic steps all queries go through: 1. Parsing: The query is examined by SQL Server to syntax errors, invalid…
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