Best practices

Question

Post reply

Best practices

Sgar...

SSCarpal Tunnel

Points: 4409
More actions
August 10, 2011 at 10:16 pm

#255636

What are the best practices for
SQL Server Performance
Security.
Memory Management.
Maintenance.
Sagar Sonawane
** Every DBA has his day!!:cool:

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004343 More actions · Answer 1

Please try Google. Search for SQL SERVER "BEST PRACTICES".

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ChrisTaylor SSCarpal Tunnel Points: 4527 More actions · Answer 2

Sorry saga but there are books dedicated to the questions you've asked above so therefore far too much information to relay in a forum post.

As Jeff has suggested have a look on google or perhaps amazon and get a book on the topics

_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 3

I'd like to recommend you get a copy of this book. And then a copy of this one. They cover what you're asking.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning