Natural Born Killers (The series) – Day 4 Indices
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-20
1,037 reads
Richard Douglas
Natural Born Killers (The series) – Day 3 Scalar UDF’s
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-19
909 reads
Natural Born Killers (The series) – Day 2 Table Design
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-21 (first published: 2013-06-18)
2,898 reads
Natural Born Killers (The series) – Day 1 Statistics
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-20 (first published: 2013-06-17)
3,408 reads
Natural Born Killers (The series)
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-17
705 reads
Improving performance by using SET STATISTICS IO
When I started using SQL Server the company I was working for at the time had no skill in this...
2013-06-14
2,854 reads
Maidenhead SQL Server User Group 11th June with Chris Webb and David Morrison
Tonight I am organising a User Group at Maidenhead in the UK which marks the start of a huge month of SQL...
2013-06-11
678 reads
An interview with Alex Whittles Chairman of SQLRelay 2013
Some of you may recall in January I ran a series of interviews entitled “New Year Aspirations”. This interview was...
2013-06-05
865 reads
SQL Server Events in the UK – June 2013
Oh my god, there are so many events happening this month it is crazy. I’m going to break with tradition...
2013-06-03
695 reads
Microsoft announce SQL Server 2014
As the world is going green, Microsoft announced today that it is going “Blue”. Confused? I’ll explain all in a...
2013-06-03
1,261 reads
Blogs
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Who’s the Winningest Coach (with AI Help)
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
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...
Forums
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Basic Always On Groups Randomly Stop Synchronizing
In one of my environments I have 3 pairs of Always On SQL 2022...
Learning From Breakage
Comments posted to this topic are about the item Learning From Breakage
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