Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arunsqladmin
Yak Posting Veteran
74 Posts |
Posted - 2007-12-18 : 05:12:03
|
| where can we get to know the architecture of sqlserver 2005 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-18 : 05:23:56
|
In what aspect?System tables? Internal assembler instructions? E 12°55'05.25"N 56°04'39.16" |
 |
|
|
arunsqladmin
Yak Posting Veteran
74 Posts |
Posted - 2007-12-18 : 05:56:02
|
| regarding how a transaction takes place,what are the different kinds of files processed,the buffer transactions |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-18 : 06:45:30
|
Have you read Books Online, the SQL Server help file? E 12°55'05.25"N 56°04'39.16" |
 |
|
|
sqlsquirrel
Starting Member
21 Posts |
Posted - 2007-12-18 : 14:32:14
|
| There are several places to look for this type of information. A really good book that I bought and reference quite a bit is "Inside Microsoft SQL Server 2005 - Query Tuning and Optimization". This book covers the properties of a transaction like ACID, Isolation levels and also goes into how transactions are handled, etc.I also like to suggest to look at the topic of "What's new in SQL Server 2005"... Microsoft generally has a good architecture overview.I hope this helps!Brett DavisSenior SQL Server DBAFor more helpful tips checkout my blog at: http://www.lockergnome.com/sqlsquirrel/ |
 |
|
|
|
|
|