Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
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 String.IndexOf 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 sys.certificates view 116 sys.crypt_properties view 116 sys.dm_database_encryption_keys view 137 sys.dm_db_index_operational_stats DMV 63 sys.dm_db_index_physical_stats DMV 63 sys.dm_db_index_usage_stats DMV 63 sys.dm_exec_cached_plans DMV 200 sys.dm_exec_query_stats DMV 63 sys.dm_exec_sql_text function 148 200 sys.dm_os_performance_counters DMV 43 63 sys.dm_os_wait_stats DMV 63 sys.dm_os_waiting_tasks DMV 63 sys.dm_tran_locks DMV 63 sys.spatial_reference_systems system table 292 sys.sysusers table 42 System.Data.SqlTypes .NET namespace 160161 System.DateTime 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 .