SQL Server MVP Deep Dives- P22: Each year Microsoft invites all the MVPs from every technology and country to Redmond for an MVP Summit—all top secret—“don’t tweet what you see!” During the MVP Summit, each product team holds a series of presentations where they explain their technologies, share their vision, and listen to some honest feedback. | 794 INDEX SQL Server 2005 continued Enterprise Edition 421 452 460 Express 465 execution plans 426 indexes 399 maintenance cleanup task 340 merge replication 482 Mobile Edition 302 new XML features 133 noise words 189 OLTP database 459 piecemeal restore 446 replication 475 replication defaults 478 replication techniques 483 Reporting Services 649 sample database 225 scan performance 425 separate layer plan guides 219 single write request 610 SMO 353 SP1 454 SP2 331 387 554 SQL Server Browser service 256 Standard and Edition 463 subscriber 480 subscriber_upload_options 482 table partitioning 413 UDA 244 version 260 wait types 592 Workgroup Edition 463 SQL Server 2005 Integration Services 751 SQL Server 2005 2008 64-bit Enterprise Edition 597 deployments 594 index usage 600 memory 597 monitoring with DMVs 591 SQL Server 2008 15 111 119 128 133 138 189 224 255 259 266 331 381 384 404 428 449-452 454 458-459 461 550 565 575 670-671 680 687 695 698 Aggregation Design Wizard 706 Aggregation Usage designer 704 Attribute Relationships designer 705 auditing features 380 backups 432 batching 246 BI suite 698 CDC 681 Change Data Capture 754 Change Tracking 754 cmdlets 351 configuring a trace 580 Configuration Manager 440 data containers 221 data profiling 710 data retrieval methods 161 dependency tracking 387 Developer Edition 365 DMV categories 401 Dynamic Management Functions 590 dynamic management functions 196 Dynamic Management Views 590 enabling auditing 366 Enterprise Edition 340 451 full-text search 199 limit on number of connections 262 MERGE 214 242 Merge command 753 new audit features 365 new features 226 685 Optimize for Ad Hoc Workloads 598-599 Performance Data Warehouse 592 PowerShell 348 353 productivity features 233 public packages 623-624 query processor 429 Reporting Services 642 sample database 225 single write request 610 SQL Server Surface Area Configuration Utility 256 SP1 452 Standard Edition 463 stoplists 189 stopwords 189 191 stored procedures 221
