Forum Replies Created

Viewing 15 posts - 4,396 through 4,410 (of 8,761 total)

  • RE: Random number !

    farax_x (10/3/2015)


    I have a function which generate random number in range :

    CREATE FUNCTION Func_Rand

    (

    @max-2 BIGINT ,

    ...

  • RE: Like Statement With Parameters

    Jason A. Long (10/3/2015)


    Eirikur - I'm with Chris on this one... VERY slick solution.

    I have to confess that I'm baffled by optimizer's ability to do an index seek with leading...

  • RE: Alternative query which can have better performance

    Quick question, is this query really producing the desired result set when it is missing the filtering in the XML subqueries?

    😎

  • RE: Today's Random Word!

    DonlSimpson (10/2/2015)


    djj (10/2/2015)


    anthony.green (10/2/2015)


    whereisSQL? (10/2/2015)


    crookj (10/2/2015)


    anthony.green (10/2/2015)


    eccentricDBA (10/2/2015)


    anthony.green (10/2/2015)


    BWFC (10/2/2015)


    anthony.green (10/2/2015)


    SQLRNNR (10/1/2015)


    pish

    annoyed

    Always

    Developers

    Tycoons

    Zoo

    ...lander

    Movie

    Trivia

    Knowledge

    Understanding

    Perception

  • RE: Are the posted questions getting worse?

    Lynn Pettis (10/2/2015)


    Eirikur Eiriksson (10/2/2015)


    Lynn Pettis (10/2/2015)


    How do I clear the DMVs without restarting SQL?

    Why?

    😎

    Because I don't necessarily want to restart SQL just to clear some of the DMVs I...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (10/2/2015)


    How do I clear the DMVs without restarting SQL?

    Why?

    😎

  • RE: SPID Causing Locks With No Query Text Shown

    joshdbguy (10/1/2015)


    I just ran into an issue with cascading locks due to a SPID on one of my production servers. When researching the lock, I noticed that there was no...

  • RE: Are the posted questions getting worse?

    ChrisM@Work (10/2/2015)


    dwain.c (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my...

  • RE: Deadlocks

    Looking at the DG again, I think the Workflow table has nothing to do with the deadlock, it is just part of one of the implicit transactions that are trying...

  • RE: Deadlocks

    Lynn Pettis (10/2/2015)


    There are no foreign key relationships between any of the tables in the database. There is no table above the base report tables (OperationsSIGACTDraftReport OperationsSIGACTPublishedReport, etc)....

  • RE: Are the posted questions getting worse?

    Lynn Pettis (10/1/2015)


    In my Deadlock thread, was I wrong to admonish the former MVP over his first post? It just hit me wrong.

    I think it was on the overreacting...

  • RE: Deadlocks

    Quick question, are the ReportKey columns in in both tables coming from a third table or are there any other such indirect relationships?

    😎

    +---------------+ ...

  • RE: Today's Random Word!

    djj (10/1/2015)


    Ed Wagner (10/1/2015)


    anthony.green (10/1/2015)


    crookj (9/30/2015)


    Ed Wagner (9/30/2015)


    DonlSimpson (9/30/2015)


    Ed Wagner (9/30/2015)


    anthony.green (9/30/2015)


    Ed Wagner (9/30/2015)


    anthony.green (9/30/2015)


    whereisSQL?(9/30/2015)


    Pour

    Pitcher

    Beer

    Brew

    Pub

    Bar

    Prohibit

    Disallow

    Explicit

    Implicit

    Convert

    Morph

  • RE: Incorrect Syntax Near 'Go'

    andy 61637 (10/1/2015)


    Is there a way to have SSMS generate a create script using ; instead of go ? My create script is huge, quite a lot of editing...

  • RE: Are the posted questions getting worse?

    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my ESB all over the...

Viewing 15 posts - 4,396 through 4,410 (of 8,761 total)