The 'Structured' part of SQL denotes the fact that queries can be nested inside each other in such a way that, wherever you can use a table, you can use a table expression. Such derived tables can provide powerful magic, to which is added CTEs and Lateral Tables.
SQL Server MVP Steve Jones will be hosting a free seminar in San Jose on Friday March 7 2014. Join fellow database professionals to learn best practices and practical tips for SQL Server version control, continuous integration and deployment.
We've made a change to the forums at SQLServerCentral. Learn how you can mark a post as an answer to your question and help others.
We've all been there, trying to improve performance in a panic situation and not making things better.
Not long ago, a crack team of SQL Server experts was flamed for a crime against database normalization they didn't commit. Today, Joe Deebeeay had a problem, no one else could help, so he found these exiled experts. Together Joe and the DBA-Team get to the bottom of high disk I/O.
In this piece, Josh follows up on his earlier article about smoothing DBA/Developer interactions, this time from the side of the developers.
Today we have a guest editorial from Andy Warren. He talks about strange questions in interviews and whether they help you assess the candidate.
There are several networking issues that can prevent the user from reaching or connecting to the SQL Server database. Learn how to test your SQL Server connectivity with PowerShell.
What are your options for sending a variable number of choices in a parameter to a stored procedure? Alex Grinberg looks at three techniques you can use.
Steve Jones likes the Cloud and gives a few reasons why. He also thinks we'll see more data in the cloud over time.
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Comments posted to this topic are about the item Learning From Breakage
Comments posted to this topic are about the item Python in Action to Auto-Generate...
Comments posted to this topic are about the item Adding and Dropping Columns I
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GOI decide to add two new columns for the StateProvince and Country. What code should I use? See possible answers