Dynamic SQL : Applications, Performance, and Security in Microsoft SQL Server / / by Edward Pollack
| Dynamic SQL : Applications, Performance, and Security in Microsoft SQL Server / / by Edward Pollack |
| Autore | Pollack Edward |
| Edizione | [2nd ed. 2019.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2019 |
| Descrizione fisica | 1 online resource (XX, 496 p. 128 illus.) |
| Disciplina | 004.165 |
| Soggetto topico |
Microsoft software
Microsoft .NET Framework Database management Microsoft and .NET Database Management |
| ISBN |
9781484243183
1484243188 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | 1. What is Dynamic SQL? -- 2. Protecting Against SQL Injection -- 3. Large Scale Searching -- 4. Permissions and Security -- 5. Managing Scope -- 6. Performance Optimization -- 7. Scalable Dynamic Lists -- 8. Parameter Sniffing -- 9. Dynamic PIVOT and UNPIVOT -- 10. Solving Common Problems -- 11. Applications of Dynamic SQL -- 12. Index Usage and Maintenance. . |
| Record Nr. | UNINA-9910338003403321 |
Pollack Edward
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2019 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Expert Performance Indexing in Azure SQL and SQL Server 2022 : Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud / / by Edward Pollack, Jason Strate
| Expert Performance Indexing in Azure SQL and SQL Server 2022 : Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud / / by Edward Pollack, Jason Strate |
| Autore | Pollack Edward |
| Edizione | [4th ed. 2023.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2023 |
| Descrizione fisica | 1 online resource (649 pages) |
| Disciplina | 005.7585 |
| Collana | ITpro collection |
| Soggetto topico |
Database management
Microsoft software Microsoft .NET Framework Database Management Microsoft |
| ISBN |
9781484292150
1484292154 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | 1. Index Fundamentals -- 2. Index Storage Fundamentals -- 3. Examining Index Contents -- 4. Fragmentation -- 5. Index Metadata and Statistics -- 6. XML Indexes -- 7. Spatial Indexing -- 8. Indexing Memory-Optimized Tables -- 9. Full-Text Indexing -- 10. Indexing Myths and Best Practices -- 11. Index Maintenance -- 12. Indexing Tools -- 13. Indexing Strategies -- 14. Query Strategies -- 15. Monitoring Indexes -- 16. Index Analysis -- 17. Indexing Methodology. |
| Record Nr. | UNINA-9910674351303321 |
Pollack Edward
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2023 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||