SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 

133341 Results Found

ARTICLE

Coding Standards - Part 1

SQL Server Coding Standards - Part 1 Introduction Everyone needs standards. They promote cleaner code, better programming, and make it easier for teams of people to work together. Standards are one of the foundations upon which computer science is built. Coding standards (as I define them) are the standards which specify how the object source code is written. This includes the format, documentation, structure of the object code, etc. Having good coding standards ensures that all object source code looks similar and allows different members ... environments and have seen different types of standards for developing code. These have ranged from free (read ... central document and specific formats for writing code). There have not been too many that I ...

ARTICLE

Coding Standards Part 2 - Formatting

Coding Standards - Part 2 - Formatting SQL This is a continuation of my series on coding standards. If you are interested, you can read ... managing and maintaining a stable environment is the use of standards. In any SQL Server environment, we ... we often work with T-SQL code in our daily work. And as anyone know ...

FORUM

SSIS Standards

I am looking for a standards document for SSIS. Is there one like that somewhere ... one have another source of SSIS Standards. I need to create document that my ...

FORUM

Standard Store procedure look like

... comit and rolback transaction,like any standard strore procedure. Also according to you ... comit and rolback transaction,like any standard strore procedure. Also according to you ... write procedures according to their need and follow these standard rules for any basic table. Take ...

FORUM

Need Standards for BI document

Hi all, I'm creating a standards document for BI including(SSIS,SSAS ... pls help me or suggest any standards to finish completing my document . Regards ...

ARTICLE

Server Hardware Standards

Server Standards - Part 1, Hardware Introduction I ... wrote a little while back about Coding Standards. There were two parts to the series, Naming ... searching for other areas that I've implemented standards, it occurred to me that the server itself is a place ...

FORUM

Coding Standards

... anybody have good pointers/documents on "Coding Standards", "Security" & "Performance Testing". paul No one ...

FORUM

Coding Standards

... doesn't Microsoft use T-SQL coding standards? Whenever I script a system stored proc the code looks like a dogs breakfast. Surely ... Surely MS should be leading by example. [code="sql"]... from sys.partitions p join ... tables it on p.object_id = it.object_id ...[/code] Cheers [quote][b]Artoo22 (3/19/2012 ...

FORUM

Coding Standards

... from the developer for clarificaiton Is this just to be ANSI-Standard or is there also a performance reason?   Use the more readable ANSI-Standard Join clauses instead of the old style ... way everybody gets used to reading and coding the same style. Team code reviews are much easier. My experience ... I use the JOIN syntax of the ANSI-92 standard is in OUTER JOINs. Personally, I don't ...

FORUM

Simple Question

... just want some clarification here. Is this [code] SELECT * FROM dbo.CLMASTER AS Mstr ,dbo.CLCOLLBAL ... CO' AND Parm.CODE = 'PERIOD' AND Parm.COMPANY = 'MAIN' [/code] The [b]SAME[/b] as [code] SELECT * FROM dbo.CLMASTER AS Mstr INNER ... CO' AND Parm.CODE = 'PERIOD' AND Parm.COMPANY = 'MAIN' [/code] They look the same to me. The join between ...