In this short but to the point video Steve explains the question “what is a CTE?” Transcription of this video: CTE is kind of this concept of what we’re calling a virtual table where it’s like a sub query or like a view where it’s referencing another chunk of SQL query that’s going to be used and named. Similar to …
Common table expressions are beneficial to use when writing or managing complex queries. Being condensed or simplified, CTEs increase accessibility and digestion. Watch Steve’s video for more on CTEs…… Transcription of this video: Why would you use common table expressions? I mean, you may have been writing SQL queries for 10 or more years, and have never used a common …
Hooray! It’s CTE month. Some of you may be happy but you others may by like ugh. Common table expressions can be tough and confusing but WE’VE GOT YOU COVERED! This month we will be throwing lots of valuable CTE information and resources at you including….. Instructional videos Tips of the trade And a FREE download! Check in daily to …
Honoring those who have died while serving Mon, 30 May 2022 In observance of the US federal holiday Memorial day, and in memory of all who have died in service, Stedman Solutions, LLC will be closed for the last Monday in May. If you need emergency help during this time, yo Read more… What Does CTE Month Mean for You? …
In observance of the US federal holiday Memorial day, and in memory of all who have died in service, Stedman Solutions, LLC will be closed for the last Monday in May. If you need emergency help during this time, you can reach us through the contact us form, or for existing customers just contact one of us by our cell …
Ok cool Stedman Solutions is having CTE (common table expressions) month in June. What does that mean for you my reader? Well let me share all the goodies I have to offer this month! Next month I will be releasing……. Over 15 CTE videos with topics ranging from a memory table to recursive CTE’s Common table expressions hot tips A …
Today Microsoft released a new update for SQL Server. SQL Server 2016 Azure Connect pack (KB 5014242) 2022-05-19 Here are the latest updates for each version of SQL Server. SQL Server 2019 RTM CU 16Download links: CU 16 (KB 5011644) SQL Server 2017 RTM CU 29Download links: CU 29 (KB 5010786) SQL Server 2016 SP2 CU 17Download links: …
I am looking for feedback on your naming conventions for a couple areas relating to naming convention. As Stedman Solutions consultants we work for several clients in each week, and sometimes any team member may work with more than 15 clients in a month. That gives us a large variety of exposure to different nomenclatures. Some of those conventions are …
Today Microsoft released a new update for SQL Server. SQL Server 2019 CU 16 (KB 5011644) 4/18/2022 (Windows) 5/10/2022 (Big Data Clusters) 5/16/2022(Linux) Here are the latest updates for each version of SQL Server. SQL Server 2019 RTM CU 16Download links: CU 16 (KB 5011644) SQL Server 2017 RTM CU 29Download links: CU 29 (KB 5010786) SQL Server …
One of the services we do a ton of is our Design and Development Service. This involves anything from writing custom TSQL procedures to website integration with the database to custom C# applications that we have created. We at Stedman Solutions work with in types of environments – If you have a new application in the cloud with 500+ TB …