Forum Replies Created

Viewing 15 posts - 8,776 through 8,790 (of 19,560 total)

  • RE: Merge statement

    bitbucket-25253 (9/7/2011)

    SQLRNNR (9/7/2011)

    Nice question. Thanks to DBCC Timewarp we were able to answer the Oct 14 question over a month early. :-D:-D:-D:-D

    [? ? ?

    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 7, 2011 at 10:32 pm

    #1378356

  • RE: job failed while accessing dts package

    This job has worked in the past?

    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 7, 2011 at 10:15 pm

    #1378353

  • RE: Add LinkedIn and Twitter to Contact Details

    That would probably be nice. For now, everybody has to add that info to their sig.

    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 7, 2011 at 10:14 pm

    #1378351

  • RE: Merge statement

    Nice question. Thanks to DBCC Timewarp we were able to answer the Oct 14 question over a month early. :-D:-D:-D:-D

    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 7, 2011 at 9:51 pm

    #1378349

  • RE: The Right Kind Of Join III

    Thanks again Paul. Excellent explanation.

    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 7, 2011 at 9:41 pm

    #1378348

  • RE: Convert Excel query to SQL server 2008

    <> means "Not EQUAL"

    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 7, 2011 at 2:39 pm

    #1378284

  • RE: How to install 32 bit dtexec in sql server 2005 machine

    Do you have the installation media for SQL Server (disc or iso file)?

    You install these features from the installation media and select those particular options.

    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 7, 2011 at 2:38 pm

    #1378282

  • RE: Reverse Engineering In SSRS

    Typically reverse engineering is as simple as downloading the RDL and loading it up in BIDS. The RDL is made up of XML - so you could take 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 7, 2011 at 2:35 pm

    #1378279

  • RE: How to install 32 bit dtexec in sql server 2005 machine

    Install BIDS and the SQL Server Management tools.

    This article explains that 32Bit dtexec will be installed in both 64 Bit and 32Bit

    http://msdn.microsoft.com/en-us/library/ms162810(v=sql.90).aspx

    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 7, 2011 at 2:29 pm

    #1378276

  • RE: Are the posted questions getting worse?

    jcrawf02 (9/7/2011)

    SQLRNNR (9/7/2011)

    jcrawf02 (9/7/2011)

    SQLkiwi (9/7/2011)

    mtillman-921105 (9/7/2011)

    SQLkiwi (9/7/2011)

    Stefan Krzywicki (9/7/2011)

    Your birthday is 12/21? A good friend of mine has that same birthday. How do you feel about it being the shortest...

    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 7, 2011 at 2:26 pm

    #1378274

  • RE: Convert Excel query to SQL server 2008

    This should work for you.

    SELECT o.DADMS_ID,

    CASE WHEN o.Application=n.Application

    THEN o.Application

    ELSE 'Old: ' + o.Application + ' || New: ' + n.APPLICATION END

    AS Application,

    CASE WHEN o.Acronym=n.Acronym

    THEN o.Acronym

    ELSE 'Old:...

    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 7, 2011 at 2:24 pm

    #1378273

  • RE: Are the posted questions getting worse?

    jcrawf02 (9/7/2011)

    SQLkiwi (9/7/2011)

    mtillman-921105 (9/7/2011)

    SQLkiwi (9/7/2011)

    Stefan Krzywicki (9/7/2011)

    Your birthday is 12/21? A good friend of mine has that same birthday. How do you feel about it being the shortest day of...

    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 7, 2011 at 2:20 pm

    #1378271

  • RE: union all and ordering the data

    Ninja's_RGR'us (9/7/2011)

    piet.kouwer (9/7/2011)

    That's so polite of you. I think he thinks he's better than those as well :hehe:.

    Sound like a little sarcastic to me or am I wrong ?

    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

    September 7, 2011 at 2:14 pm

    #1378268

  • RE: Are the posted questions getting worse?

    SQLkiwi (9/7/2011)

    Stefan Krzywicki (9/7/2011)

    Your birthday is 12/21? A good friend of mine has that same birthday. How do you feel about it being the shortest day of the year?

    Talking of...

    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 7, 2011 at 2:07 pm

    #1378263

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (9/7/2011)

    SQLRNNR (9/7/2011)

    Stefan Krzywicki (9/7/2011)

    LutzM (9/7/2011)

    SQLRNNR (9/7/2011)

    Stefan Krzywicki (9/7/2011)

    SQLRNNR (9/7/2011)

    SQLkiwi (9/7/2011)

    Stefan Krzywicki (9/7/2011)

    OK, who had 9/7/2011 in the end of the world pool?

    Hmm. Where's the incentive to win?

    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

    September 7, 2011 at 1:41 pm

    #1378257

Viewing 15 posts - 8,776 through 8,790 (of 19,560 total)