Reblog: October 24 to October 30
Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...
2014-10-31
979 reads
Blog Posts
2014-10-31
3 reads
2014-10-31
2 reads
2014-10-31
1 reads
2014-10-31
5 reads
Speaking on Standardize SQL Server Implementations (Dev to Prod)
In this session Prakash will walk through the process he has implemented to alleviates many of the pain points for...
2014-10-31
1,111 reads
Summit and something new…
Let me just say, I’m excited.
First of all, can you believe that the PASS Summit is next week? Next. Week.
Are...
2014-10-31
887 reads
Tales from the Query Processor III
https://www.flickr.com/photos/socal_jim/2070088596/Hello Dear Reader! It’s that time of year again. The leaves are turning, temperatures are changing, and Halloween is once...
2014-10-31
1,179 reads
Writing Fair and Useful Editorial Reviews Is Hard Work
One of my original goals was to be more reporter than editorial writer, but I’ve found that the editorial part...
2014-10-31 (first published: 2014-10-23)
5,635 reads
Add Database File on Database invloved in DB Mirroring
Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file...
2014-10-30 (first published: 2014-10-20)
7,120 reads
Blogs
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...
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...
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