Expert SQL Server 2008 Development- P10

Chia sẻ: Thanh Cong | Ngày: | Loại File: PDF | Số trang:4

Thêm vào BST

Báo xấu

74
lượt xem 11
download

Download Vui lòng tải xuống để xem tài liệu đầy đủ

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ả

Chủ đề:

Bình luận(0) Đăng nhập để gửi bình luận!

Lưu

Nội dung Text: Expert SQL Server 2008 Development- P10

INDEX STLength( ) method, 313 stored procedures T advantages of, 196–197 table hints, 241 controversy over, 196 tables, classes compared to, 13–14 for data API, 18 TDD (Test-Driven Development) methodology, data transactions, effects on, 97–98 23, 196 described, 196 technical limitations, 294–296 identifying, 116 tempdb database, 137–138 optional query parameters, handling, 205 temporal data. See also dates; intervals; times output characteristics, 191 categories of, 322 parameter passing, 230–232 data types, 322 performance testing, effect on, 70–71 durations, 365–366 security, 104, 112–114, 230–232 importance, 321 signing using certificates, 114–116 querying, 269 static, 197 time zone issues, 341–344, 346 STPointFromWKB( ) method, 297 tessellated, 313 street data, accessing, 387 Test-Driven Development (TDD) methodology, STRelate( ) function, 312 23, 196 stress testing, 36 testing string encoding, 395 performance string-handling functions, 183–185 additional information, 68 String.IndexOf( ) method, 183–184 counters, 61–62 strong naming, 177 Data Collector, 65, 67 STTouches( ) method, 294 DMVs, 62–63 STxxxxFromWKB( ) method, 297 extended events, 64–65 su command, UNIX, 102 granular analysis, 69, 71 subordinate nodes, 372 identifying problems, 71 Subversion, 237 importance, 57–58 SUSER_NAME function, 109 process, 68 SymKey1 key, 130 profiling server activity, 59–61 symmetric keys, 124, 126–127, 130–133, 140 running, 69–71 sysadmin role, 134 software sys.certificates view, 116 benefits, 58 sys.crypt_properties view, 116 best practices, 36–39 sys.dm_database_encryption_keys view, 137 databases, shortage of, 49 sys.dm_db_index_operational_stats DMV, 63 reasons for, 56 sys.dm_db_index_physical_stats DMV, 63 stored procedures and, 196 sys.dm_db_index_usage_stats DMV, 63 techniques for, 55–56 sys.dm_exec_cached_plans DMV, 200 testability, 20–21 sys.dm_exec_query_stats DMV, 63 timing, 55 sys.dm_exec_sql_text function, 148, 200 types of, 49–52, 55–58 sys.dm_os_performance_counters DMV, 43, 63 volume of tests needed, 57–58 sys.dm_os_wait_stats DMV, 63 thumbprint, certificate. See certificates sys.dm_os_waiting_tasks DMV, 63 TIGER/Line data, 387 sys.dm_tran_locks DMV, 63 time datatype, 323 sys.spatial_reference_systems system table, 292 time zones, effects on data, 341–344, 346 sys.sysusers table, 42 time-based data. See temporal data System.Data.SqlTypes .NET namespace, 160– times. See also calendar tables 161 calculations on, 329, 331–336 System.DateTime string formatting, 326 constraining, 347 431
INDEX times (cont.) Universel Temps Coordonné (UTC), 341–344 default, 324 UNSAFE permission set, 163 input formats, 323–324 UPDATE statement, 152 querying, 326–329, 337–341, 362, 364–365 UPDATE trigger, 31 ToString method, 326 updateable cursors, 243 touching, 294 updates, causing cycles, 405 tracing SQL Server exceptions, 85 US geographical data, accessing, 387 transactional locks, 250 User Error Message events, 85 transactions user interface data, 12 doomed, 100 USER_NAME function, 109 exceptions and, 96–99 user-defined functions (UDFs), 191 rolling back, 96–100 users stored procedures and, 97–98 creating, 103–104 transparent data encryption, 136–139 defined, 103 trees impersonating, 102–104, 107–110 defined, 372 proxy, 114 overview, 371 use of, 103–104 triggers, 266 UTC (Universel Temps Coordonné), 341–344 Triple DES, 130 UTM (Universal Transverse Mercator) grid trustworthy databases coordinates, 290, 292 marking, 175 security ramifications, 175 turning off, 175 V try block, defined, 87 valid time component, 322 try/catch exception handling, 87–92, 100 validating input, 40–42 T-SQL, versus SQLCLR, 178–184 varchar datatype, 34 T-SQL function, 40, 137 varchar type, 34 T-SQL stored procedures, 6 Visual SourceSafe, 237 TSQLUnit unit testing framework, 52 Visual Studio Team System 2008, 69 two-part naming, 105 U W WAITFOR command, 252 UDFs (user-defined functions), 191 warnings, 79, 85 undirected edges, 371 web services, 18 undirected graphs, 372 Well-Known Binary (WKB) format, 296–297 unexpected behavior, 45 Well-Known Text (WKT) format, 290, 296–297 UNION ALL query, 303 white box testing, 49–50, 52 UNION query, 36, 303 wildcard searches with HMAC substrings, 153– unit testing 157 advantages of, 54 WindowsIdentity class, 102 limits of, 51 WITH TIES argument, 308 uses of, 50, 55 WKB (Well-Known Binary) format, 296–297 unit testing frameworks WKT (Well-Known Text) format, 290, 296–297 advantages of, 52 wrapper methods/classes debug assertions, 52 advantages of, 161, 163 tips for using, 52–54 example of, 162–163 variety, 52 uses for, 161, 163 Universal Transverse Mercator (UTM) grid Writes column, 59 coordinates, 290, 292 432
INDEX X XML serialization, 185–186 XP (extreme programming), 23, 55 x coordinate, 312 XACT_ABORT setting, 77–78, 98–99 XACT_STATE function, 100 Y XandY table, 37, 39 y coordinate, 312 XML format documents, 185, 263 433