Forum Replies Created

Viewing 15 posts - 1 through 15 (of 39 total)

  • RE: Question of the Day for 25 Mar 2004

    The configuration screens in SQL 2000 allow the secondary database to setup in Standby mode, which allows read-only access.  If the secondary database is being accessed when the restore is...


    Larry Ansley
    Atlanta, GA

    March 25, 2004 at 5:57 am

    #500407

  • RE: Dump SQL Permissions

    Well, I've been looking for a reason and an opportunity to familiarize myself a little on DMO.  This seems like a useful tool that I can employ on a current project, so...


    Larry Ansley
    Atlanta, GA

    March 17, 2004 at 8:12 am

    #499121

  • RE: QOD Suggestion

    Makes sense. OK with me.

    Larry Ansley

    Atlanta, GA


    Larry Ansley
    Atlanta, GA

    December 17, 2003 at 8:23 am

    #486685

  • RE: Two Best Practices!

    I second the recommendation on using ANSI joins. It's much clearer.

    However, it's important to remember that for outer joins the results may not be the same between...


    Larry Ansley
    Atlanta, GA

    December 17, 2003 at 8:17 am

    #486682

  • RE: QOD 12/17/03

    I'm confused. How can someone have a fulltime job and a family life. My former boss would never allow such a distraction.

    Larry...


    Larry Ansley
    Atlanta, GA

    December 17, 2003 at 7:48 am

    #486665

  • RE: QOD 12/10/2003

    syslogins used to be the table. I think it became a view on the sysxlogins table for SQL 2000, but maybe SQL 7.

    Larry Ansley

    Atlanta, GA


    Larry Ansley
    Atlanta, GA

    December 11, 2003 at 5:17 am

    #485682

  • RE: QOD 11/25

    quote:

    I've never actually done ANY IO tuning so extent size to me is irrelevant.

    I'm...


    Larry Ansley
    Atlanta, GA

    December 2, 2003 at 5:05 am

    #484238

  • RE: QOD 11/25

    quote:

    As for Larry:

    If you answer before doing research, are you doing it after answering (wrong or right)?


    Larry Ansley
    Atlanta, GA

    November 26, 2003 at 6:03 am

    #483709

  • RE: QOD 11/25

    Gee. What's the point of answering after you look it up? Everyone should get 100% that way. If there is a question I can't answer after research,...


    Larry Ansley
    Atlanta, GA

    November 25, 2003 at 6:28 pm

    #483644

  • RE: QOD 11/21

    quote:

    I think it is important to remember that the QOD has to be very simple in nature.

    I can not imagine...


    Larry Ansley
    Atlanta, GA

    November 24, 2003 at 2:03 pm

    #483450

  • RE: QOD 11/21

    quote:

    I think i misunderstand the clustered index!

    I have a table with the following structure

    CREATE TABLE [Tb_Amz_UnitChange81] (

    [Fd_Ucg_Term] [char] (8) ,

    [Fd_Ucg_Regno] [int]...


    Larry Ansley
    Atlanta, GA

    November 24, 2003 at 10:38 am

    #483417

  • RE: QOD 11/21

    quote:

    If the data page at the new location is too full to accept the record, it must be spit.


    Larry Ansley
    Atlanta, GA

    November 21, 2003 at 1:00 pm

    #483216

  • RE: QOD 11/21

    quote:

    So... let me get this straight. No clustered indexes on tables that receive updates?

    Not...


    Larry Ansley
    Atlanta, GA

    November 21, 2003 at 12:57 pm

    #483214

  • RE: QOD 11/21

    quote:

    What I wanted to say is that you cannot assume that the LAST_ORDER_DT column actually is going to contain the last date...


    Larry Ansley
    Atlanta, GA

    November 21, 2003 at 7:45 am

    #483090

  • RE: QOD 11/21

    Oops! Kelvin said "non-clustered" index. You are right. A non-clustered index isn't always used, but this one may be selective enough to be used for a result...


    Larry Ansley
    Atlanta, GA

    November 21, 2003 at 6:18 am

    #483064

    • Viewing 15 posts - 1 through 15 (of 39 total)