Click here to Skip to main content
15,903,594 members
Home / Discussions / Database
   

Database

 
AnswerRe: what's the problem with this?! Pin
Mycroft Holmes6-Apr-13 23:09
professionalMycroft Holmes6-Apr-13 23:09 
AnswerRe: what's the problem with this?! Pin
Richard MacCutchan7-Apr-13 1:16
mveRichard MacCutchan7-Apr-13 1:16 
Questioncompare performance between two query Pin
mhd.sbt4-Apr-13 23:30
mhd.sbt4-Apr-13 23:30 
AnswerRe: compare performance between two query Pin
Tim Carmichael5-Apr-13 3:11
Tim Carmichael5-Apr-13 3:11 
AnswerRe: compare performance between two query Pin
PIEBALDconsult5-Apr-13 3:21
mvePIEBALDconsult5-Apr-13 3:21 
SuggestionRe: compare performance between two query Pin
Eddy Vluggen5-Apr-13 7:21
professionalEddy Vluggen5-Apr-13 7:21 
GeneralRe: compare performance between two query Pin
mhd.sbt5-Apr-13 8:44
mhd.sbt5-Apr-13 8:44 
GeneralRe: compare performance between two query Pin
Eddy Vluggen5-Apr-13 8:54
professionalEddy Vluggen5-Apr-13 8:54 
mehdi.sabet wrote:
but how can i do this ,i mean use of sql profiler for compare performance between two query?

It's usually not very helpful to try and find "small" differences like those; there's also some intelligence in the server, and something called an optimizer. If your queries are slow, find out which ones are the mayor culprits. You can simply time them, by whichever means you want. Then, optimize those.

Also periodically check your server for the usual stuff that a DBA would check; are your indexes still good? Does the Wizard from the management studio agree with that? (I believe there's an index-wizard in Sql2008+) Do the procedures fetch unnecessary data (think "select *" when "select cola, bolb" would do), do any of the tables need partitioning? How about caching stuff?
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: compare performance between two query Pin
mhd.sbt5-Apr-13 9:01
mhd.sbt5-Apr-13 9:01 
GeneralRe: compare performance between two query Pin
Eddy Vluggen5-Apr-13 9:04
professionalEddy Vluggen5-Apr-13 9:04 
QuestionJOIN 3 Tables Pin
Richard.Berry1004-Apr-13 19:01
Richard.Berry1004-Apr-13 19:01 
AnswerRe: JOIN 3 Tables Pin
Mycroft Holmes4-Apr-13 20:04
professionalMycroft Holmes4-Apr-13 20:04 
GeneralRe: JOIN 3 Tables Pin
Richard.Berry1005-Apr-13 2:49
Richard.Berry1005-Apr-13 2:49 
GeneralRe: JOIN 3 Tables Pin
Mycroft Holmes5-Apr-13 13:12
professionalMycroft Holmes5-Apr-13 13:12 
GeneralRe: JOIN 3 Tables Pin
Richard.Berry1005-Apr-13 23:41
Richard.Berry1005-Apr-13 23:41 
GeneralRe: JOIN 3 Tables Pin
Mycroft Holmes6-Apr-13 14:14
professionalMycroft Holmes6-Apr-13 14:14 
QuestionSQL QUERY Pin
girijeshkumar3-Apr-13 20:08
girijeshkumar3-Apr-13 20:08 
AnswerRe: SQL QUERY Pin
i.j.russell3-Apr-13 21:36
i.j.russell3-Apr-13 21:36 
GeneralRe: SQL QUERY Pin
girijeshkumar3-Apr-13 23:05
girijeshkumar3-Apr-13 23:05 
GeneralRe: SQL QUERY Pin
i.j.russell4-Apr-13 2:07
i.j.russell4-Apr-13 2:07 
AnswerRe: SQL QUERY Pin
Bernhard Hiller3-Apr-13 21:38
Bernhard Hiller3-Apr-13 21:38 
GeneralRe: SQL QUERY Pin
girijeshkumar3-Apr-13 23:07
girijeshkumar3-Apr-13 23:07 
AnswerRe: SQL QUERY Pin
ritesh.gupta55553-Apr-13 22:28
ritesh.gupta55553-Apr-13 22:28 
GeneralRe: SQL QUERY Pin
girijeshkumar3-Apr-13 22:58
girijeshkumar3-Apr-13 22:58 
GeneralRe: SQL QUERY Pin
ritesh.gupta555525-Jun-13 2:55
ritesh.gupta555525-Jun-13 2:55 

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.