Viewing 15 posts - 1 through 15 (of 62 total)
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...
February 5, 2024 at 5:35 am
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...
December 4, 2023 at 7:57 am
Amen, Louis.
Countless times over the years, I have come across fellow SQL Server professionals who were supremely confident about something, and demonstrably wrong.
October 7, 2023 at 5:21 am
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/
October 3, 2023 at 5:41 am
You could use the Trimmer tool in the free SQLFacts toolkit. It generates SQL code to do as you have requested.
September 27, 2023 at 6:48 pm
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...
June 19, 2023 at 7:49 pm
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...
June 18, 2023 at 4:34 am
we have one procedure that creates a table variable, inserts two rows, then does a query based on that and a bunch of other tables
How many is "a bunch"...
June 1, 2023 at 4:22 am
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...
April 9, 2023 at 1:22 am
There are three text files of documentation (about 100K total), including one titled README that tells what the code is supposed to do.
April 7, 2023 at 4:47 pm
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...
April 7, 2023 at 11:49 am
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...
April 7, 2023 at 11:27 am
There are drawbacks to assembling your own toolbox by gathering tools from different sources. Steve mentioned one, maintaining the tools over time. There's also the inevitable inconsistency from one tool...
October 7, 2022 at 11:22 pm
The missing index suggestions are not connected to specific queries in versions prior to SQL Server 2019. SQL Server 2019 added the sys.dm_db_missing_index_group_stats_query DMV. This DMV tells you...
July 12, 2022 at 7:42 pm
Viewing 15 posts - 1 through 15 (of 62 total)