A SQLServerCentral DR Event
We had a disaster at SQLServerCentral this past weekend. It wasn’t a big disaster, but it was an event that...
2014-09-23
722 reads
Blog Posts
Parameterization Part 5: Two Common Mistakes
This is the fifth post in my Parameterization series. In previous posts I wrote about parameter sniffing and when it is...
2014-09-23 (first published: 2014-09-20)
8,981 reads
PASS Chapter Leaders - Remember To Talk About Elections With Your Chapters!
Last week before our monthly MagicPASS meeting I went through my usual routine of grabbing the PASS chapter deck and...
2014-09-23
520 reads
SQL Server Query Performance Tuning
The latest update to my book, SQL Server Query Performance Tuning was released last week. This is the fourth edition...
2014-09-23
770 reads
The Magic Alt Button
Lately I have been using more and more the awesomeness of the Alt-button in SQL Server Management Studio (SSMS). What...
2014-09-23
829 reads
Vote for Grant Fritchey
Just a brief note to say that I will be voting for Grant Fritchey for the PASS Board and I...
2014-09-23
1,119 reads
Communication and the Board: #PASSVotes
The whole idea behind PASS is to build a community of people who can assist each other in their daily...
2014-09-22
554 reads
Grant for President
Grant Fritchey is running for the PASS board. He’s not running for President, though I’m not sure why he shouldn’t...
2014-09-22
771 reads
I Am Running For the PASS Board of Directors: #passvotes
This year, I submitted my application to run for the PASS Board and it was accepted. This then is my...
2014-09-22 (first published: 2014-09-17)
6,194 reads
Launching PASSWatch
I’ve wanted to do this for a while, decided to make the time commitment and see what happens. See the...
2014-09-22
546 reads
Blogs
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Stupid Things I Did With AI: ASCII Art
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...
Simple Talks Podcasting in 2026
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
Forums
Learning From Breakage
Comments posted to this topic are about the item Learning From Breakage
Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy
Comments posted to this topic are about the item Python in Action to Auto-Generate...
Adding and Dropping Columns I
Comments posted to this topic are about the item Adding and Dropping Columns I
Question of the Day
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