Viewing 15 posts - 3,571 through 3,585 (of 3,603 total)
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?
July 1, 2002 at 1:45 am
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.
June 10, 2002 at 3:21 am
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...
June 7, 2002 at 1:10 pm
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"....
June 6, 2002 at 3:06 am
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...
May 27, 2002 at 7:13 am
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...
May 24, 2002 at 10:52 am
.....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...
May 23, 2002 at 2:01 am
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...
April 4, 2002 at 12:51 am
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...
March 28, 2002 at 9:58 am
quote:
In our environment, we capture and process millions of transactions per day. We increased throughput on these intense inserts (15%) by...
March 28, 2002 at 1:27 am
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...
March 25, 2002 at 2:53 am
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...
March 21, 2002 at 4:43 am
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...
February 25, 2002 at 2:13 am
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...
February 4, 2002 at 5:34 am
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...
February 4, 2002 at 2:11 am
Viewing 15 posts - 3,571 through 3,585 (of 3,603 total)