|
You are here |
sqlserverfast.com | ||
| | | | |
tanelpoder.com
|
|
| | | | | Training overview This training session is entirely about making Oracle SQL execution run faster and more efficiently, understanding the root causes of SQL performance problems and Cost Based Optimizer misbehavior. Instead of looking into increasing system utilization (by using more buffer cache or more parallelism) as a first "tuning" choice, this class is mostly about decreasing resource usage of SQL execution plans by improving their shape and available access paths. - Linux, Oracle, SQL performance tuning and troubleshooting training & writing. | |
| | | | |
boringsql.com
|
|
| | | | | Unlock powerful data analysis in PostgreSQL with window functions. Go beyond aggregates to rank, calculate running totals, and compare rows directly within your queries. | |
| | | | |
36chambers.wordpress.com
|
|
| | | | | This is part seven in a series on window functions in SQL Server. The Road So Far To this point, we've looked at five classes of window function in SQL Server. I've given you a couple of solid use cases, but for the most part, we've focused on what the classes of window functions are.... | |
| | | | |
www.ibd.com
|
|
| | | Today's article in O'Reilly's Radar by Joseph Hellerstein, is a concise synopsis of the state-of-the-art large scale data analysis. It compares the Enterprise IT dominant Relational Database paradigm to the emerging (with a bullet!) MapReduce / Hadoop technologies. Professor Hellerstein, from UC Berkeley lives this stuff as a leading researcher on databases and distributed systems. | ||