Viewing 15 posts - 3,451 through 3,465 (of 3,559 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,451 through 3,465 (of 3,559 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy