Viewing 15 posts - 46 through 60 (of 158 total)
That is what they started with but they had locking and blocking issues while updating that one nextnum table to obtain the next key value.
I think I was unclear.
I am...
March 1, 2011 at 8:36 am
That's a fairly nice solution to the problem, however...(There's always a but...)
The biggest problem I see with your approach is that when someone wants to add a new key-value pair...
February 28, 2011 at 2:48 pm
My three worst qualities as it pertains to work are:
I think this is the point of the dispute with GSquared. The question as normally asked is not qualified with...
February 28, 2011 at 2:18 pm
The weirdest question I've ever been asked in an interview is: "If you were on a magazine cover what would the magazine be and what would the headline be?"
I...
February 25, 2011 at 10:12 am
The problem with metrics is that most company's simply don't have an official standard. Ask ten different managers (in the same department) to examine a piece of code, and you'll...
February 21, 2011 at 8:36 am
Most of these rules successfully separate gawdawfull code from adequate code. Separating adequate code from good or great code is a lot more difficult.
Separating good from great code is...
February 21, 2011 at 7:56 am
The added complexity is because my procedure always adjusts the sequence number so that it is continuous and zero based.
James,
While it is true that your routine does this, it...
February 7, 2011 at 2:27 pm
That seems quite a bit more complicated than this:
CREATE PROCEDURE [dbo].[setTodoSequence]
(
@personID int,
@todoID as int,
@todoSequence as smallint
)
AS
SET NOCOUNT ON;
declare @oldTodoSequence smallint
declare @direction smallint
declare @start smallint
declare @end smallint
-- get the old sequence
set...
February 7, 2011 at 8:50 am
I'm uncomfortable with this solution. It seems to be a bit too esoteric/arcane for my tastes. My solution is to have a couple of small tables that handle...
November 30, 2010 at 2:59 pm
I really don't like the WHILE loop in there.
I use this code, (which may or may not be from Jeff Moden) which requires a table of numbers from 1 to...
November 30, 2010 at 7:20 am
No one else is going to know the addresses for members of my family (or people I come in contact with).
Except, of course, members of your family.
--
JimFive
November 22, 2010 at 12:23 pm
The arguments for and against deterministic Biometric fingerprint analysis, retinal scans, etc. vs immutable password hashing all sound totally ridiculous because there is no one method that is proportionally better...
November 10, 2010 at 8:30 am
Fingerprint security on a laptop is relative to the value of whatever data is on the laptop. It is perfect security for a laptop that contains nothing of significant value...
November 9, 2010 at 12:05 pm
Steve,
Re: Fingerprint reader
How many copies of your fingerprints do you think exist on your laptop (Case, screen, keyboard) at any given time?
How hard do you think it would be for...
November 9, 2010 at 9:38 am
Correct me if I'm wrong, but in simple recovery mode, doing a full backup will checkpoint the log file and allow for re-use. Is there anything else that would...
November 9, 2010 at 8:26 am
Viewing 15 posts - 46 through 60 (of 158 total)