Marty

Interests: Playing Guitar, Music Theory

Website: http://martincatherall.com/

CREATE DATABASE – I’ve not seen that before.

by Marty

measure twice, cut once.

TweetG’day,
It’s been a while
I thought that I’d make a quick blog post about an incident that I encountered today...

2017-01-22

1,001 reads

What’s happening in Asia Pacific?

by Marty

measure twice, cut once.

TweetG’day,
I really am going to make an effort to blog more, and this post is really the start of that.

I...

2015-09-30

1,189 reads

TSQL Tuesday #68 – backup checksum default

by Marty

measure twice, cut once.

Tweet
G’Day,
Well it seems like TSQL Tuesday #68 is providing me with a real good reason to get back into my...

2015-07-07

1,379 reads

More Azure SQL Database Enhancements – Meet RLS (cloud first debut)

by Marty

measure twice, cut once.

TweetG’day,
Well, it was only a few days ago that I blogged about some major Azure SQL Database enhancements. Primarily, in...

2015-01-30

2,318 reads

2014 – A year in review.

by Marty

measure twice, cut once.

TweetG’day,
And so another year passes, and as I’ve never wrote a “year in review” post before now seems like a...

2014-12-31

1,345 reads

I’ve joined the SQL SERVER MVP community – Thank you!

by Marty

measure twice, cut once.

TweetG’Day,
Today I awoke to find an email from Microsoft informing me that I’d been awarded an MVP. Wow.
I had to...

2014-10-01

1,099 reads

A real life table variable performance problem.

by Marty

measure twice, cut once.

TweetG’day,
I’m sure we’ve all heard and read about the differences between table variables and temporary tables. In case you haven’t...

2014-09-30

2,108 reads

SQL Saturday #316, MVP’s, MCMs and a baby.

by Marty

measure twice, cut once.

TweetG’Day,
Saturday June 14th 2014 seen the Christchurch, New Zealand SQL SERVER user group host its second SQL Saturday (#316).
We learnt...

2014-06-27

1,403 reads

Import export wizard at the commandline

by Marty

measure twice, cut once.

TweetG’day,
Well, it seems like even if you’ve worked with SQL SERVER for a while, you’re always lightly to learn something...

2014-05-12

1,817 reads

Two IDs, One database and a Magic Number (and maybe even an empty string)

by Marty

measure twice, cut once.

TweetG’day,
I noticed something odd recently when looking at sys.dm_exec_requests. Specifically the system processes listed in that DMV – well at least...

2014-03-26

1,344 reads

Blogs

Who’s the Winningest Coach (with AI Help)

I was listening to the radio the other day and the hosts were discussing...

Learning from Mistakes: T-SQL Tuesday #194

We’re a week late, once again my fault. I was still coming out of...

Stupid Things I Did With AI: ASCII Art

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...

Read the latest Blogs

Forums

Learning From Breakage

By Steve Jones - SSC Editor

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

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding and Dropping Columns I

Visit the forum

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]
GO

I decide to add two new columns for the StateProvince and Country. What code should I use?

See possible answers