Forum Replies Created

Viewing 15 posts - 6,061 through 6,075 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (7/3/2012)

    GilaMonster (7/3/2012)

    Brandie Tarvin (7/3/2012)

    Anyone got a fresh brain I could borrow? I promise to return it with only a slight bit of wear.

    Sure. Will you finish off my...

    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

    July 3, 2012 at 2:17 pm

    #1508487

  • RE: Empty space in tables

    Lynn Pettis (7/3/2012)

    SQLRNNR (7/3/2012)

    sqluser_8119 (7/3/2012)

    Lynn Pettis (7/3/2012)

    SQLKnowItAll (7/3/2012)

    Are you running out of space? If so, I wouldn't shrink them. Just continue to use up the available space.

    I'm going...

    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

    July 3, 2012 at 1:38 pm

    #1508461

  • RE: Empty space in tables

    sqluser_8119 (7/3/2012)

    Lynn Pettis (7/3/2012)

    SQLKnowItAll (7/3/2012)

    Are you running out of space? If so, I wouldn't shrink them. Just continue to use up the available space.

    I'm going to throw out...

    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

    July 3, 2012 at 1:22 pm

    #1508453

  • RE: Simple Recovery Model

    The truncate is performed via a checkpoint. Keep in mind that a truncate in the t-log does not free space to the OS. It is a mechanism that...

    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

    July 3, 2012 at 1:20 pm

    #1508451

  • RE: DateFormat

    d'oh missed it because I inverted my answer.

    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

    July 3, 2012 at 1:17 pm

    #1508450

  • RE: log file shrinking..

    What is your recovery model?

    Does dbcc opentran return anything?

    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

    July 3, 2012 at 12:58 pm

    #1508438

  • RE: Simple Recovery Model

    This article should help you understand:

    http://www.sqlservercentral.com/articles/Administration/64582/

    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

    July 3, 2012 at 12:57 pm

    #1508437

  • RE: Empty space in tables

    The old location is probably retaining size due to BLOBs that were in the primary filegroup.

    If you have data that was in those tables that was in a blob data...

    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

    July 3, 2012 at 12:55 pm

    #1508435

  • RE: Granting datareader access to a user for objects in a schema

    Is the user not able to list the tables out in SSMS? Not able to edit the tables? Not able to script the tables?

    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

    July 3, 2012 at 12:51 pm

    #1508432

  • RE: Today's Random Word!

    Revenant (7/3/2012)

    Daniel Bowlin (7/3/2012)

    vertigo

    Hitchcock

    King

    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

    July 3, 2012 at 10:14 am

    #1508309

  • RE: remove duplicate records

    Here is something that could help you write a query to dedupe your data

    http://jasonbrimhall.info/2011/03/21/dedupe-data-cte/

    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

    July 2, 2012 at 4:04 pm

    #1507960

  • RE: Six Figures

    Michael Valentine Jones (6/30/2012)

    I don't give much credibility to anything I read on the InfoWorld site, even when they're quoting another source.

    They're just cheerleaders for the latest IT fads, and...

    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

    July 2, 2012 at 12:43 pm

    #1507896

  • RE: Today's Random Word!

    Ray K (7/2/2012)

    Legend!!! (Baseball one, that is -- got my picture taken with one on Saturday!!!)

    Seriously cool

    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

    July 2, 2012 at 11:22 am

    #1507856

  • RE: Talking baseball

    Steve Jones - SSC Editor (7/2/2012)

    Visible proof

    SWEET!

    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

    July 2, 2012 at 11:22 am

    #1507855

  • RE: Today's Random Word!

    Brandie Tarvin (7/2/2012)

    Rumba

    Zumba

    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

    July 2, 2012 at 9:46 am

    #1507793

Viewing 15 posts - 6,061 through 6,075 (of 19,560 total)