Skip to content
Prodata

Prodata

SQL Centre Of Excellence

  • Home
  • Services
    • Synapse and EDW
    • SSAS Services
    • Power BI
    • SQL Server Platform
  • Blogs
  • Offerings
  • About Us
    • History and Verticals
    • Team
    • Contact
    • Jobs at Prodata

Tag: TSQL

SQL Server, TSQL

TSQL Best Practice – Avoid use of DISTINCT

We do a lot of code reviews and the use of SELECT DISTINCT always comes up as its picked up by many of the static code analysis tools as a known scalability and performance risk. The common question is “Why should I avoid distinct” and “How can I avoid it” During a performance review we … Continue reading TSQL Best Practice – Avoid use of DISTINCT

October 29, 2011November 30, 2020Performance, TSQLLeave a comment
SQL Server

TSQL to determine all FK’s in a database

Here is some handy TSQL to determine all the FK relationships in a database. The basic ideas is we can use this meta data to automatically determine if a form should have a Combo Box rendered instead of a textbox. -- List all Foreign key Relationships in User Tables SELECT so.name as ForeignTableName, sc.name as … Continue reading TSQL to determine all FK’s in a database

July 21, 2010November 24, 2020SQL Server, TSQLLeave a comment

Posts navigation

Older posts
  • Facebook
  • Twitter
  • LinkedIn
Prodata
Proudly powered by WordPress Theme: Shoreditch.