Viewing 15 posts - 3,526 through 3,540 (of 3,641 total)
There is quite a bit of disagreement here with regard to naming conventions.
We are all in agreement that a naming standard is a good thing, but there is an absence...
March 4, 2003 at 1:52 am
I notice that Microsoft haven't encrypted the build in stored procedures within SQL Server!
Ripping off the SQL code is only practical if you rip off the database schema as well.
I...
March 3, 2003 at 2:24 am
quote:
What's convenient for DBAs, VB programmers, Access developers, end-users using something like Access or Crystal Reports, PowerBuilder and Java are all different;...
February 27, 2003 at 9:54 am
It would be useful if someone could come up with a naming standard that can grow as databases evolve i.e. to take us through to SQL Server 2050, ORACLE 69i,...
February 27, 2003 at 8:50 am
Brian,
Forgive my ignorance, but what do you put an SSL certificate on a SQL box for?
February 27, 2003 at 7:08 am
I use a number of Web Content Management Systems and have seen horrendous memory leak problems in some of them.
There are one or two that use an ISAPI filter in...
February 27, 2003 at 5:38 am
Under no circumstances should you install IIS on the same box as SQL. Even in a development environment it causes problems.
You can write a web app that crashes IIS...
February 27, 2003 at 2:51 am
Firstly, use a naming convention that maximizes the readability of your code. Readability was a key learning point in the "Worst Practices - comments" series.
Secondly, using the tablename.fieldname notation...
February 24, 2003 at 7:31 am
I've set up a case-sensitive SQL Server simply because the data that had to be imported from external sources needed to retain its case sensitivity. ID fields were an...
February 24, 2003 at 7:05 am
I've got a strange problem that has occured after an SP3 install.
All my SQL Servers, including my Lap top install are at SP3. All are running fine.
If I use...
February 14, 2003 at 1:48 am
In the UK 2 Years ago a SQL DBA could look for work in the £30K - £40K region.
Being a DBA meant something.
Today a SQL DBA will probably see jobs...
February 10, 2003 at 3:30 am
I WISH!!!
The problem is that it is on a client's site and is working fine. It is a case of "if it ain't broke, don't fix it".
All(!?!) we have...
February 4, 2003 at 9:47 am
I'm not sure how they could drop support for the WHERE clause.
If they are then they would be breaking away from ANSI standard SQL and force a paradigm...
February 4, 2003 at 2:28 am
I have an issue with some legacy systems that are running MS SiteServer 3.0.
If you've ever dealt with this package you will know that you have to follow a 16...
February 4, 2003 at 2:22 am
Is there any benefit in using these sort of joins instead of using the WHERE clause?
February 3, 2003 at 3:37 am
Viewing 15 posts - 3,526 through 3,540 (of 3,641 total)