Managing Geeks – A journey of leading by doing
I am proud to share that my good friend Andy Leonard has just released a new book. This is also...
2014-10-29
1,880 reads
Blog Posts
Maximum number of rows per data page and minimal record size (SQL Server storage internals)
Maximale Anzahl Zeilen je Datenseite und minimale Datensatzgröße
(DE)
In einer meiner letzten Master-Classes tauchte die nicht ganz ernste aber dennoch...
2014-10-29
1,429 reads
PASS Summit 2014
Well, it is that time of year again. The Professional Associations for SQL Server (PASS) annual summit. This year we...
2014-10-29
1,249 reads
Playing with the log – Before the first full backup
The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the...
2014-10-29
1,810 reads
Porto.Data
I am extremely excited to share that the first event of Porto.Data is all set for the 20th of November...
2014-10-29
133 reads
Quick Schema Auditing
I was working on a demo recently and needed to show that a little monitoring can help you catch schema...
2014-10-29
1,125 reads
SQL Server 2014 Backup and Recovery
In early October my third book was published. I have been blessed to be able to work with Joes2Pros for my...
2014-10-29
1,876 reads
SQLSaturday Tampa Announced For February 28, 2015
SQLSaturday Tampa is the first SQLSaturday in Florida for 2015, scheduled for February 28th, 2015. The event is held at...
2014-10-29
1,259 reads
Update to “The clustered index columns are in all of the non clustered indexes.”
I certainly hadn’t planned on creating a part two of my post on clustered index columns but in the comments...
2014-10-29 (first published: 2014-10-20)
6,079 reads
Getting back to basics
I committed to studying for MCSA SQL Server 2012 and taking the certification exams by the end of the year…last...
2014-10-28
605 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