One other thing about startups:

In many established (large) companies, it often does not matter how good you are or how bad you are. It seems to matter more how visible...

All the drawbacks previously mentioned about startups are valid concerns. The drawbacks must be given serious consideration, especially if you have a family depending on your income and your time.

The...

The SQLFacts tool (one of 44 tools), found in the free SQLFacts toolkit (http://www.SQLFacts.com), returns many result sets that evaluate data types. The most relevant result set would be...

The cautionary notes in the editorial (and linked articles) are warranted. However, missing index suggestions also include additional information (other than column names) that mitigates some of the concerns.

The free...

Amen, Louis.

Countless times over the years, I have come across fellow SQL Server professionals who were supremely confident about something, and demonstrably wrong.

The best value for CTFP is not a matter of how modern/capable your server might be. It's about your workload.

//www.linkedin.com/pulse/ctfp-myth-versus-method-brian-walker/

You could use the Trimmer tool in the free SQLFacts toolkit. It generates SQL code to do as you have requested.

I have an issue with the license:

The SQLFacts suite of tools may not be distributed outside your immediate organization, in whole, in part, or in any form, without explicit...

Thanks to all for the comments!

I agree that a person must be their own best advocate. However, pretending that's enough is foolish. All the other tools mentioned in my guest...

How many is "a bunch"...

A new version of SQLFacts has been released.

Many tools were adjusted to address a potential issue with collations other than default US, as mentioned by eliassal (see above).

THANKS!  --  to...

There are three text files of documentation (about 100K total), including one titled README that tells what the code is supposed to do.

What does this query (executed in the context of the database in question) say about collations?...

SELECT SERVERPROPERTY('Collation'), DATABASEPROPERTYEX(DB_NAME(), 'Collation')

There are other tools in the suite that look for mismatches in...

I have heard of the problem before, when there's a difference in collation between the instance and the database. I think you are saying the instance and the database are...

• This reply was modified 1 year, 9 months ago by  Wingenious.

The scariest data type?...

BOOlean