Forum Replies Created

Viewing 15 posts - 16,486 through 16,500 (of 19,560 total)

  • RE: SQL Server Consolidation

    Welsh Corgi (3/14/2010)


    This was back in 2008 Timeframe that this issue initially came up.

    Then they ran out of money and the project was put on hold

    Is the project back on...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: SQL Server Consolidation

    Paul White (3/14/2010)


    Welsh Corgi (3/14/2010)


    ...the guy that wanted the blades was using low temperature as one of the justifications for selecting that type hardware.

    They may well have improved since 2007-8....

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    Paul White (3/14/2010)


    Where have all the questions gone? Seems very quiet...perhaps too quiet...

    They were scared away like those silly english k-niggits. Sir Robin Bravely ran away. He...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: SQL Server Consolidation

    We too are moving to blades. I know of a few others that have recently moved to blades - and they have found the performance to be phenomenally better...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Cannot Shrink Database

    Fraggle-805517 (3/13/2010)


    Alright, so I know have 3 seperate people telling me that dbcc shrinkfile will shrink the file lower than the inital file size.

    However, if you read my first post,...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: SQL Monitoring Tools

    GTR (3/13/2010)


    If cost is the constraint, then you can set up traces in SQL itself in SQL 2008. Else i would recommend SCOM for Jobs, Disk space, Memory, cluster services...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Attribute to identify system databases

    Jeff Moden (3/13/2010)


    Steve Jones - Editor (3/13/2010)


    ... and if MS listens, I hope we get a tempdb for each db

    Lordy, I hope that doesn't happen. Imagine trying to correctly...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    Paul White (3/13/2010)


    CirquedeSQLeil (3/13/2010)


    lmu92 (3/13/2010)


    @paul-2: CONGRATULATION to be one of the top 25!

    Congrats indeed. He's been making a mad push lately.

    Top 25 overall? I will have to go...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: The Corporate Borg

    Information and knowledge sharing is one thing. At the other end of the spectrum is being mindlessly assimilated like the borg. You just do as you are told,...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Find all objects that use this view?

    WayneS (3/13/2010)


    The 2005/2008 query that I use is:

    select OBJECT_NAME(object_id), *

    from sys.all_sql_modules

    where definition like '%<your search phrase goes here>%'

    If I want to limit the results to just views,...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    WayneS (3/13/2010)


    Paul White (3/12/2010)


    Jeff Moden (3/12/2010)


    We're rootin' for ya!

    * snigger *

    See the entry for root here

    Isn't it amazing how one perfectly innocent term in one culture means something completely different...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Some tables permission on some databases

    GTR (3/12/2010)


    I would set up AD group and grant permission to the group and add users to that group.

    And then put that group in a role in SQL Server 😀

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    lmu92 (3/13/2010)


    @paul-2: CONGRATULATION to be one of the top 25!

    Congrats indeed. He's been making a mad push lately.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Find all objects that use this view?

    FabricioLimaDBA (3/12/2010)


    That's OK. I work with Sql Server 2000 and 2005 yet. I will make the upgrade.

    Thank you.

    Something that I do is make it conditional. I run in a...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Is it possible...

    Jeff Moden (3/12/2010)


    Steve Jones - Editor (3/12/2010)


    I don't think there's a way to be sure of the last date, but you can disable logins and then see if someone complains.

    Heh......

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 15 posts - 16,486 through 16,500 (of 19,560 total)