Is there any separate certification on Performance Tuning for SQL Server 2000. Also please lemme know the exams available for SQL Server 2000. Thanks, Ram "It is easy to write code for a spec and walk in water, provided, both are freezed..."
On SQL 2000 70028 http://www.microsoft.com/learning/exams/70-028.asp] covers bits & pieces of Performance topic. I believe there is no dedicated certification on this topic. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
As far I know, no. Luis Martin Moderator SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason. Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte All postings are provided “AS IS†with no warranties for accuracy.
Looks like an exam for DBAs. quote:Originally posted by satya On SQL 2000 70028 http://www.microsoft.com/learning/exams/70-028.asp] covers bits & pieces of Performance topic. I believe there is no dedicated certification on this topic. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided “AS IS†with no rights for the sake of knowledge sharing. Thanks, Ram "It is easy to write code for a spec and walk in water, provided, both are freezed..."
As long as there so many people lacking the basic knowledge, a Performance Tuning cert would be overkill. Apart from this, Performance Tuning can hardly be generalised. Pretty much of it depends on a specific environment. -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Heute schon gebloggt?http://www.insidesql.de/blogs Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)
[<img src='/community/emoticons/emotion-1.gif' alt='' />] Perf.tuning is an integral part for a DBA [<img src='/community/emoticons/emotion-4.gif' alt='' />].<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by ramkumar.mu</i><br /><br />Looks like an exam for DBAs.<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />On SQL 2000 70028 <a target="_blank" href=http://www.microsoft.com/learning/exams/70-028.asp]>http://www.microsoft.com/learning/exams/70-028.asp]</a> covers bits & pieces of Performance topic. I believe there is no dedicated certification on this topic.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS†with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Thanks,<br />Ram<br /><br />"It is easy to write code for a spec and walk in water, provided, both are freezed..."<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br /> Perf.tuning is an integral part for a DBA .<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />True enough! However, the first one to be concerned with performance and tuning should be the developer. [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)
How many (developers) would take care or even think about it? I don't think not many as long as they are based as Dev.DBA as well. The main aim for a Developer is to work his code and don't care about other processess that might bring systems down. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
quote: The main aim for a Developer is to work his code and don't care about other processess that might bring systems down I agree that developers need to take care of their deadlines and might therefore produce only suboptimal working code and leave it to the "specialists" to tweak and tune that. But I really don't think that this is the way it should be. -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Heute schon gebloggt?http://www.insidesql.de/blogs Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)
I mean the Developer will only concerned if the query is performing poorly, so then the consideration of using relevant hints and fine tuning will come in to the picture. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
OK... is there any certification for SQL DBAs??? Thanks, Ram "It is easy to write code for a spec and walk in water, provided, both are freezed..."
right now i have no much time to explain but u can check it from self exam engine, i hope u ll find it good to help u