Controlling how SQL Prompt Formats your Code: The Knobs and Dials
Phil Factor explores and discusses the current state of the art in SQL Formatting, as done automatically by SQL Prompt.
2019-12-20
Coding Style
SQL Server Name Convention and T-SQL Programming Style
There are only two hard things in Computer Science: cache invalidation and naming things -- Phil Karlton The recommendations in this article are not the ultimate truth. Please consider this article as a rule template that you can adapt to your needs. A naming convention is a set of rules for choosing the character sequence to […]
2019-12-10
8,271 reads
Balancing Performance and Readability
Developers need to consider not only system performance when writing code, but also how readability impacts code maintenance.
2018-03-20
899 reads
Blogs
T-SQL Tuesday #129 – Let’s Build a Time Capsule
It is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting...
Daily Coping 11 Aug 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Why a 60GB Database Backup Grew to 1TB in Size
By gbargsley
Recently, I was alerted to a network file share that was running low on...
Forums
multiplied columns from Oracle linked server
Wasn't sure exactly where to put this one... We populate an Oracle data...
Job that runs slow how to use more CPU
We have a web application job that runs from web calling to update database...
Ask SSC