Viewing 15 posts - 3,376 through 3,390 (of 3,614 total)
I tend to think that software engineers are to programmers what mechanical engineers are to car mechanics.
September 11, 2003 at 4:36 am
Still doing...
September 11, 2003 at 2:01 am
I've seen an article somewhere describing how existing file systems such as FAT & NTFS are going to be replaced by databases. The argument was that the existing file...
September 10, 2003 at 1:57 am
Thanks Tom, that is a very clear description.
Does anyone know if this a generic SQL Server/Sybase issue. I see that alzdba has experienced it with SQL7 SP2 but does...
September 9, 2003 at 1:42 am
quote:
How "vast" are we talking? Hundreds/sec? thousands? Do you have any idea of peak v avg numbers?
September 8, 2003 at 10:45 am
Philip,
What you need is a good document managements system plus the internal procedures in place to use it.
Ideally the documents need version control so I would say have an official...
September 8, 2003 at 1:51 am
Yep, agree with all this but I would add documentation to the list.
The situation I am in is where the stored procedures are effectively an interface to the database layer....
September 3, 2003 at 1:30 am
If there is a new configuration change then the main thing is to test it away from potentially embarassing situations.
We got stung in the jump from 2.5 to 2.6 because...
August 22, 2003 at 1:20 am
I like the idea behind WITH UPDATEEXISTING.
I feel it needs three settings.
August 11, 2003 at 3:49 am
How are you going to cater for Rob, Bob, Robert, Robin, Bert. They could all be the same person or they could be all different.
Speaking as someone who has...
July 23, 2003 at 2:16 am
Try this instead
CREATE Procedure p_get_customerdetails
/* Param List */
@Customer_ID int,
@view Int =0 AS
Set NOCOUNT ON
/*
0 = CustMain
1 = Devices
2 = Setup
3 = trxHist
*/
IF @view = 0
BEGIN
SELECT * FROM vw_CUSTOMER...
July 23, 2003 at 2:12 am
Visual Studio has a tool called "Application Performance Explorer". I have to admit that I've never used it, but it is there.
I've heard of a tool called SQL HAMMER,...
July 11, 2003 at 2:04 am
Hans,
If you use Full Text Search facilities then you must have a primary key because SQL Server saves various status flags and other bits and bobs in the primary key.
I...
July 10, 2003 at 4:43 am
quote:
Can I host all the SQL Servers on one powerful machine under windows 2000?
Yes...
July 10, 2003 at 3:00 am
quote:
I don't understand your point? Why do you so forcefully express that your Identity column HAVE to be your primary key?
July 10, 2003 at 2:30 am
Viewing 15 posts - 3,376 through 3,390 (of 3,614 total)