Viewing 15 posts - 31 through 45 (of 91 total)
AS a DBA who uses SQL 7, and SQL 2000 as well as Oracle 8i for our ERP system, I can only say that I find that there is not much...
February 17, 2004 at 4:44 am
When you have worked out what indexes you need if at all possible place them on a different disk to your datafiles, with your log files on yet another disk...
February 17, 2004 at 4:31 am
ListenOn connection '1433' is already in use..
was recorded in log.
February 3, 2004 at 4:25 am
Firstly you need a unique row identifier for each row add an identity field
SELECT *
From yourTable
WHERE Operating_System = '2000'
AND Processor_Speed >=500
AND Location <>...
June 6, 2003 at 4:59 am
I'm not sure where you are getting your list of postcodes from but could you not use DTS to import the list into a table ??
June 6, 2003 at 4:22 am
IN should only be used for short lists. It is not very efficient. Put the list of postcodes into a table and inner join to your indexed postcode column on...
June 4, 2003 at 10:47 am
Bill is right DTS is the way to go.
Very powerful, yet simple to use. Its always my first port of call for any SQL import/export issues.
June 3, 2003 at 9:01 am
Life is short, too short too worry about the pronounciation of SQL.
June 3, 2003 at 5:39 am
This should be part of your disaster recovery planning.
A database will be marked as suspect if any of the following conditions is true:
ƒÞ If one or more database files is...
June 3, 2003 at 5:06 am
Strange... but if the Differential backup is so large does it take a long time to do (longer then a full) and likewise with the restore?? If so why not...
June 3, 2003 at 4:52 am
Version control?
I've seen production servers where retrieving an older veriosn of stored proc. would mean getting the backup of the night before and recreating the database.
February 27, 2003 at 9:41 am
BE 100% sure to test sending emails with Lotus while logged on as the account that SQLServer will use to send mail before going near the actual SQL Server configuration....
February 25, 2003 at 3:56 pm
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
This is the least restrictive available. You may see locks still in Enterprise manager Management -> Current activity -> lock/process Id but that is too...
February 25, 2003 at 3:46 pm
Viewing 15 posts - 31 through 45 (of 91 total)