Forum Replies Created

Viewing 15 posts - 601 through 615 (of 631 total)

  • RE: Scripting a column Str to format to Date time

    If this doesn't help, can you post a little more detail? Jack Corbetts sig gives a link to a good guide to the type of info that's helpful

    http://sqlblogcasts.com/blogs/jorg/default.aspx

    hth

    Andrew

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Software releases

    See http://support.microsoft.com/kb/935897

    A GDR is a general release which MS reckon should be installed - or is important enough to be installed - on any live SQL Server instance. QFE's...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Truncation of database logs

    GilaMonster (8/13/2008)


    Schadenfreude-Mei (8/13/2008)


    yeah think so. certainly they offer sunet desert camel rides etc.

    Desert camel rides in Mauritius? Dubai, I could see, but Mauritius is a small tropical island. The...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: SQL Native Client issue with varchar(max)

    It's possible that the issue is related to the fact that this version of the driver returns a default field length of zero (unlimited) for Varchar(MAX) which I think you'd...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Truncation of database logs

    now what on earth is the Disco thing sounds strange :s

    Sunderland AFC footy chant - the club's ex striker, current chairman and all round good egg Niall Quinn's song

    http://en.wikipedia.org/wiki/Niall_Quinn

    http://www.youtube.com/watch?v=SsX12TVJD3Y

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: My 3rd party softwares uses tons of cursors.

    But, there's even a way around that (and many similar problems not listed) without an explicit cursor or While loop OR UDF using a single set-based update to solve...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: My 3rd party softwares uses tons of cursors.

    Jeremy Brown (8/12/2008)


    Simply put, there's too much legacy code and legacy mindfame out there. Marketing disaster. I'd prefer some optimizer enhancements that detect cursor calls and decide on a set-based...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Truncation of database logs

    Do they have desert in Mauritious?

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: My 3rd party softwares uses tons of cursors.

    Once in v7 where I was doing some rather complex statistical work and the cursor was faster. Other than that quick and dirty DBA type rubbish looping through stuff...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Truncation of database logs

    Oh - and dawn quad bike runs through the desert have to be done if you get the chance

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Truncation of database logs

    Adam Zacks (8/12/2008)


    andrew gothard (8/11/2008)


    Andras Belokosztolszki (8/11/2008)


    Adam Zacks (8/11/2008)


    Very business oriented Gail?

    Umm - surely that's our job?

    Ummm well yes, I suppose... Depends what mood I'm in. Getting married next...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Debugger For SQL

    Well - usually in QA once it's written. Prototype in MS - then you get that sinking feeling when a colleague comes up to you baffled that someone normally...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: How to write the query results to a text file

    Hi Krish,

    have a look at SSIS - very easy to do it using that

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Debugger For SQL

    Do you think of any new features which would be helpful

    Personally - since 6.5, I've been waiting for the ability to write a view, and then, when I open it...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • RE: Logins and Users

    Hi - forgive me if I'm missing the point of what you're trying to do, but here's my understanding;

    Basically - what you're wanting to do is have a login tied...

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

Viewing 15 posts - 601 through 615 (of 631 total)