René's URL Explorer Experiment


Title: GitHub - red-gate/SQL-code-smells

Open Graph Title: GitHub - red-gate/SQL-code-smells

X Title: GitHub - red-gate/SQL-code-smells

Description: Contribute to red-gate/SQL-code-smells development by creating an account on GitHub.

Open Graph Description: Contribute to red-gate/SQL-code-smells development by creating an account on GitHub.

X Description: Contribute to red-gate/SQL-code-smells development by creating an account on GitHub.

Opengraph URL: https://github.com/red-gate/SQL-code-smells

X: @github

direct link

Domain: patch-diff.githubusercontent.com

route-pattern/:user_id/:repository
route-controllerfiles
route-actiondisambiguate
fetch-noncev2:3f3ab67a-3a83-a249-1fac-56aadfe59fb4
current-catalog-service-hashf3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-idB0AE:2EB8B3:888B57:BDE424:696F2835
html-safe-nonce9dc398b7771863ec74a8425851fd23188ebef1ca333c98d7c2af096239742512
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCMEFFOjJFQjhCMzo4ODhCNTc6QkRFNDI0OjY5NkYyODM1IiwidmlzaXRvcl9pZCI6IjM0Nzc2NTc0NjI1NDQyMTQwNjkiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmace25dda282dd52f44fb238047a0ecb4a66034ab689f4e519d11a25b0f0dc181f7
hovercard-subject-tagrepository:24464973
github-keyboard-shortcutsrepository,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location//
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/red-gate/SQL-code-smells
twitter:imagehttps://opengraph.githubassets.com/4ed6547cf7320ad84f28ccc5348cb6488ee7c50f74c279c54b88d74bf4ce54a3/red-gate/SQL-code-smells
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/4ed6547cf7320ad84f28ccc5348cb6488ee7c50f74c279c54b88d74bf4ce54a3/red-gate/SQL-code-smells
og:image:altContribute to red-gate/SQL-code-smells development by creating an account on GitHub.
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
Noneb278ad162d35332b6de714dfb005de04386c4d92df6475522bef910f491a35ee
turbo-cache-controlno-preview
go-importgithub.com/red-gate/SQL-code-smells git https://github.com/red-gate/SQL-code-smells.git
octolytics-dimension-user_id731505
octolytics-dimension-user_loginred-gate
octolytics-dimension-repository_id24464973
octolytics-dimension-repository_nwored-gate/SQL-code-smells
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id24464973
octolytics-dimension-repository_network_root_nwored-gate/SQL-code-smells
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release39aed5006635ab6f45e6b77d23e73b08a00272a3
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells#start-of-content
https://patch-diff.githubusercontent.com/
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fred-gate%2FSQL-code-smells
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fred-gate%2FSQL-code-smells
Sign up https://patch-diff.githubusercontent.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E&source=header-repo&source_repo=red-gate%2FSQL-code-smells
Reloadhttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells
Reloadhttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells
Reloadhttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells
red-gate https://patch-diff.githubusercontent.com/red-gate
SQL-code-smellshttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2Fred-gate%2FSQL-code-smells
Fork 13 https://patch-diff.githubusercontent.com/login?return_to=%2Fred-gate%2FSQL-code-smells
Star 56 https://patch-diff.githubusercontent.com/login?return_to=%2Fred-gate%2FSQL-code-smells
View license https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/blob/master/LICENSE.md
56 stars https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/stargazers
13 forks https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/forks
Branches https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/branches
Tags https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/tags
Activity https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/activity
Star https://patch-diff.githubusercontent.com/login?return_to=%2Fred-gate%2FSQL-code-smells
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2Fred-gate%2FSQL-code-smells
Code https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells
Issues 5 https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/issues
Pull requests 0 https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/pulls
Actions https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/actions
Wiki https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/wiki
Security Uh oh! There was an error while loading. Please reload this page. https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/security
Please reload this pagehttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells
Insights https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/pulse
Code https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells
Issues https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/issues
Pull requests https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/pulls
Actions https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/actions
Wiki https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/wiki
Security https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/security
Insights https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/pulse
Brancheshttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/branches
Tagshttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/tags
https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/branches
https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/tags
28 Commitshttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/commits/master/
https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/commits/master/
.gitignorehttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/blob/master/.gitignore
.gitignorehttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/blob/master/.gitignore
CONTRIBUTE.mdhttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/blob/master/CONTRIBUTE.md
CONTRIBUTE.mdhttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/blob/master/CONTRIBUTE.md
LICENSE.mdhttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/blob/master/LICENSE.md
LICENSE.mdhttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/blob/master/LICENSE.md
README.mdhttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/blob/master/README.md
README.mdhttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/blob/master/README.md
READMEhttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells
Licensehttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells
https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells#sql-code-smells
Introductionhttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells#intro
Problems_With_Database_Designhttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells#design
Problems_with_Table_Designhttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells#tabledesign
Problems_with_Data_Typeshttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells#datatypes
Problems_with_Expressionshttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells#expressions
Difficulties_with_Query_Syntaxhttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells#syntax
Problems_with_Naminghttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells#naming
Problems_with_Routineshttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells#routines
Security_Loopholeshttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells#loopholes
Acknowledgementshttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells#people
Add more smellshttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells#add
Once And Only Oncehttp://www.c2.com/cgi/wiki?OnceAndOnlyOnce
www.C2.comhttp://www.C2.com
Exploring Smelly Codehttps://www.simple-talk.com/dotnet/.net-framework/exploring-smelly-code/
Code Deodorants for Code Smellshttps://www.simple-talk.com/dotnet/.net-framework/code-deodorants-for-code-smells/
Ten Common SQL Programming Mistakeshttps://www.simple-talk.com/sql/t-sql-programming/ten-common-sql-programming-mistakes/
Jonathan ‘Peli’ de Halleux’shttps://www.simple-talk.com/opinion/geek-of-the-week/peli-de-halleux-geek-of-the-week/
http://msdn.microsoft.com/en-us/library/dd193263(v=vs.100).aspxhttp://msdn.microsoft.com/en-us/library/dd193263(v=vs.100).aspx
SR0014: Data loss might occur when casting from {Type1} to {Type2}http://msdn.microsoft.com/en-us/library/dd193269(v=vs.100).aspx
See: SR0008: Consider using SCOPE_IDENTITY instead of @@IDENTITYhttp://msdn.microsoft.com/en-us/library/dd172121(v=vs.100).aspx
SR0001: Avoid SELECT * in a batch, stored procedures, views, and table-valued functionshttp://msdn.microsoft.com/en-us/library/dd193296(v=vs.100).aspx
SR0010: Avoid using deprecated syntax when you join tables or viewshttp://msdn.microsoft.com/en-us/library/dd172122(v=vs.100).aspx
SR0007: Use ISNULL(column, default_value) on nullable columns in expressionshttp://msdn.microsoft.com/en-us/library/dd193267(v=vs.100).aspx
SR0004: Avoid using columns that do not have indexes as test expressions in IN predicateshttp://msdn.microsoft.com/en-us/library/dd193249(v=vs.100).aspx
See: SR0005: Avoid using patterns that start with “%” in LIKE predicateshttp://msdn.microsoft.com/en-us/library/dd193273(v=vs.100).aspx
SR0006: Move a column reference to one side of a comparison operator to use a column indexhttp://msdn.microsoft.com/en-us/library/dd193264(v=vs.100).aspx
SR0015: Extract deterministic function calls from WHERE predicateshttp://msdn.microsoft.com/en-us/library/dd193285(v=vs.100).aspx
http://msdn.microsoft.com/en-us/library/dd193421(v=vs.100).aspxhttp://msdn.microsoft.com/en-us/library/dd193421(v=vs.100).aspx
http://msdn.microsoft.com/en-us/library/dd172134(v=vs.100).aspxhttp://msdn.microsoft.com/en-us/library/dd172134(v=vs.100).aspx
SR0011: Avoid using special characters in object nameshttp://msdn.microsoft.com/en-us/library/dd172134(v=vs.100).aspx
http://msdn.microsoft.com/en-us/library/dd172136(v=vs.100).aspxhttp://msdn.microsoft.com/en-us/library/dd172136(v=vs.100).aspx
Readme https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells#readme-ov-file
View license https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells#License-1-ov-file
Please reload this pagehttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells
Activityhttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/activity
Custom propertieshttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/custom-properties
56 starshttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/stargazers
50 watchinghttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/watchers
13 forkshttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/forks
Report repository https://patch-diff.githubusercontent.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2Fred-gate%2FSQL-code-smells&report=red-gate+%28user%29
Releaseshttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/releases
Packages 0https://patch-diff.githubusercontent.com/orgs/red-gate/packages?repo_name=SQL-code-smells
Contributors 3https://patch-diff.githubusercontent.com/red-gate/SQL-code-smells/graphs/contributors
Please reload this pagehttps://patch-diff.githubusercontent.com/red-gate/SQL-code-smells
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.