Thank you very much for this. I have changed a few bits for SQL Server 2019:

-- idea from https://www.sqlservercentral.com/scripts/estimate-compression-for-all-tables-and-indexes-with-both-row-and-page
-- but only one row per index, status msg,...

If you look at http://sommarskog.se/grantperm.html, you'll find a stored procedure (GrantPermsToSP) to automate much of this.

hi Frederico,

<<I was just pointing out that you can indeed change the user database collation

Yes, Agree. Sorry, English is not my first language.

Best regards, Henrik

Hi Frederico Fonseca,

Yes, that might change the collation of my database, but not that of TEMPDB. So any query using a #temp table would need to be checked (and possibly...

hi Solomon,

I'm using Azure SQL Database, and it's default collation is SQL_Latin1_General_CP1_CI_AS. It is not possible to choose another collation for the database. That also goes for TempDB, and hence...

• This reply was modified 4 years, 8 months ago by  Henrik Staun Poulsen.

Hi Solomon,

Your solution does also find those FirstNames that does not really have a lowercase version, i.e. where FirstName starts with a digit or a dash or a dot...

I would...

• This reply was modified 4 years, 8 months ago by  Henrik Staun Poulsen.

hi Steve,

Thank you very much for showing how to access sys.sql_logins. I was not aware of the needed role.

May I suggest a naming convention? (Yes, I know, it depends on...

SQL Server 2008 R2 is going out of support, and we're moving the last database to Azure SQL DB today, so it doesn't really matter, but here goes:

Your function works when...

hi Jeff,

That is going to be useful, at least for me. But I could not get it to work on SQL Server 2008 R2 (not that it is relevant for...

I noticed it was a bit slow, and had a quick look.

Here is a version that is faster, if you have a lot of spaces.

--USE master
GO
BEGIN TRY
...

Hi Ben,

When I see code that hard-code a database name, I shudder. It must be really old code, because today I prefer to create an abstraction layer, ie....

hi,

Thank you very much for your reply. Not massively expensive, so it might be an attractive solution for my manager.

Best regards
Henrik

Thank you very much for this article.
Would it be possible for you to post a general ball-park estimate of the costs ?

Just something like  x$ per database...

Steve,

I'm perfectly happy about the enhancement that we got with

DROP TABLE IF EXISTS myTable

CREATE TABLE myTable(...)

This ensures that the table is dropped, so that my Create table works.

I mostly use...