Forum Replies Created

Viewing 15 posts - 2,341 through 2,355 (of 19,560 total)

  • RE: Receiving Error 1944 when Rebuilding an index

    millerrich (8/7/2014)

    i've run into a similar problem, and after some experimentation have boiled it down to a simple example that reproduces the error, which seems to occur when 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

    August 7, 2014 at 11:41 am

    #1736122

  • RE: How to access SQL server 2012 in DMZ

    How you connect will depend on your DMZ and firewall configuration. They may have the firewalls configured to allow traffic between the two on the internal network.

    Check with your...

    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

    August 7, 2014 at 11:27 am

    #1736114

  • RE: Are the posted questions getting worse?

    Sean Lange (8/7/2014)

    SQLRNNR (8/7/2014)

    Jack Corbett (8/7/2014)

    Lynn Pettis (8/7/2014)

    SQLRNNR (8/7/2014)

    Lynn Pettis (8/7/2014)

    Now this just pissed me off:

    ********* (8/7/2014)

    thanks lynn, for being forthcoming (finally!)

    Leaving out the name of 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

    August 7, 2014 at 11:24 am

    #1736113

  • RE: Today's Random Word!

    djj (8/7/2014)

    SQLRNNR (8/7/2014)

    springs

    bed

    squeak

    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

    August 7, 2014 at 11:14 am

    #1736107

  • RE: Are the posted questions getting worse?

    Jack Corbett (8/7/2014)

    Lynn Pettis (8/7/2014)

    SQLRNNR (8/7/2014)

    Lynn Pettis (8/7/2014)

    Now this just pissed me off:

    ********* (8/7/2014)

    thanks lynn, for being forthcoming (finally!)

    Leaving out the name of the perp.

    Haha - too...

    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

    August 7, 2014 at 11:11 am

    #1736106

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/7/2014)

    Now this just pissed me off:

    ********* (8/7/2014)

    thanks lynn, for being forthcoming (finally!)

    Leaving out the name of the perp.

    Haha - too easy to find. :crazy:

    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

    August 7, 2014 at 10:33 am

    #1736083

  • RE: simple division

    KoldCoffee (8/7/2014)

    too late, I figured it out. Each number has to be divided seperately.

    select cast(18 as float)/cast(19 as float);

    select convert(decimal(5,2),18)/convert(decimal(5,2), 19);

    Spare me the long winding road to nowhere

    FWIW...

    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

    August 7, 2014 at 10:33 am

    #1736082

  • RE: SQL DBA high ended question (5+ years’ experience)

    Sean Lange (8/7/2014)

    SQLRNNR (8/7/2014)

    sqldriver (8/7/2014)

    Oh, you guys thought I was kidding. Heh.

    No. I have quite literally run into that type of thing. Both as you described and as...

    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

    August 7, 2014 at 10:15 am

    #1736076

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/7/2014)

    After working with SQL Server for 4 years you'd expect someone to know why SELECT 18/94 returns zero.

    Just down right scary!

    But it doesn't return 0. I get...

    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

    August 7, 2014 at 10:14 am

    #1736074

  • RE: SQL DBA high ended question (5+ years’ experience)

    sqldriver (8/7/2014)

    Oh, you guys thought I was kidding. Heh.

    No. I have quite literally run into that type of thing. Both as you described and as I described.

    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

    August 7, 2014 at 9:29 am

    #1736046

  • RE: TDE and Issue described in KB2963658

    I am using TDE without those issues.

    For the most part TDE is working well enough.

    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

    August 7, 2014 at 9:19 am

    #1736038

  • RE: SQL DBA high ended question (5+ years’ experience)

    sqldriver (8/7/2014)

    Eirikur Eiriksson (8/6/2014)

    Jeff Moden (8/5/2014)

    rajeshn29.dba (8/5/2014)

    Hi Friends,

    I would like to know SQL DBA high ended question (5+ years’ experience) what kind of questions they will ASK …………………. Just for...

    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

    August 7, 2014 at 9:16 am

    #1736036

  • RE: Today's Random Word!

    springs

    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

    August 7, 2014 at 9:14 am

    #1736033

  • RE: TDE (SQL2008R2) in a production environment?

    To be fair, this client is running about 1.5TB worth of databases in TDE. The impact is felt in about a 10% rise in cpu, and a 20x increase...

    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

    August 7, 2014 at 8:48 am

    #1736014

  • RE: TDE (SQL2008R2) in a production environment?

    I have a client that has TDE enabled for all databases on specific production servers. There is a fair amount of overhead with that.

    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

    August 7, 2014 at 8:28 am

    #1736000

Viewing 15 posts - 2,341 through 2,355 (of 19,560 total)