sql server performance

  • How to improve performance of sql server?

  • Wow, thats such a massive topic, way to much to get into on a SQL forum.

    I would recommend using our good friend Google.

    If you have a specific issue then we may be able to help you better.

    An other good place to start might be here http://www.red-gate.com/community/books/accidental-dba

  • Spend lots of money and buy a 64-bit Enterprise version of SQL Server then you can spend lots more money on tons of CPUs and Memory. Then buy lots of really fast drives. Every time performance slows down, spend more money.

    Or, you can monitor the system to identify what is running slow, what processes are causing blocking and waits, figure out why they're causing these problems, then work through resolving the database design, index structures or T-SQL code. If you want to take that second approach, my book, listed below, can help. There is a 2008 version and a 2012 version of the book available.

    "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

  • employ good database administrators 🙂

    MVDBA

  • i am from Macedonia.

    i go to SQL Server administration curs

    can you tell me were i can find exam 40-432 and 70 450?

    i have some page for that but i can not open and see questions

    pales help me thank you

    my mail reks12@gmail.com

  • reks12 (5/14/2012)


    i am from Macedonia.

    i go to SQL Server administration curs

    can you tell me were i can find exam 40-432 and 70 450?

    i have some page for that but i can not open and see questions

    pales help me thank you

    my mail reks12@gmail.com

    Please do not hijak other peoples threads.

    Please look through the Microsoft Learning page for the two exams in question to find the official set of supported materials which do not infringe the NDA which is signed by all people taking the exams to prevent leaking of questions.

  • thank you for your answer.

    i have some page for that question but it ask me to download it

    i want to see question with download it on my pc

    that page is

    exsamcolection.com

    tell me how can i see questions on this side

  • reks12 (5/14/2012)


    thank you for your answer.

    i have some page for that question but it ask me to download it

    i want to see question with download it on my pc

    that page is

    exsamcolection.com

    tell me how can i see questions on this side

    Again, don't hijack other threads. If you have a question of your own, please, open your own thread.

    BTW, the only way to see the questions legally is to take the test. Any other way you're "seeing the questions" is illegal. We absolutely won't help you lie, cheat or steal on this web site.

    "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

  • but i dont want to steal nothing

    you dont understand me well

    i just want to see question for exam

    that is all

  • To avoid breaking the NDA (unsure if the questions from your website are brain dumps) look here for the official practise tests

    70-432 and here 70-450

  • Scary, looking through that site, and most of the comments on the resources, it seems like the are braindumps which are in voilation of the NDA.

  • BTW, the only way to see the questions legally is to take the test. Any other way you're "seeing the questions" is illegal. We absolutely won't help you lie, cheat or steal on this web site.

    I'm scared... Especially by the second sentence about "illegal". :w00t:

    What about if would look for something and see them just by occasion? How to erase this fact from my visual memory? Brrrrrrr!

    But after googling for few minutes I feel much more relaxed, as I couldn't find any law referring to "seeing MS Certification Exam questions elsewhere".

    I can sleep good tonight...

    :hehe:

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • Eugene Elutin (5/14/2012)


    BTW, the only way to see the questions legally is to take the test. Any other way you're "seeing the questions" is illegal. We absolutely won't help you lie, cheat or steal on this web site.

    I'm scared... Especially by the second sentence about "illegal". :w00t:

    What about if would look for something and see them just by occasion? How to erase this fact from my visual memory? Brrrrrrr!

    But after googling for few minutes I feel much more relaxed, as I couldn't find any law referring to "seeing MS Certification Exam questions elsewhere".

    I can sleep good tonight...

    :hehe:

    From the Microsoft Certification Web Site:

    A "brain dump," as it relates to the certification exams, is a source, such as a website, that contains certification exam content that has been fraudulently obtained with the intention to share it with or sell it to exam candidates. The content included in brain dumps is exactly the same or substantially similar to items appearing on the exam. Because the exam content was fraudulently obtained, using this type of material to prepare for or during an exam constitutes cheating. "Brain dump" providers are in violation of Microsoft intellectual property rights and nondisclosure agreements.

    Which can result in:

    If a candidate knowingly or unknowingly memorizes unauthorized content found in “brain dumps” in order to pass an exam, clearly, he or she will not have the requisite skills to effectively use and manage Microsoft software or systems. Eventually, his or her manager will identify this lack of technical knowledge and skill and take appropriate action. If Microsoft learns that a candidate used a “brain dump” site to prepare for an exam, this candidate will be permanently banned or prohibited from taking any future Microsoft Certification exams and may be decertified from the Microsoft Certification Program. In addition, test scores and certifications, if applicable, may be revoked. These actions may be taken even if the candidate did not intend to defraud the Microsoft Certification Program.

    Many "brain dump" providers are fairly blatant in their messaging, descriptions of their products, and the intended uses, while others are much more subtle in their messaging and practices. As a result, candidates should be cautious about using exam preparation material that seems too good to be true.

    The key words there are "permanent ban" Toss that in along with "unknowingly" and I'd be nervous if I were looking at lists of questions without a very good provenance. There are valid sample tests. If you're using one of these, you're not cheating. If you're using anything else...

    "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

  • but write me page were i can find that question

    i just want to learn that program

    maybe to pass exam

    please dont be angry

    :crying:

  • Grant Fritchey (5/14/2012)


    Eugene Elutin (5/14/2012)


    BTW, the only way to see the questions legally is to take the test. Any other way you're "seeing the questions" is illegal. We absolutely won't help you lie, cheat or steal on this web site.

    I'm scared... Especially by the second sentence about "illegal". :w00t:

    What about if would look for something and see them just by occasion? How to erase this fact from my visual memory? Brrrrrrr!

    But after googling for few minutes I feel much more relaxed, as I couldn't find any law referring to "seeing MS Certification Exam questions elsewhere".

    I can sleep good tonight...

    :hehe:

    From the Microsoft Certification Web Site:

    A "brain dump," as it relates to the certification exams, is a source, such as a website, that contains certification exam content that has been fraudulently obtained with the intention to share it with or sell it to exam candidates. The content included in brain dumps is exactly the same or substantially similar to items appearing on the exam. Because the exam content was fraudulently obtained, using this type of material to prepare for or during an exam constitutes cheating. "Brain dump" providers are in violation of Microsoft intellectual property rights and nondisclosure agreements.

    Which can result in:

    If a candidate knowingly or unknowingly memorizes unauthorized content found in “brain dumps” in order to pass an exam, clearly, he or she will not have the requisite skills to effectively use and manage Microsoft software or systems. Eventually, his or her manager will identify this lack of technical knowledge and skill and take appropriate action. If Microsoft learns that a candidate used a “brain dump” site to prepare for an exam, this candidate will be permanently banned or prohibited from taking any future Microsoft Certification exams and may be decertified from the Microsoft Certification Program. In addition, test scores and certifications, if applicable, may be revoked. These actions may be taken even if the candidate did not intend to defraud the Microsoft Certification Program.

    Many "brain dump" providers are fairly blatant in their messaging, descriptions of their products, and the intended uses, while others are much more subtle in their messaging and practices. As a result, candidates should be cautious about using exam preparation material that seems too good to be true.

    The key words there are "permanent ban" Toss that in along with "unknowingly" and I'd be nervous if I were looking at lists of questions without a very good provenance. There are valid sample tests. If you're using one of these, you're not cheating. If you're using anything else...

    +1, I was also just typing a post detailing the NDA and the consqeuences.

    If in doubt only use what is listed on the official learning page for the exam. So in this case MeasureUp.com and SelfTestSoftware.com

Viewing 15 posts - 1 through 15 (of 19 total)

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