All Tags
Tagged “sql”
-
Removing Duplicates Using CTE
A brief description of using CTEs to remove duplicates from a table. -
SQL Merge
Description and example of using MERGE statement in SQL -
Intro to Redgate Data Compare
A brief introduction to using redgate data compare -
Redgate Snippets
An overview of how to create custom Redgate Snippets -
SQL Database Querying
An overview of how to connect and write queries against a database. -
Exploring Queries with Optional Parameters
What is the perf impact of including every column as an optional parameter in your query and how to best address it -
Make your queries SARGable
What are SARGable queries, how to write them, and how do them impact performance -
How to make your Database slow with indexes
Index are an equally great way to eek out performance and also tank it. Figure out to the difference here -
How does RAISERROR work?
What does RAISERROR(50001, 16, 1, 'dbo.GetPerson', 'PersonId') do and what do all those magic numbers mean? -
Difference between Table Variable, Temp Table, Table Type, and Common Table Expression
A summary of the different syntaxes available for storing tabular data in SQL Server and some advice on when to use each -
How to Install the AdventureWorks Database
How to create shareable demos and isolated test cases with sample data from Microsoft's AdventureWorks database