Viewing 15 posts - 271 through 285 (of 321 total)
[opinion]
One final note, and it applies to all reading this or any thread. It seems strange to me that you would read the subject and then post to that thread...
March 5, 2008 at 5:07 pm
dean gross (3/5/2008)
SSW has recommendations posted at http://www.ssw.com.au/ssw/Standards/DeveloperSQLServer/SQLServerStandard_3_StoredProcedureFormatting.aspx . They also have lots of guidelines on other topics associated with programming
...and hopefully, nobody reads the post at that...
March 5, 2008 at 10:51 am
Right you are, Jeff.
I haven't heard an argument yet that would convince me to give up the much more aesthetically pleasing comma last scripting.:cool:
March 4, 2008 at 10:54 am
CAGreensfelder (3/4/2008)
March 4, 2008 at 9:07 am
dean gross (3/4/2008)
March 4, 2008 at 8:46 am
CAGreensfelder (3/3/2008)
March 3, 2008 at 9:49 am
I have to agree with fuller.artful and Nathan Allan - both have good standards. I too am a sole coder at the moment but it's still very nice to have...
March 2, 2008 at 9:28 am
Robert,
I wasn't trying to present a specific application, but rather a part of the approach to DB design that I use.
When I or another programmer sees something like Fields("CM_Name") in...
March 1, 2008 at 12:54 pm
Tom,
Just curious... Are you saying that "CM" is the abbreviation for "Customers" and that "CA" is the abbreviation for {customer}"Addresses"?
--Jeff Moden
Sorry Jeff. I forgot to mention it. CM...
March 1, 2008 at 12:38 pm
Be careful what you wish for! or so they say. To me it's a matter of who makes the rules. I wouldn't want to force my GREAT structuring on anyone...
March 1, 2008 at 9:46 am
The attached script is Microsoft's. Run it against the old server. It will output new script to add the logins to the new server. Copy and paste, or output it...
February 27, 2008 at 11:14 am
And if you need indexing, combine the 2 by explicity creating the temp table and indexes, and using INSERT INTO rather than SELECT INTO. This is my preferred method even...
February 27, 2008 at 10:24 am
Seldom mentioned, but keep your seek times to a minimum by NOT grossly oversizing your hard drives. Keep your costs down as well. If you can feel comfortable with a...
February 26, 2008 at 10:55 am
What I DON'T like.
Let me preface my comment by mentioning that I live out in the boonies, and expect that DSL is a distant future for me here. Never the...
February 26, 2008 at 10:19 am
I can't figure why any company would want to be able to get by without needing a DBA. They might eliminate the person with that title, but it isn't possible...
February 19, 2008 at 7:45 am
Viewing 15 posts - 271 through 285 (of 321 total)