Forum Replies Created

Viewing 15 posts - 3,571 through 3,585 (of 3,603 total)

  • RE: Coding Standards Part 2 - Formatting

    Yes, good ideas here.

    Anything that makes old code easy to read gets my vote.

    Has anyone used sp_addextendedproperty to help comment objects within your databases?

  • RE: Problems changing sa password

    Thanks Andy,

    Using the -SubscriberLogin [mylogin] -SubscriberPassword [mypassword]in the distributor agent sorted it.

    I don't know why it didn't work before, but it works OK now.

  • RE: Problems changing sa password

    I've been having similar problems with replication since changing the SA password.

    I changed the password on both the Publisher/Distributor and on the Subscriber.

    Both have exactly the same password.

    The Distributor job...

  • RE: Results of MCDBA Survey

    The results are very US biased.

    In the UK there are a lot of jobs advertised for DBA's and one of the questions employers ask is "Can you do stored procedures"....

  • RE: Reminiscing

    Warm and Fuzzy!!!!!

    That describes sales pitches and user specs.

    It gives me a warm glow to remember that there is only so much to cock up in 256Kb RAM or a...

  • RE: Reminiscing

    The Commodore Pet predates the VIC20 by several years.

    There is an original in the London Science Museum. I saw my 1st Pet in 1980 but I think it harks...

  • RE: Reminiscing

    .....and still have change from a ha'penny.

    I started out my database work using a Commodore Pet, 6502 machine code and the original Commodore disk drive so I guess I pre-date...

  • RE: Tame Those Strings - Part 9

    I found that if I create a stored procedure as follows

    CREATE PROC usp_SetName @sName VARCHAR(50)

    AS

    SET NOCOUNT ON

    SET QUOTED_IDENTIFIER OFF

    INSERT Tbl_Name (Name)

    VALUES (@sName)

    GO

    Then executing the stored proc

    exec usp_SetName "O'Reilly" gets...

  • RE: Non-Continous Replicaton and The LogReader

    Years ago I was told that Microsoft set up a Publisher on one side of the Atlantic and the Distributor/Subscriber at the other.

    When they got their first phone bill it...

  • RE: Worst Practices - Not Using Primary Keys and Clustered Indexes

    quote:


    In our environment, we capture and process millions of transactions per day. We increased throughput on these intense inserts (15%) by...

  • RE: Worst Practices - Not Using Primary Keys and Clustered Indexes

    I would regard having a compound primary key as terrible practice.

    By all means have a unique key on it, but the primary key?

    I have a situation where we have an...

  • RE: You just might be a DBA if.....

    You were the last person consulted on a database issue and got so pissed off you resigned.

    6 months later you see your old job advertised at twice the salary.

    Scott Adams...

  • RE: Is 0% Downtime Possible?

    The problem is that management believes in 0% downtime. Fortunately, they have 50% downtime so its not too hard to sync downtime where they won't notice.

    The worst case...

  • RE: Uses For Derived Tables

    The only down side I have found with derived tables is that they are memory intensive.

    This becomes an issue if you have an application that runs complicated queries for a...

  • RE: Worst Practices - Depending on the GUI

    The great thing about scripting is that you are creating documentation for your database.

    I also find that a well laid out script is useful teaching aid for educating wannabe developers.

    When...

Viewing 15 posts - 3,571 through 3,585 (of 3,603 total)