tip for db programming

[Britney]

Hi guys,

do you have any tips to share about the following works/environment I'm
involving right now?

1. performance tuning

2. high volume transaction processing

3. write & lock tuning

4. large databases

 

[TJS]

This is a news group and that's a very broad subject list

try googling those subject areas for tips

 

[clintonG]

Have you tried asking at news://microsoft.public.dotnet.framework.adonet
yet?

<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/

 

[Scott Allen]

The Patterns & Practices team at MS have put together a very good perf
and scalability guide:

Of particular interest to you would be Chapter 14 — Improving SQL
Server Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/scalenetchapt14.asp

The entire guide is free, and worth the read.