Forum Replies Created

Viewing 15 posts - 1,306 through 1,320 (of 19,560 total)

  • RE: Help fro interview question

    meerack11 (5/20/2015)

    Hello...

    I am currently looking for job as sql developer company gives sql query to solve so can you help me where I can find real time scenario...

    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

    May 20, 2015 at 10:38 am

    #1799380

  • RE: Today's Random Word!

    Ed Wagner (5/20/2015)

    DonlSimpson (5/19/2015)

    Ed Wagner (5/19/2015)

    SQLRNNR (5/19/2015)

    Noid

    Droid

    Adenoid

    Android (not the OS)

    Android (not the Apple)

    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

    May 20, 2015 at 7:39 am

    #1799320

  • RE: Sql Job to send results

    ramana3327 (5/19/2015)

    The purpose of this job is to comparison of fragmentation before & after the the maintenance job. I am comparing two excels manually.

    Some how I don't want 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

    May 19, 2015 at 10:07 pm

    #1799225

  • RE: tsql

    Jason A. Long (5/19/2015)

    SQLRNNR (5/19/2015)

    That would be a select distinct.

    A "SELECT DISTINCT" won't do it. The INT column is unique is the original data and the same colors showing up...

    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

    May 19, 2015 at 10:04 pm

    #1799224

  • RE: tsql

    That would be a select distinct.

    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

    May 19, 2015 at 9:49 pm

    #1799220

  • RE: How to handle varying number of columns in excel ?

    Here is an example of something that has worked previously for me.

    https://dwbi1.wordpress.com/2011/03/05/ssis-importing-a-file-with-dynamic-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

    May 19, 2015 at 1:29 pm

    #1799143

  • RE: Today's Random Word!

    Noid

    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

    May 19, 2015 at 1:27 pm

    #1799142

  • RE: Contiguous time slots

    eirk tsomik (5/19/2015)

    sql 2012

    Any luck on the sample data?

    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

    May 19, 2015 at 1:27 pm

    #1799141

  • RE: Best way to Audit logins

    You can enable a server side trigger that logs every login.

    You can log both successful and unsuccessful login attempts (security tab of server properties)

    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

    May 19, 2015 at 12:43 pm

    #1799132

  • RE: Contiguous time slots

    eirk tsomik (5/19/2015)

    I have posted a sample data. The only thing I can not figure out how does the first record get in there.Because is not contiguous with any other...

    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

    May 19, 2015 at 12:11 pm

    #1799127

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/19/2015)

    "Really? You can't help me based solely on the brief description and current output of my query?"

    Why are people so reluctant to help us help them?

    Sorry, my hands...

    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

    May 19, 2015 at 12:08 pm

    #1799126

  • RE: Here are some SQL Server Interview Questions

    Brandie Tarvin (5/19/2015)

    SQLRNNR (5/19/2015)

    Eric M Russell (5/19/2015)

    But honestly, I could coach an average 12 year old how to fake their way through a SQL Server interview, if all 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

    May 19, 2015 at 11:47 am

    #1799120

  • RE: Today's Random Word!

    pity

    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

    May 19, 2015 at 11:46 am

    #1799119

  • RE: how to run a transaction accross multipale instance of sqlserver without linked server

    rajemessage 14195 (5/19/2015)

    Basically i want to run a transaction between two different instance of server,

    so that i can rollback task done at both the instances when ever i want.

    so please...

    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

    May 19, 2015 at 11:13 am

    #1799109

  • RE: Here are some SQL Server Interview Questions

    Eric M Russell (5/19/2015)

    But honestly, I could coach an average 12 year old how to fake their way through a SQL Server interview, if all it involves is knowing...

    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

    May 19, 2015 at 10:51 am

    #1799104

Viewing 15 posts - 1,306 through 1,320 (of 19,560 total)