Forum Replies Created

Viewing 15 posts - 211 through 225 (of 371 total)

  • RE: Licensing Model for 2012

    Essentially it will be the same thing if you have 4 cores per CPU or less.

    But for 6 or 8 cores, the price will be a little higher.

    I guess it...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • RE: Connectivity problem

    Thanks for posting the solution.

    Others may benefit from this topic in the future.

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • RE: Knowledge capicity of a DBA

    the more I learn, the more I realise what I don't know and this actually scares me.

    Well put.

    When I was just a developer a couple of years ago, I felt...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • RE: Removing TDE

    Thank you for sharing the article.

    It's something great to know before facing a situation like that which may get people fired if they're not careful.

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • RE: Connectivity problem

    Is the SQL Browser service started in the 2nd server?

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • RE: de-normalize normalized data.....

    SQLRNNR (11/2/2011)


    codebyo (11/2/2011)


    Wouldn't a pivot table be able to achieve that?

    I'm trying to make an example but I'm not being successful because I'm not experience in using that technique.

    Perhaps someone...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • RE: de-normalize normalized data.....

    Wouldn't a pivot table be able to achieve that?

    I'm trying to make an example but I'm not being successful because I'm not experience in using that technique.

    Perhaps someone more experienced...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • RE: Triggers

    Glad to have answered it correctly.

    Thank you for the question.

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • RE: Autoshrink in our client's databases

    Thank you.

    I'm convincing our CIO to make changes and I'm being successful in optimizing many things there. My company aims bigger clients but they don't understand that it will generate...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • RE: Autoshrink in our client's databases

    Thank you, Jason.

    That's great information and advice.

    I'm noticing that the indexes are getting 70%-90% fragmented even with small data being inserted and modified so the reports (based on views that...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • RE: Identifying who took a database offline

    ALZDBA (11/1/2011)


    Just a way to import your default trace and query it... see attachment

    ( this one reports auto grow events ,should be peace of cake to have it filter detach...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • RE: Collation and SQL_VARIANT

    Amazing question! Thank you.

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • RE: How to Get Month Using Given two Dates

    Jeff Moden (10/31/2011)


    codebyo (10/31/2011)


    ... so no need to worry about loops there and also because it's easier to read. 😉

    You do understand that them's fightin' words, right Andre? 😉

    I...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • RE: How to Get Month Using Given two Dates

    Thank you for the alternative.

    I only posted the code that way because we're only dealing with variables and not result sets, so no need to worry about loops there and...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • RE: SQL Server 2008 - Disabling Full Text Search

    Hmm... that's interesting.

    You can disable the full-text feature by accessing the database facets... but I didn't know that you couldn't disable the full-text SEARCH.

    [edit] That options does nothing. Now I...

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

Viewing 15 posts - 211 through 225 (of 371 total)