Posts filed under: sql server
Avoiding deployment grief from database drift
*Movie guy voice* In a world where applications are developed and shipped to multiple customers. One company effectively saves money and has happier customers by understanding database drift. I was......
Starting with T-SQL for SQL Server
I was recently having a conversation with someone and they asked me what some good resources were to begin writing SQL. So I thought it would be a good idea......
Lessons Learned: Standard Dashboard Episode 1
Where I currently work many process improvement projects end up requiring some sort of software deliverable be created and left behind to aid in the sustainment of the process improvement......
Quickly Defining a Table Structure From a Query
I recently saw a comment that described getting data into a temp table using SELECT <Columns> INTO <Table>. The main reason this was done was just for convenience and to......
T-Shirt Series: The Temporary Line
Throughout the T-Shirt series we have discussed Temp Tables, Table Variables, Derived Tables, and Common Table Expressions (CTE). In this post I will summarize high level differences under normal circumstances.......
T-Shirt Series: The CTE (Common Table Expressions)
I have been asked what is the difference between Temp Tables, Table Variables, CTEs, and Derived tables. So I thought I would take this opportunity to do a short blog post......
Generate XSD from Sql query using FOR XML
Transitioning from site specific prototypes to more standardized products for delivery to multiple customer sites has been a driving factor for separating custom source system translations from the product itself.......
T-Shirt Series: Derived tables
I have been asked what is the difference between Temp Tables, Table Variables, CTEs, and Derived tables. So I thought I would take this opportunity to do a short blog......
T-Shirt Series: The Misunderstood Table Variable
I have been asked what is the difference between Temp Tables, Table Variables, CTEs, and Derived tables. So I thought I would take this opportunity to do a short blog post......
Incorrect SQL71558 error when joining synonyms in SSDT
I recently ran into an issue where the SSDT compiler in Visual Studio was misreporting an error and I wanted to post about the setup and work-around. SSDT, also known......