[Database Series 07] Understand Indexes! Why the Same SQL Can Have Vastly Different Search Speeds

The theme for this session is database "indexes".Indexes are one of the technologies you absolutely must understand when considering SQL performance.However, this content might be a bit difficult for ...
I Programmer

Oracle PL/SQL by Example, 5th Ed

This fifth edition of a well-known title has been updated for Oracle 12c. As with previous editions, the book is very hands-on; you’re introduced to a concept, shown an example, then asked to work ...

5 Points to Check First When SQL Is Slow: How to Improve Execution Plans, Indexes, and JOINs

When you execute an SQL query, the results do not return quickly.You may have had no issues during development, but the ...
Visual Studio Magazine

4 New T-SQL Functions

SQL Server 2012 was released last April, making it the 11th major release of the product. Every new version has delivered new functionality that should excite developers, and this release is no ...