Click here to Skip to main content
15,867,686 members
Home / Discussions / Database
   

Database

 
AnswerRe: Performance Issue Pin
Paul Conrad1-Jul-08 20:03
professionalPaul Conrad1-Jul-08 20:03 
GeneralRe: Performance Issue Pin
sujithkumarsl1-Jul-08 20:24
sujithkumarsl1-Jul-08 20:24 
AnswerRe: Performance Issue Pin
N a v a n e e t h1-Jul-08 20:36
N a v a n e e t h1-Jul-08 20:36 
GeneralRe: Performance Issue Pin
sujithkumarsl1-Jul-08 22:04
sujithkumarsl1-Jul-08 22:04 
GeneralRe: Performance Issue Pin
N a v a n e e t h1-Jul-08 22:51
N a v a n e e t h1-Jul-08 22:51 
GeneralRe: Performance Issue Pin
sujithkumarsl1-Jul-08 23:12
sujithkumarsl1-Jul-08 23:12 
GeneralRe: Performance Issue Pin
TheFM2342-Jul-08 4:37
TheFM2342-Jul-08 4:37 
AnswerRe: Performance Issue Pin
Mycroft Holmes2-Jul-08 21:17
professionalMycroft Holmes2-Jul-08 21:17 
a couple more ideas
Partitioning your data
Striping your tables across multiple disks
And of course index tuning
Then check your queries and the join/where clauses
Hire a DBA to do some performance tuning (if tables have "billions" of rows you need one)



Never underestimate the power of human stupidity
RAH

GeneralRe: Performance Issue Pin
sujithkumarsl3-Jul-08 0:48
sujithkumarsl3-Jul-08 0:48 
QuestionSQL Server Trigger Pin
irusul1-Jul-08 9:48
irusul1-Jul-08 9:48 
AnswerRe: SQL Server Trigger Pin
Giorgi Dalakishvili1-Jul-08 10:14
mentorGiorgi Dalakishvili1-Jul-08 10:14 
AnswerRe: SQL Server Trigger Pin
Mycroft Holmes1-Jul-08 14:06
professionalMycroft Holmes1-Jul-08 14:06 
AnswerRe: SQL Server Trigger Pin
TheFM2342-Jul-08 4:29
TheFM2342-Jul-08 4:29 
GeneralRe: SQL Server Trigger Pin
Mycroft Holmes2-Jul-08 21:22
professionalMycroft Holmes2-Jul-08 21:22 
QuestionStore Procedure Pin
brettokumar1-Jul-08 1:43
professionalbrettokumar1-Jul-08 1:43 
AnswerRe: Store Procedure Pin
SomeGuyThatIsMe1-Jul-08 2:57
SomeGuyThatIsMe1-Jul-08 2:57 
QuestionHelp In Query Pin
Saiyed Alam1-Jul-08 1:06
Saiyed Alam1-Jul-08 1:06 
AnswerRe: Help In Query Pin
SomeGuyThatIsMe1-Jul-08 3:09
SomeGuyThatIsMe1-Jul-08 3:09 
GeneralRe: Help In Query Pin
Saiyed Alam1-Jul-08 5:27
Saiyed Alam1-Jul-08 5:27 
QuestionConnection: login failed - State 16 Pin
DharperII1-Jul-08 0:52
DharperII1-Jul-08 0:52 
QuestionSql server replication (from 2000 to 2005) Pin
acodman30-Jun-08 23:49
acodman30-Jun-08 23:49 
QuestionReporting Services - Controlling number of rows of a table control Pin
Rashmi Deshpande30-Jun-08 23:47
Rashmi Deshpande30-Jun-08 23:47 
Questionsql query Pin
Pankaj Garg30-Jun-08 21:25
Pankaj Garg30-Jun-08 21:25 
AnswerRe: sql query Pin
Giorgi Dalakishvili30-Jun-08 21:27
mentorGiorgi Dalakishvili30-Jun-08 21:27 
GeneralRe: sql query Pin
Pankaj Garg30-Jun-08 21:31
Pankaj Garg30-Jun-08 21:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.