Additional Articles


External Article

Transact-SQL Formatting Standards (Coding Styles)

How should SQL code be formatted? What sort of indentation should you use? Should keywords be in upper case? How should lists be lined up? SQL is one of those languages that will execute anyway however you treat whitespace and capitalization. However, the way SQL is laid out will effect its readability and the time taken to review and understand it. Standardisation of code layout is an important issue, but what standard should you adopt? Rob avoids a direct answer, but tells you the sort of answers you'll need to decide upon when creating a strategy for formatting SQL code.

2009-09-08

4,913 reads

Technical Article

Implementing a SQL Server Fast Track Data Warehouse

This paper defines a reference configuration model (known as SQL Server Fast Track Data Warehouse) and a CPU core-balanced approach to implementing a symmetric multiprocessor (SMP)-based SQL Server data warehouse with proven performance and scalability expectations for sequential I/O data workloads.

You rated this post out of 5. Change rating

2009-09-04

4,268 reads

External Article

Getting rid of SQL Code

Joe becomes intrigued by the way that experts make errors in any area of technology, and suggests that the problem is more that of mindsets than lack of knowledge. He illustrates the point with SQL Development by means of the "Britney Spears, Automobiles and Squids" table, and the tangled Stored procedure, and shows ways of getting rid of both procedural and non-procedural code by adopting a different programming mindset.

2009-09-03

5,983 reads

Technical Article

Parameterized Queries

Previous T-SQL best practices articles have discussed different coding styles that led to slow and fast query executions, and ways to minimize cached plans. This article will be an extension on those concepts, focusing on how the SQL Server optimizer tries to parameterize a query if it can, as well as how you can build your own parameterized query.

(1)

You rated this post out of 5. Change rating

2009-09-03

5,866 reads

Blogs

A New Word: Gnossienne

By

gnossienne– n. the awareness that someone you’ve known for years still has a private...

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

By

How I used AI for this postChatGPT to generate images based on info specifically...

Learning Tool – Deepstash

By

A few months ago I started using Deepstash. Deepstash breaks books into the key...

Read the latest Blogs

Forums

Understanding Temp Tables and Table Variables in SQL Server

By sabyda

Comments posted to this topic are about the item Understanding Temp Tables and Table...

The Data API Builder MCP Server Tools

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Data API Builder MCP...

Collecting Data Is Hard

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Collecting Data Is Hard

Visit the forum

Question of the Day

The Data API Builder MCP Server Tools

The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?

See possible answers