Forum Replies Created

Viewing 15 posts - 4,396 through 4,410 (of 19,560 total)

  • RE: Using a View from one database to a second database that returns a large result set

    Erland Sommarskog (7/30/2013)

    Kalyan Boddupalli (7/30/2013)

    1. Make sure nolocks are maintained on the tables from where the data is getting selected

    Do you mean that the NOLOCK hint should be used? Have...

    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 30, 2013 at 2:42 pm

    #1637116

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (7/30/2013)

    SQLRNNR (7/29/2013)

    L' Eomot Inversé (7/29/2013)

    WayneS (7/29/2013)

    Just curious - how many like that new tile look on the home page?

    FWIW: I prefer the older images over these tiles.

    I think...

    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 30, 2013 at 2:41 pm

    #1637115

  • RE: Using a View from one database to a second database that returns a large result set

    There are 2 databases on one sql server. One database has a view that query’s the second database on the same sql server the view is a 'select * from...

    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 29, 2013 at 10:53 pm

    #1636825

  • RE: indentifing the spid

    download and install sp_whoisactive

    http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx

    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 29, 2013 at 10:44 pm

    #1636824

  • RE: Some Relevant PowerShell Books

    Thanks for the list of resources

    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 29, 2013 at 10:37 pm

    #1636823

  • RE: A New Look

    Jeff Moden (7/29/2013)

    I just took a look at the home page for the first time this morning. Why in the hell do people think that change is always for...

    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 29, 2013 at 10:13 pm

    #1636819

  • RE: New Guy

    Welcome and good luck

    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 29, 2013 at 10:12 pm

    #1636818

  • RE: Are the posted questions getting worse?

    Grant Fritchey (7/29/2013)

    WayneS (7/29/2013)

    Just curious - how many like that new tile look on the home page?

    FWIW: I prefer the older images over these tiles.

    It's all http://www.youtube.com/watch?v=0pRUGsB1qGY all the time,...

    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 29, 2013 at 5:11 pm

    #1636789

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (7/29/2013)

    WayneS (7/29/2013)

    Just curious - how many like that new tile look on the home page?

    FWIW: I prefer the older images over these tiles.

    I think it's pretty ugly...

    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 29, 2013 at 5:09 pm

    #1636787

  • RE: Today's Random Word!

    breaky

    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 29, 2013 at 5:07 pm

    #1636786

  • RE: TSQL- XQuery

    Koen Verbeeck (7/28/2013)

    Tsk tsk, first question of the week, and it's about XQuery (ugh). And even a trick question (double ugh).

    I second those "ugh"'s

    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 28, 2013 at 3:20 pm

    #1636501

  • RE: Today's Random Word!

    Revenant (7/26/2013)

    SQLRNNR (7/26/2013)

    The Dixie Flatline (7/26/2013)

    SQLRNNR (7/26/2013)

    The Dixie Flatline (7/26/2013)

    SQLRNNR (7/26/2013)

    cornpopper

    Redenbacher

    Red Auerbach

    Redback

    yummy

    don't

    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 26, 2013 at 3:14 pm

    #1636344

  • RE: Today's Random Word!

    The Dixie Flatline (7/26/2013)

    SQLRNNR (7/26/2013)

    The Dixie Flatline (7/26/2013)

    SQLRNNR (7/26/2013)

    cornpopper

    Redenbacher

    Red Auerbach

    Redback

    yummy

    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 26, 2013 at 2:59 pm

    #1636339

  • RE: Today's Random Word!

    The Dixie Flatline (7/26/2013)

    SQLRNNR (7/26/2013)

    cornpopper

    Redenbacher

    Red Auerbach

    (apparently we hit a quote limit because it started messing up the inline quotes)

    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 26, 2013 at 2:02 pm

    #1636318

  • RE: Today's Random Word!

    The Dixie Flatline (7/26/2013)

    SQLRNNR (7/26/2013)

    The Dixie Flatline (7/26/2013)

    SQLRNNR (7/26/2013)

    crookj (7/26/2013)

    SQLRNNR (7/26/2013)

    Revenant (7/26/2013)

    The Dixie Flatline (7/26/2013)

    opc.three (7/26/2013)

    SQLRNNR (7/26/2013)

    bcsims 90437 (7/26/2013)

    Daniel Bowlin (7/26/2013)

    crookj (7/26/2013)

    SQLRNNR (7/25/2013)

    The Dixie Flatline (7/25/2013)

    SQLRNNR (7/25/2013)

    Revenant (7/25/2013)

    L' Eomot Inversé...

    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 26, 2013 at 1:51 pm

    #1636313

Viewing 15 posts - 4,396 through 4,410 (of 19,560 total)