Forum Replies Created

Viewing 15 posts - 8,671 through 8,685 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    WayneS (9/16/2011)

    Question for those that blog (preferably with WordPress) and post code on their blog - what code syntax tool do you use? I'm using WP-SynHighlight, but I'm not completely...

    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

    September 16, 2011 at 9:08 am

    #1382601

  • RE: Are the posted questions getting worse?

    Roy Ernest (9/16/2011)

    How about an intro to VLFs? VLFs is not something every one knows about. Also how logs are written and read from it?

    I think the topic on VLFs...

    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

    September 16, 2011 at 9:06 am

    #1382600

  • RE: Compare two records of the same table

    The use of windowed functions comes to mind as well (row_number).

    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

    September 16, 2011 at 8:08 am

    #1382565

  • RE: Possible reasons for EXECUTE permission error

    Have you checked for other running jobs at that time?

    Is the udf being snapshot replicated to the server you are working 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

    September 16, 2011 at 8:06 am

    #1382562

  • RE: Are the posted questions getting worse?

    GilaMonster (9/16/2011)

    I suspect this got lost in all the 'helping Grant abuse SQL' posts...

    Another request:

    I'm bunking tonight and starting the rewrite of my rather old (and second-ever) article Managing Transaction...

    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

    September 16, 2011 at 7:52 am

    #1382551

  • RE: Today's Random Word!

    Ray K (9/16/2011)

    Daniel Bowlin (9/16/2011)

    Zoom

    Schwartz

    (Let's see if anyone picks up on this!)

    Careful you idiot! I said across her nose, not up it!

    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

    September 16, 2011 at 7:45 am

    #1382549

  • RE: Proper Case

    Cadavre (9/16/2011)

    Sudhir Dwivedi (9/16/2011)

    huh!!!!

    ...

    ???:crazy:

    Try it like this: -

    DECLARE @str VARCHAR(255) ='rajneeh kumar is working in technext'

    SET @str = ' ' + @str

    SET @str = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

    REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

    REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

    REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

    REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

    REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

    REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

    REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(@str, ' a', ' 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

    September 16, 2011 at 7:43 am

    #1382543

  • RE: Proper Case

    HowardW (9/16/2011)

    The theory does actually work, it would just be useful if 5 seconds of care was taken before posting to make sure it was formatted correctly. If you just...

    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

    September 16, 2011 at 7:37 am

    #1382538

  • RE: SQL Partition

    This is a good topic for the question. I think some tweaks to the question as pointed out by vk-kirov could make it a better 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

    September 16, 2011 at 7:33 am

    #1382535

  • RE: case function

    What is the desired output supposed to look like? Please provide a sample.

    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

    September 15, 2011 at 11:20 pm

    #1382384

  • RE: Adding a null column and setting it to a default value of 0

    SQLTestUser (9/15/2011)

    I am trying to add a null column and set it to a default value of 0

    with

    ALTER TABLE X add acolumn smallint NULL Default '0'

    but when...

    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

    September 15, 2011 at 11:18 pm

    #1382382

  • RE: script component error message

    What is your exact error message?

    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

    September 15, 2011 at 11:16 pm

    #1382381

  • RE: Dotted Line Relationships Are Everywhere – Get Good at Them!

    Dotted lines add a bit of complexity for certain. If the group at each end of the dotted line understands the objectives and the scope of that dotted line...

    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

    September 15, 2011 at 10:54 pm

    #1382377

  • RE: Proper Case

    Sudhir Dwivedi (9/15/2011)

    Also, Jason's function needs a review as it's not doing the job (proper case).

    Fixed - copy paste mistake.

    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

    September 15, 2011 at 10:48 pm

    #1382376

  • RE: Report on millions of transactions by date

    The Pivot should help you with this.

    Here is an article with examples:

    http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/

    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

    September 15, 2011 at 10:14 pm

    #1382372

Viewing 15 posts - 8,671 through 8,685 (of 19,560 total)