2014-11-11
490 reads
Blog Posts
Tracking Progress of SQL Server Index Builds and Rebuilds
Let’s say you build or rebuild an index in SQL Server. Your users and boss are anxious to know when...
2014-11-11 (first published: 2014-11-06)
8,366 reads
T-SQL Tuesday #60 – Something New Learned
It’s been five years, and that’s amazing. Not many things last for a year, much less five, but the T-SQL...
2014-11-11
908 reads
T-SQL Tuesday #60 Something New Learned
So, here it is. I put the challenge out to discuss something new learned last week. I was fortunate enough...
2014-11-11
604 reads
TSQL Tuesday #60: Something Learned This Way Comes
It is once again time to come together as a community and talk about a common theme. This monthly gathering...
2014-11-11
580 reads
TSQL Tuesday #60: Something Learned This Way Comes
It is once again time to come together as a community and talk about a common theme. This monthly gathering of the community has just reached it’s 5th anniversary....
2014-11-11
2 reads
TSQL Tuesday #60: Something New Learned – What permissions does have?
What have I learned recently? Well as it happens I learned something rather interesting recently and was actually trying to...
2014-11-11
1,663 reads
Using Bookmarks in SQL Server Management Studio
In SQL Server one way we optimize code is by adding indexes. Indexes help queries by essentially letting the engine...
2014-11-11 (first published: 2014-11-06)
7,413 reads
#SQLPASS #Summit14 Day 2 Keynote Highlights !
This was one of those days I was waiting to happen. You might be wondering whats special? Yes, this day...
2014-11-10
851 reads
Add Witness to Existing SQL Server Database Mirroring
1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.
2....
2014-11-10
3,998 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
MBOX Email Conversion for Backup: Which Format Is Best?
I have several important email accounts stored in MBOX format from clients like Thunderbird...
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