SQL PROMPT

External Article

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

SQLServerCentral Editorial

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

150 reads

Blogs

The Effectiveness of Solar Estimation

By

We added a solar system to the ranch as a way to hedge against...

How do I tell if identity_insert is turned on and if so what table?

By

TLDR; The code to do this is below but it’s a bit hokey and...

Daily Coping 24 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Shared Work Spaces: Hell, Heaven, Both?

By Grant Fritchey

Comments posted to this topic are about the item Shared Work Spaces: Hell, Heaven,...

T-SQL : Slicing time Islands and gaps

By MrRobot

Hello, Consider the following table that gives the validity dates of an item :...

Migrate the SSIS Catalog in Just a Few Clicks

By Kunal Rathi

Comments posted to this topic are about the item Migrate the SSIS Catalog in...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers