Forum Replies Created

Viewing 15 posts - 916 through 930 (of 984 total)

  • RE: Date formats

    Are all users set to the right language / date formats on the servers? eg are the users set to "British English" on one server, but "English" (which defaults...

    September 23, 2003 at 8:57 am

    #475438

  • RE: Net Send Message

    quote:

    Is there a way to send a NetSend message within a SQL Task?

    September 23, 2003 at 8:52 am

    #475435

  • RE: Language & Date format

    For input routines, I try to persuade developers to use (in VB)

    

    format(dMyDate, "dd mmm yyyy")

    which puts a three-letter month in, which is unambiguous. Hurrah!

    Of course,...

    September 23, 2003 at 8:50 am

    #475434

  • RE: Pet Peeves

    quote:

    A DBA needs to be aware of the fact that the liver is evil and deserves regular doses of punishment.

    September 23, 2003 at 8:37 am

    #475432

  • RE: Pet Peeves

    quote:

    Don't they have alcohol in UK?

    Not enough to get rid of the pain.

    September 23, 2003 at 8:27 am

    #475428

  • RE: SQL Server 6.5 Maximum Device Size

    quote:

    Yikes, I'd check the BOL for 6.5. I suspect this is in the terabyte range though. I thought I had a 100GB...

    September 23, 2003 at 1:32 am

    #475355

  • RE: SqlServerCentral.com... The Book?

    quote:

    Frank - I'd say an honest 4-6 weeks. Incredbile that in 2003 anything can take that long, but I sent several books...

    September 22, 2003 at 1:52 am

    #475204

  • RE: xp_cmdshell not found

    quote:

    Haven't seen one, but it would be useful. Hopefully another reader has it!

    Try this:

    September 18, 2003 at 1:34 am

    #474813

  • RE: OLAP and MS SQL on the same machine...

    I assume that by "MS SQL-Server" you mean an OLTP system?

    The http://www.sql-server-performance.com site has some useful tips here, mainly around avoiding OLAP and OLTP sharing a database.

    It used to be...

    September 17, 2003 at 1:45 am

    #474569

  • RE: Sending Attachments by mail thru a SQL Job

    quote:

    We have configured a SMTP client in the SQL Server system and created a profile that SQL server should use to send...

    September 16, 2003 at 1:44 am

    #474317

  • RE: Pet Peeves

    quote:

    quote:

    Try 400+ users but no full-time admins... One chap who does network admin...

    September 15, 2003 at 8:40 am

    #474200

  • RE: Pet Peeves

    quote:

    Head of IT department who thinks he can run network AND database administration for some 500 users with only 2 full time...

    September 15, 2003 at 8:36 am

    #474198

  • RE: Pet Peeves

    quote:

    Managers who think I am a f*****g fireman.

    I didn't know you worked here!

    September 15, 2003 at 8:22 am

    #474192

  • RE: Query takes too long time

    How much data is in the "billable_transactions" table? And how much data is returned by the query?

    I seem to recall there are some locking issues with selecting into dynamically-created...

    September 15, 2003 at 2:02 am

    #474134

  • RE: Pet Peeves

    quote:

    Developers who let management decide the milestone dates and don't tell them they are cray and give a better assesment.

    September 15, 2003 at 1:51 am

    #474131

Viewing 15 posts - 916 through 930 (of 984 total)