Forum Replies Created

Viewing 15 posts - 3,586 through 3,600 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/19/2014)

    wolfkillj (2/19/2014)

    Fixed that for you.

    SQLRNNR (2/19/2014)

    Yay - I'm finally insane!!! :hehe::w00t:

    I was wondering who was going to break it to him.

    Congrats Jason.

    Haha - I was wondering who...

    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

    February 19, 2014 at 12:01 pm

    #1690410

  • RE: Are the posted questions getting worse?

    Revenant (2/19/2014)

    Greg Edwards-268690 (2/19/2014)

    SQLRNNR (2/19/2014)

    Sean Lange (2/19/2014)

    SQLRNNR (2/19/2014)

    Yay - I'm finally insane!!! :hehe::w00t:

    Woohoo!! Congrats!!!

    Thanks

    Maybe in 10yrs I can reach the SSC-Forever guild like Gail.

    Sounds like DBCC TimeWarp is starting to...

    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

    February 19, 2014 at 11:58 am

    #1690409

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (2/19/2014)

    SQLRNNR (2/19/2014)

    Sean Lange (2/19/2014)

    SQLRNNR (2/19/2014)

    Yay - I'm finally insane!!! :hehe::w00t:

    Woohoo!! Congrats!!!

    Thanks

    Maybe in 10yrs I can reach the SSC-Forever guild like Gail.

    Sounds like DBCC TimeWarp is starting to warm...

    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

    February 19, 2014 at 11:54 am

    #1690407

  • RE: Are the posted questions getting worse?

    Sean Lange (2/19/2014)

    SQLRNNR (2/19/2014)

    Yay - I'm finally insane!!! :hehe::w00t:

    Woohoo!! Congrats!!!

    Thanks

    Maybe in 10yrs I can reach the SSC-Forever guild like Gail.

    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

    February 19, 2014 at 11:14 am

    #1690393

  • RE: Stairway to SQLCLR Level 2: Sample Stored Procedure and Function

    Alan.B (2/19/2014)

    SQLRNNR (2/19/2014)

    Great article. Very useful information.

    One question I think could be answered and would be very useful to those noobs to CLR.

    How do you get the varbinary representation...

    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

    February 19, 2014 at 11:04 am

    #1690389

  • RE: Are the posted questions getting worse?

    Yay - I'm finally insane!!! :hehe::w00t:

    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

    February 19, 2014 at 10:53 am

    #1690387

  • RE: maintenance plan

    While I recommend getting SP1 installed, I have been successful in working around this error by creating the maintenance plans from another machine that has SSMS installed. Just use...

    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

    February 19, 2014 at 10:47 am

    #1690385

  • RE: making where clause dynamic

    To get a dynamic where clause you would need to use dynamic sql and execute that sql string.

    Or you could have both queries and an if else statement. Based...

    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

    February 19, 2014 at 10:42 am

    #1690383

  • RE: RDP to Production

    Lizzie (2/19/2014)

    Also some hilarious individuals have been known to shut the box down accidentally instead of logging out :-).

    I don't know if they are hilarious or not, but I 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

    February 19, 2014 at 10:40 am

    #1690381

  • RE: Stairway to SQLCLR Level 2: Sample Stored Procedure and Function

    Great article. Very useful information.

    One question I think could be answered and would be very useful to those noobs to CLR.

    How do you get the varbinary representation for 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

    February 19, 2014 at 10:32 am

    #1690378

  • RE: Page Life Expectancy is too low

    From the author of the book recommended by Gail, here is an article that talks about the formula and such.

    http://www.sqlskills.com/blogs/jonathan/finding-what-queries-in-the-plan-cache-use-a-specific-index/

    Best piece of advice there is this nugget

    Don’t use the value...

    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

    February 19, 2014 at 9:17 am

    #1690346

  • RE: Today's Random Word!

    Kurt W. Zimmerman (2/19/2014)

    crookj (2/19/2014)

    WotD - tedium

    boring

    drilling

    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

    February 19, 2014 at 8:29 am

    #1690323

  • RE: Stored procedure running from SSIS hangs

    Karen A. Ferrara-426245 (2/19/2014)

    Yes, I am calling the stored procedure from BIDS / SSIS 2008.

    What kind of task are you calling the proc from? Is it an execute sql...

    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

    February 19, 2014 at 8:14 am

    #1690311

  • RE: Create a column of numbers that increment by 1

    caippers (2/19/2014)

    All these answers worked so I thank you all. As to why I was doing the cross join... I'm new at SQL and that was the approach 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

    February 19, 2014 at 8:13 am

    #1690307

  • RE: Stored procedure running from SSIS hangs

    As a follow up to Koen's question, is this occurring when you are running the package from BIDS?

    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

    February 19, 2014 at 8:10 am

    #1690303

Viewing 15 posts - 3,586 through 3,600 (of 19,560 total)