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...

  • RE: Connectivity problem

    Thanks for posting the solution.

    Others may benefit from this topic in the future.

    Best regards,

  • 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...

  • 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,

  • RE: Connectivity problem

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

    Best regards,

  • 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...

  • 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...

  • RE: Triggers

    Glad to have answered it correctly.

    Thank you for the question.

    Best regards,

  • 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...

  • 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...

  • 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...

  • RE: Collation and SQL_VARIANT

    Amazing question! Thank you.

    Best regards,

  • 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...

  • 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...

  • 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...

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