SQL PROMPT

The Sins of SELECT * (BP005)

  • Article

If Prompt warns you of use of the asterisk, or 'star' (*), in SELECT statements, consider replacing it with an explicit column list. It will prevent unnecessary network load and query performance problems, and avoid problems if the column order changes, when inserting into a table.

2019-05-27

Securing Code Early

  • Editorial

Last year I started to get alerts from Microsoft Repos that someone had put a piece of security information in their code that pertained to one of my Azure services. At first I was worried, but then I realized this was the public version of AdventureWorks we maintain in Azure. We've published the login so […]

2019-04-17

138 reads

Blogs

T-SQL Tuesday #129 – Let’s Build a Time Capsule

By

It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting...

T-SQL Tuesday #129 – Let’s Build a Time Capsule

By

It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting...

T-SQL Tuesday #129 – Let’s Build a Time Capsule

By

It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting...

Read the latest Blogs

Forums

Filtering the Dataframe in Python

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Filtering the Dataframe in Python

Desktop or Laptop for Remote Work

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Desktop or Laptop for Remote...

Stairway to DAX and Power BI - Level 14: DAX CALCULATE() Function: The Basics

By Bill Pearson

Comments posted to this topic are about the item Stairway to DAX and Power...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers