Viewing 15 posts - 3,436 through 3,450 (of 3,544 total)
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
We have a similar testing methodology but also have UAT (User Acceptance Testing). This keeps the end user involved in the system that they are going to have inflicted...
February 3, 2003 at 3:28 am
quote:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT...
January 30, 2003 at 2:35 am
Sorry for the daft question buy what is a hibernating lap-top?
To summarise the key points that have arisen due to Slammer.
Patches/Service Packs are not applied because:-
January 30, 2003 at 2:15 am
I agree with everything you said.
My issue is that the fix did not say "put this on or you will get a virus" and I am not sure that it...
January 29, 2003 at 4:12 am
The "not enough space on the C:" drive was absolutely correct.
The extraction process must bounce stuff via the TEMP directory or something.
As soon as I had cleaned up my C:\...
January 29, 2003 at 1:59 am
Actually your article highlights a need that isn't satisfied via legitemate means i.e. triggers on system tables.
Role on YUKON.
January 29, 2003 at 1:56 am
Viewing 15 posts - 3,436 through 3,450 (of 3,544 total)