Coding Standards

Quintessential Or Elegant

• by Eric Notheisen

• SQLServerCentral.com

• Coding Standards

• Article

This editorial addresses the need to write the most effective and efficient code for our solutions

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2015-02-02

109 reads

• Discuss

Transact-SQL Formatting Standards

• by Additional Articles

• SimpleTalk

• Coding Standards

• Article

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 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-09

4,890 reads

SQL Code Layout and Beautification

• by Additional Articles

• SimpleTalk

• Naming Standards

• Article

William Brewer takes a look at the whole topic of SQL Code layout and beautification, an important aspect to SQL programming style. He concludes that once you are tired of laying SQL out by hand, you had better choose a tool with plenty of knobs to twiddle, because nobody seems to agree on the best way of doing it.

2008-05-26

6,244 reads

Forum Etiquette: How to post data/code on a forum to get the best help

• by Jeff Moden

• SQLServerCentral.com

• Best Practices

• Article

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.65 (213)

Log in or register to rate

You rated this post out of 5. Change rating

2013-12-10 (first published: 2007-11-27)

189,960 reads

• Discuss

domain admin recorded as dbo

• by William-Akin-201900

• Redgate

• Topic

I am a part of the domain admin on our server that houses our sql dbases.  Any changes I make to a dbase gives a stamp of dbo.  If I am not a part of the domain admin group the name stamp that is used is my login.  How can I be a part of […]

2005-03-23

5 reads

RE: sp with input parameters

• by sahana

• SQLServerCentral.com

• Reply

thanks for ur help

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-06-15

RE: Server Performance

• by Andy Warren

• SimpleTalk

• Reply

Same service packs and hot fixes? Run sp_updatestats? Andy http://qa.sqlservercentral.com/columnists/awarren/

2003-06-24

RE: auto grow

• by jrose

• SimpleTalk

• Reply

Just to verify - Does the Date Time Modified only get updated when an Auto Grow takes place or when the SQL Server Service is stopped/restarted. Thanks.

2003-05-29

1 reads

RE: Is there a difference?

• by mromm

• SQLServerCentral.com

• Reply

It is better to put the most distinct restriction (date in this case) first anyway. You never know what surprises to expect from the optimizer. So why gamble? It become even more important when your queries become more complex, especially with joins. Look at the order here: SELECT ... FROM t1 JOIN t2 ON t1.c1 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-06