Viewing 15 posts - 3,466 through 3,480 (of 3,614 total)
quote:
Not happy with Sybase? Curiosity impels me to ask, why not?
It's more of a...
May 14, 2003 at 9:50 am
Looking through the Wrox Press Book "Beginning PHP4 Databases" the comments that it makes on MySQL and PostGres are
MySQL
May 14, 2003 at 4:35 am
Thanks for this.
I notice that the _WA_SYS stats count towards the 255 indices allowed on a table.
There is an db option to autocreate these stats which defaults to "ON" as...
May 13, 2003 at 9:24 am
I've seen the military approach.
I've heard a story about NASA spending millions to develop a pen that would write in space. The Russians provided their cosmonauts with pencils.
The military...
May 13, 2003 at 7:53 am
Are you the system administrator?
Get the system administrator to create a copy of that user explicitly for testing.
As I said, this is a long winded approach. Use EM to...
May 13, 2003 at 6:18 am
I think alot depends on the size of your organisation and the culture.
In a small to medium organisation it is possible to get to know most of the developers. ...
May 13, 2003 at 6:15 am
If you are using Windows Authentication then you have to log in as that user.
If you are using SQL Authentication then Open SQL Query Analyser and connect to your database...
May 13, 2003 at 5:58 am
Don't forget the licensing issues!
If your database is serving and internet/extranet/intranet then you will be using per processor licensing hence doubling your costs.
What about single point of failure principles? ...
May 13, 2003 at 2:19 am
I simply don't trust back-ups.
The only problem I have with differential back-ups is what happens if one of your backups corrupts?
OK, I know that 99 out of 100 times this...
May 6, 2003 at 4:06 am
I use Source Safe to store the scripts for all my objects. As the scripts are simply text files this causes no problems.
In terms of debugging SQL I tend...
April 25, 2003 at 2:09 am
I experimented with query hints on tables because I had a large batch job that is only run when no-one else is on the box.
The original query showed up a...
April 24, 2003 at 8:25 am
You would be better off finding what it is that causes the locks and modifying the stored procedures accordingly.
In addition to the points raised by Chris Cubley I should like...
April 24, 2003 at 4:18 am
As far as optional arguments/parameters is concerned, if there are a large number of them then I switch to using ORs simply because writing a SQL stored procedure that produces...
April 23, 2003 at 2:04 am
I would suggest that this is a documentation issue and development practices issue.
Unfortunately, once an organisation grows beyond a certain point formal documentation and methodologies become a necessity rather than...
April 22, 2003 at 7:08 am
Viewing 15 posts - 3,466 through 3,480 (of 3,614 total)