Viewing 15 posts - 5,626 through 5,640 (of 6,022 total)
Steve Jones - SSC Editor (4/12/2011)
Eric M Russell (4/12/2011)
April 12, 2011 at 9:19 am
In any database that I have ownersip of, I typically grant application accounts authorization by adding them as members of a single role, and that role grants them only EXEC...
April 12, 2011 at 7:50 am
David.Poole (4/11/2011)
April 11, 2011 at 3:42 pm
Gift Peddie (4/11/2011)
Eric M Russell (4/11/2011)
Gift Peddie (4/11/2011)
Eric M Russell (4/11/2011)
Aaron N. Cutshall (4/11/2011)
April 11, 2011 at 10:58 am
Gift Peddie (4/11/2011)
Eric M Russell (4/11/2011)
Aaron N. Cutshall (4/11/2011)
April 11, 2011 at 9:38 am
Years ago, I read an article about experiments with web scent devices. Just like audio, it would basically be a device that sits on your desktop and contains chemicals for...
April 11, 2011 at 9:14 am
Aaron N. Cutshall (4/11/2011)
April 11, 2011 at 8:36 am
Once a smart team of engineers create a really practical piece of technology, it's inevitable that the consumer marketing industry will come along behind them, FUBAR the technology, and then...
April 11, 2011 at 8:03 am
Aaron N. Cutshall (4/11/2011)
nick.mcdermaid (4/11/2011)
And yes unfortunately the Oracle client is a hideously bloated thing that needs to be installed.
I couldn't agree with you more! That sucker is HUGE...
April 11, 2011 at 7:44 am
If I need to generate a unique sequential integer IDs for transactional records (for example sale_id or customer_id), then I'll use an identity. I call that an instance ID. However,...
April 8, 2011 at 12:05 pm
Martin Mason (4/7/2011)
magarity kerns (4/7/2011)
April 7, 2011 at 12:41 pm
There are a series of canned questions that should always be asked upfront, and these should be documented in the requirements. However, I also find it essential to ask the...
April 7, 2011 at 10:05 am
Brandie Tarvin (4/6/2011)
Now that's a clever solution. I like the use of Rank, Partition, and Right there.
One caveat to using the ranking method is that each row is ranked dynamically...
April 6, 2011 at 7:50 am
DMS11X (4/4/2011)
Can someone mark this thread as solved? So if anyone else needs help...
Looking at your sample resultset above, it seems to me that the column SequenceNumber is derived...
April 5, 2011 at 4:30 pm
Well, the good news is that you've got your work cut out for you and don't need to worry about getting laid off anytime soon.
In most large proprietary databases...
April 5, 2011 at 2:24 pm
Viewing 15 posts - 5,626 through 5,640 (of 6,022 total)