Chapter 3 from Murach’s SQL Server 2008 for Developers shows you how to retrieve data from a database table. In the process, you’ll master the basic skills that you’ll use in coding almost any SELECT statement, no matter how complex. At that point, you’ll be ready to learn how to code joins, summary queries, subqueries, and action queries, and then move on to working with server-side features like cursors and stored procedures.
Steve Jones reminisces a bit and comments on reaching one million members in the community.
Steve Jones reminisces a bit and comments on reaching one million members in the community.
Steve Jones reminisces a bit and comments on reaching one million members in the community.
You can use SQL to connect or "mash-up" hierarchical structures, joining them at or below the root to create larger queryable hierarchical structures.
This topic is nothing new, but well worth revisiting for those who have not used CROSS JOINS. You may have faced a problem where you need to compare historical records for a particular set of records to ensure that records have been saved in the correct order.
Lynn Pettis gives us a look at a new way to solve a T-SQL problem.
With the start of a new year, Steve Jones gets back to the car updates with a look at winter driving and changes in the car industry.
It can be helpful in ETL operations to know what the distribution of your data is. Brian Knight shows how to use the Data Profiling task in this video.
I have found that I like to generate a script once and roll it out to multiple servers at the same time. SQL Server 2008 Management Studio makes that fairly easy by allowing one window to connect to multiple instances simultaneously
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Comments posted to this topic are about the item Absolute and Relative References
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Comments posted to this topic are about the item Reserved Words I