Reference Material Recommendations

I'm a relatively experienced SQL Server 2000/2005 development DBA/Programmer
but I'm up for a new position involving systems that are dealing in 1000s of
user transactions a second and I don't have any experience in that area.
Does anyone have suggestions for reading I can do to familiarize myself with
the specific hot points of that type of system?
Any help is appreciated.
Thanks
RCB
These are not all 2005 specific but might be a good start:
http://www.sql-server-performance.com/sql_server_performance_audit10.asp
Performance Audit
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/operations.mspx
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
http://sqldev.net/misc/WaitTypes.htm Wait Types
Tempdb in 2005:
http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/WorkingWithTempDB.doc
Physical Database Storage:
http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/PhysDBStor.doc
Andrew J. Kelly SQL MVP
"Robert B" <RobertB@.discussions.microsoft.com> wrote in message
news:0C9E5F9D-2F7A-4495-8CE8-018E3C358B9C@.microsoft.com...
> I'm a relatively experienced SQL Server 2000/2005 development
> DBA/Programmer
> but I'm up for a new position involving systems that are dealing in 1000s
> of
> user transactions a second and I don't have any experience in that area.
> Does anyone have suggestions for reading I can do to familiarize myself
> with
> the specific hot points of that type of system?
> Any help is appreciated.
> Thanks
> RCB
|||Thanks for the list of articles, some were familiar to me some had some great
information. Does anyone else know of any articles more about the 'design'
aspects of high transaction databases?
Thanks Again

Reference Material Recommendations

I'm a relatively experienced SQL Server 2000/2005 development DBA/Programmer
but I'm up for a new position involving systems that are dealing in 1000s of
user transactions a second and I don't have any experience in that area.
Does anyone have suggestions for reading I can do to familiarize myself with
the specific hot points of that type of system?
Any help is appreciated.
Thanks
RCBThese are not all 2005 specific but might be a good start:
http://www.sql-server-performance.c...nce_audit10.asp
Performance Audit
http://www.microsoft.com/technet/pr...perfmonitor.asp Perfmon counters
http://www.sql-server-performance.c...mance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.c...rmance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/d.../>
on_24u1.asp
Disk Monitoring
http://sqldev.net/misc/WaitTypes.htm Wait Types
Tempdb in 2005:
http://download.microsoft.com/downl...gWithTempDB.doc
Physical Database Storage:
http://download.microsoft.com/downl...
PhysDBStor.doc
Andrew J. Kelly SQL MVP
"Robert B" <RobertB@.discussions.microsoft.com> wrote in message
news:0C9E5F9D-2F7A-4495-8CE8-018E3C358B9C@.microsoft.com...
> I'm a relatively experienced SQL Server 2000/2005 development
> DBA/Programmer
> but I'm up for a new position involving systems that are dealing in 1000s
> of
> user transactions a second and I don't have any experience in that area.
> Does anyone have suggestions for reading I can do to familiarize myself
> with
> the specific hot points of that type of system?
> Any help is appreciated.
> Thanks
> RCB|||Thanks for the list of articles, some were familiar to me some had some grea
t
information. Does anyone else know of any articles more about the 'design'
aspects of high transaction databases?
Thanks Again

Reference Material Recommendations

I'm a relatively experienced SQL Server 2000/2005 development DBA/Programmer
but I'm up for a new position involving systems that are dealing in 1000s of
user transactions a second and I don't have any experience in that area.
Does anyone have suggestions for reading I can do to familiarize myself with
the specific hot points of that type of system?
Any help is appreciated.
Thanks
RCBThese are not all 2005 specific but might be a good start:
http://www.sql-server-performance.com/sql_server_performance_audit10.asp
Performance Audit
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/operations.mspx
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
http://sqldev.net/misc/WaitTypes.htm Wait Types
Tempdb in 2005:
http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/WorkingWithTempDB.doc
Physical Database Storage:
http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/PhysDBStor.doc
Andrew J. Kelly SQL MVP
"Robert B" <RobertB@.discussions.microsoft.com> wrote in message
news:0C9E5F9D-2F7A-4495-8CE8-018E3C358B9C@.microsoft.com...
> I'm a relatively experienced SQL Server 2000/2005 development
> DBA/Programmer
> but I'm up for a new position involving systems that are dealing in 1000s
> of
> user transactions a second and I don't have any experience in that area.
> Does anyone have suggestions for reading I can do to familiarize myself
> with
> the specific hot points of that type of system?
> Any help is appreciated.
> Thanks
> RCB|||Thanks for the list of articles, some were familiar to me some had some great
information. Does anyone else know of any articles more about the 'design'
aspects of high transaction databases?
Thanks Again

refence a field by column position

Is it possible to reference a field from its position in the column as opposed to its name?

=Fields!Ownership.Value maybe something like =Fields(2).value this doesn't work however, but is there a way.

Not sure why you'd need to do this...What are you trying to accomplish? Maybe there is a workaround. Something like, you want to use the same table with 2 different queries that produce different column names?