Viewing 15 posts - 91 through 105 (of 128 total)
DTS is the best way to go. The export to Excel is very easy. The updating is a bit harder, but a simple solution would be to have DTS import...
February 25, 2005 at 1:54 am
Best guess is lack of indexes on the join columns and now SQL has created statistical indexes for these and the joins are now using them.
February 25, 2005 at 1:39 am
Are you using integrated security or standard. I am assuming standard. If so then change the security mode to mixed (this can be done via the registry - it has...
February 25, 2005 at 1:37 am
Are you going to be storing any information in double byte languages - Chinese, Japanese etc. If so then these columns should be 'n'. If not and there is no...
February 25, 2005 at 1:33 am
What is in syservers ?- usually it is best to do an sp_dropserver and an sp_addserver (with the local option).
Hope this helps.
February 25, 2005 at 1:29 am
The system statistical indexes are usuallya good starting point for potential additional indexes. See what SQL has created and these may indicate that the database in uder indexed.
Tables without clustered...
February 25, 2005 at 1:26 am
Hi Brian (are you the real famous SQL Brian Moran?).
First thing to check - Is the database column nchar or nvharchar. Then how are you trying to do the insert...
February 23, 2005 at 3:53 am
Other advantages of instances
- better security not using the deafulat TCP port
- each instance has its own tempdb
- plus you can have MSDE instances (with its limitations eg 2GB database...
February 23, 2005 at 3:45 am
Back to basics - is the MS DTC service running and what account is it running under?
AT
February 21, 2005 at 3:20 am
hi Richard,
Basic security concepts that will help you secure your server quickly - disable all network protocols that are not required. If using TCP change the port from 1433 -...
February 21, 2005 at 3:17 am
That should be all you need - good problem solving of your own problem. I usually make it easy and allow the service account more access by putting in the...
February 21, 2005 at 3:12 am
You may want to set the TCP port fo each instance you create. This gives more control over the connection parameters. Also ther is alimit of how many instances you...
February 18, 2005 at 5:16 am
Processors - 4 (min 2)
RAM - 4GB (min 2)
NIC's - min 100 Mb, prefer Gig - teamed NICs
RAID contollers - min 2 eliminate SPOF (the more the better)
Disks - OS...
February 18, 2005 at 5:12 am
Have look at the system statistical indexes, they may be a clue to aditional indexes being needed.
What is the fillfactor and pad index %'s.
February 18, 2005 at 5:02 am
Linda,
Second thought - what about differential or incremental backups to keep the data transfer minimal. Obviously have to be a manual process.
AT
February 18, 2005 at 4:51 am
Viewing 15 posts - 91 through 105 (of 128 total)