Solved

SQL Server performance tips

Posted on 2009-05-07
14
411 Views
Last Modified: 2012-05-06
Hello friends need some SQL Server Performance tips and optimizing databases. please send me something apart from Microsoft. since i have seen those.


thanx
0
Comment
Question by:aatishpatel
  • 5
  • 2
  • 2
  • +3
14 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 100 total points
ID: 24325478
what kind?

here a (non-sorted) list of items to consider when speaking of "performance" of a "database"
 
* windows server settings
* sql server setting
* networking settings
* file system layout
* database file layout
* backup implementation
* table design
* indexing
* query /t-sql writing
* application layout
* ...
0
 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 100 total points
ID: 24325492
0
 
LVL 42

Assisted Solution

by:EugeneZ
EugeneZ earned 100 total points
ID: 24325525
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 31

Assisted Solution

by:RiteshShah
RiteshShah earned 100 total points
ID: 24325553
0
 
LVL 46

Assisted Solution

by:tbsgadi
tbsgadi earned 100 total points
ID: 24325829
0
 

Author Comment

by:aatishpatel
ID: 24328237
thankyou all
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24329436
I think he closed it by mistake
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 24329900
who knows :)
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24332666
I guess, he doesn't know how to close, in his very first question, I gave him answer and he gave point to the person who posted just simple comment at the end, not even technical. ;)  I told him to re-award the point but didn't do anything so far.
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24333382
Hello WhackAMod / any one here,

Can you guide me, I have strong objection regarding points distribution with one question of same author at http://www.experts-exchange.com/Database/MS-SQL-Server/SQL-Server-2005/Q_24367743.html 

?????

how can I resolve it?

0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24333388
Sorry, I am new to EE so don't know about objection and that kind of stuff, if I did anything wrong, forgive me.
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24333427
Thank you very much.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server 2012 r2 - Make Temp Table Query Faster 5 44
Passing Parameter to Stored Procedure 4 24
Sql Query 6 67
divide by zero error 23 16
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question