Forum Replies Created

Viewing 15 posts - 7,561 through 7,575 (of 19,560 total)

  • RE: SSIS - basic question

    Welsh Corgi (12/13/2011)


    Why would you want to import the data from a CSV, then match on the SSN and/or DOB and turn around and export back to 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

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (12/13/2011)


    SQLRNNR (12/13/2011)


    About due for a Pantsectomy :-D:-D:-D:-D

    40F in Denver, no need for pants today.:-P

    Just as long as you wear the Cowboy hat

    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

  • RE: Today's Random Word!

    remedy

    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

  • RE: Today's Random Word!

    ciao

    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

  • RE: SSIS - basic question

    Elliott Whitlow (12/13/2011)


    However, may I ask a dumb question. You are importing from a CSV and then eventually exporting a CSV file. How are they different, why is...

    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

  • RE: Are the posted questions getting worse?

    Evil Kraig F (12/13/2011)


    Revenant (12/13/2011)


    GSquared (12/13/2011)


    jcrawf02 (12/13/2011)


    I think that's actually showing up as a diagnosis in ICD-10, "Threadizen"

    CDC request...

    And the only cure is beingectomy - in other words, you 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

  • RE: SSIS - basic question

    Add a new data flow. In that flow, pull in the data from the database you just created and then connect that to a flat file destination.

    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

  • RE: Are the posted questions getting worse?

    jcrawf02 (12/13/2011)


    I think that's actually showing up as a diagnosis in ICD-10, "Threadizen"

    CDC request...

    Threadizen = Zombie

    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

  • RE: Sorting triggered by data type

    Thanks for the 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

  • RE: Minimum permissions to allow access to SMO.Server.Databases.Users list

    It sounds very good.

    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

  • RE: Are the posted questions getting worse?

    jcrawf02 (12/13/2011)


    Favorite email exchange of the day (after the other party read the recursive CTE date article in the newsletter, and I pointed them to Jeff's comment/article in the discussion):

    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

  • RE: Table Description

    Not all tables have extended properties. The way you constructed the query to rely on major version and minor version requires extended properties to be declared prior to 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

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (12/12/2011)


    LutzM (12/12/2011)


    Evil Kraig F (12/12/2011)


    ...

    Nah, he used the front portion of the crown. It's about the hardest portion of your body, he's fine. I've done that 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

  • RE: Table Description

    Try this:

    SELECT t.name As Tablename,

    c.name AS ColumnName,

    ty.name AS TypeName,

    c.is_nullable As Is_Nullable,

    c.is_identity As Is_Identity,

    ep.Value As TableDescription

    FROM sys.tables AS t

    LEFT OUTER JOIN sys.extended_properties AS ep ON t.object_id = ep.major_id

    LEFT OUTER JOIN sys.columns...

    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

  • RE: Remove SQL Server database secondary data files

    Oh, and the link provided by Bru is what I would have recommended. Empty the files to other files in the group and then drop the file - 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

Viewing 15 posts - 7,561 through 7,575 (of 19,560 total)