tailieunhanh - Expert SQL Server 2008 Development- P10

Tham khảo tài liệu 'expert sql server 2008 development- p10', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | INDEX STLength method 313 stored procedures advantages of 196-197 controversy over 196 for data API 18 data transactions effects on 97-98 described 196 identifying 116 optional query parameters handling 205 output characteristics 191 parameter passing 230-232 performance testing effect on 70-71 security 104 112-114 230-232 signing using certificates 114-116 static 197 STPointFromWKB method 297 street data accessing 387 STRelate function 312 stress testing 36 string encoding 395 string-handling functions 183-185 method 183-184 strong naming 177 STTouches method 294 STxxxxFromWKB method 297 su command UNIX 102 subordinate nodes 372 Subversion 237 SUSER_NAME function 109 SymKey1 key 130 symmetric keys 124 126-127 130-133 140 sysadmin role 134 view 116 view 116 view 137 DMV 63 DMV 63 DMV 63 DMV 200 DMV 63 function 148 200 DMV 43 63 DMV 63 DMV 63 DMV 63 system table 292 table 42 .NET namespace 160161 string formatting 326 T table hints 241 tables classes compared to 13-14 TDD Test-Driven Development methodology 23 196 technical limitations 294-296 tempdb database 137-138 temporal data. See also dates intervals times categories of 322 data types 322 durations 365-366 importance 321 querying 269 time zone issues 341-344 346 tessellated 313 Test-Driven Development TDD methodology 23 196 testing performance additional information 68 counters 61-62 Data Collector 65 67 DMVs 62-63 extended events 64-65 granular analysis 69 71 identifying problems 71 importance 57-58 process 68 profiling server activity 59-61 running 69-71 software benefits 58 best practices .