The Non-Cluttered Index

My August Christmas Card

• by Pam Mooney

• The Non-Cluttered Index

Do you ever get the Christmas card that features a beautiful picture of a family on the front, and a letter catching you up on their year on the...

2020-08-28 (first published: 2020-08-18)

204 reads

The Length Limitations of LEN()?

• by Pam Mooney

• The Non-Cluttered Index

I was using LEN() to troubleshoot an issue I was having with a dynamically constructed string truncating while inserting into an NVARCHAR(MAX) column.  Since I know that NVARCHAR(MAX) has...

2020-07-22 (first published: 2020-07-14)

716 reads

New Article For Simple Talk!

• by Pam Mooney

• The Non-Cluttered Index

Hi All, While I haven’t been writing here, I have been writing. I have a new article that has just been published on Simple Talk, and I am developing...

2020-04-16

21 reads

Level Up!

• by Pam Mooney

• The Non-Cluttered Index

Great news! I was accepted this weekend to speak at SQLSaturday Los Angeles! This officially counts as a level up for me for my deadlock resolution quest. The event...

2020-02-25

4 reads

My Deadlock Resolution Progress Report

• by Pam Mooney

• The Non-Cluttered Index

As I wrote last month, I went through a period of feeling personally and professionally deadlocked, and flailed about for some time before I found the answer of making...

2021-04-28 (first published: 2020-02-21)

355 reads

How Do You Decide When Can Doesn't Mean Should?

• by Pam Mooney

• The Non-Cluttered Index

An old proverb states, “Fire is a good servant but a bad master.”  Put simply, it means that when controlled, fire is a life-sustaining element.  We need it for...

2020-02-07

2 reads

Discover and Clean Up Schema Ownership

• by Pam Mooney

• The Non-Cluttered Index

My colleagues and I take schema ownership seriously.  The owner (with few exceptions) should always be “dbo”.  Certainly, it should not be a user.  Why?  Because if the user...

2020-02-03

31 reads

When the DBA is Deadlocked

• by Pam Mooney

• The Non-Cluttered Index

When I launched The Noncluttered Index last year, it was with the intention of writing at least twice a week. For a while, that was very doable.  Then, work...

2021-04-23 (first published: 2020-01-14)

550 reads

Dropping Database Users and Logins: How it Can Go So Very Wrong, and How You Can Easily Fix It

• by Pam Mooney

• The Non-Cluttered Index

I don't normally drop users and logins in production, but when I do, and it goes wrong, I do this.

2019-09-20

7 reads

Validating Replication (All or Just One Article)

• by Pam Mooney

• The Non-Cluttered Index

You may sometimes have reports or other processes that are dependent on transactional replication being current.  If that is the case, you will probably need a mechanism to check...

2019-08-09

4 reads