Forum Replies Created

Viewing 15 posts - 7,981 through 7,995 (of 19,560 total)

  • RE: Reindex failed primary file group not enough space

    Ninja's_RGR'us (10/31/2011)

    sqlfriends (10/31/2011)

    Thanks all.

    First, I see the script is so long, I will have to study it a little bit later before I use it .

    Second, I checked in the...

    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

    November 7, 2011 at 9:39 am

    #1404054

  • RE: Reindex failed primary file group not enough space

    Ninja's_RGR'us (10/31/2011)

    Actually there's an easy way out of this.

    Maint. Plans always reindex everything no matter what (needed or not). This is usually a big waste of time and ressources.

    I...

    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

    November 7, 2011 at 9:38 am

    #1404052

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (11/7/2011)

    Totally different topic: this thread asks how to format datetime values in T-SQL.

    I think this is a very bad habit to kick and I put together an...

    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

    November 7, 2011 at 9:11 am

    #1404024

  • RE: Are the posted questions getting worse?

    Anybody else going to SQLInspire in NYC?

    It dawned on me that I have to fly 2000 miles east just to connect with Steve who is only 400 Miles East.

    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

    November 7, 2011 at 8:44 am

    #1403996

  • RE: Today's Random Word!

    Daniel Bowlin (11/7/2011)

    crookj (11/4/2011)

    Seen a new quote that I really like...

    “Knowledge x Application x Motivation = Performance” (Anonymous)

    Joe

    Luck is when opportunity meets preparation.

    H

    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

    November 7, 2011 at 8:32 am

    #1403985

  • RE: Network Protocals

    Straight forward simple question.

    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

    November 6, 2011 at 10:49 pm

    #1403782

  • RE: MSDTC resource not coming online

    I had a similar thing happen just this last week. I had to delete the cluster resource and then recreate it.

    The other note that seems interesting is that you...

    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

    November 6, 2011 at 10:47 pm

    #1403781

  • RE: Starting with "WITH"

    Jeff Moden (11/6/2011)

    SQLRNNR (11/6/2011)

    Jeff Moden (11/5/2011)

    SQLRNNR (11/3/2011)

    Yes recursive CTEs can be slow - you need to be sure you have defined your recursion well enough.

    I have seen them perform marvelously...

    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

    November 6, 2011 at 10:03 pm

    #1403776

  • RE: Are the posted questions getting worse?

    Grant Fritchey (11/5/2011)

    SQL Kiwi (11/4/2011)

    SQLRNNR (11/4/2011)

    What is this query plan operator?

    It depends. It could be a hash join, hash aggregate, flow distinct, or a union...

    Really? Looks like a car...

    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

    November 6, 2011 at 5:19 pm

    #1403757

  • RE: Starting with "WITH"

    SQL Kiwi (11/6/2011)

    L' Eomot Inversé (11/5/2011)

    That rCTEs are bad for counting doesn't make all use of rCTEs silly and it certainly doesn't demonstrate that rCTEs are not a set-based concept;...

    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

    November 6, 2011 at 5:14 pm

    #1403756

  • RE: Starting with "WITH"

    Jeff Moden (11/5/2011)

    SQLRNNR (11/3/2011)

    Yes recursive CTEs can be slow - you need to be sure you have defined your recursion well enough.

    I have seen them perform marvelously as well. ...

    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

    November 6, 2011 at 5:13 pm

    #1403755

  • RE: What minimum rights do you need?

    you're welcome

    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

    November 4, 2011 at 11:46 am

    #1403423

  • RE: How to get the All the records from a Table while using the sum and other calculations

    Please provide a sample of the expected result along with sample 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

    November 4, 2011 at 11:24 am

    #1403412

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (11/4/2011)

    SQLRNNR (11/4/2011)

    sweet - but is it cheating if you didn't catch me?

    I think he just did :w00t:

    No, it's just an illusion:crazy:

    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

    November 4, 2011 at 10:48 am

    #1403392

  • RE: Copying data sources from Sharepoint 2007 integrated to Sharepoint 2010 integrated

    I have an article on how to move the rdl files - which I adapted that very same method to export the data sources.

    You can find it here[/url].

    Read the article...

    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

    November 4, 2011 at 10:29 am

    #1403381

Viewing 15 posts - 7,981 through 7,995 (of 19,560 total)