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
24,679 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
1,290 reads
Blogs
PASS Summit on Tour in New York City
By Steve Jones
The PASS Summit goes on tour this year, with an August stop in New...
SQL Server Errorlog: Not Just for Errors!
By Kevin3NF
A Goldmine of Clues You Might Be Ignoring SQL Server’s Error Logs often get...
Ethics, Productivity, Age and AI:How do these correlate with Developers’ Stances Towards AI at work, 2024
AI is deemed to be the new superpower. Adoption of AI in various capacities...
Forums
Is Auto Update Statistics recommended in case of bulk insert
Hi, we are working on low latency OLTP system. About 100000 rows per second...
Filling Big Shoes
Comments posted to this topic are about the item Filling Big Shoes
Adding More Data To Sample Databases
Comments posted to this topic are about the item Adding More Data To Sample...
Question of the Day
Adding More Data To Sample Databases
I have installed the WideWorldImporters database from Microsoft on my SQL Server 2022 system. There is some data included, but it's all from before 2013. How can I more quickly add more random data to my sample database?
See possible answers