↓ Skip to Main Content
Vedran Kesegic Blog
Vedran Kesegic Blog

Main Navigation

  • Home
  • sp_xdetails
  • Performance Logging
Vedran Kesegic Blog
Vedran Kesegic Blog

Off Canvas Menu

  • Home
  • sp_xdetails
  • Performance Logging

Tag: windowing

Have SUM() fun!
TSQL and SQL Client Code

Have SUM() fun!

Vedran May 26, 2020 Tagged with analytic, over, sql, visualization, windowing

Did you know that SUM() aggregate can be used together with OVER() clause? A short intro …

Have SUM() fun! Read more →

Our Mission

Our Mission

Databases should be fast and simple to use. We make them so. Do not let your customers wait for a slow database response - hire a top professional! We are passionate about creating highly-tuned SQL Server systems. Do you want yours to become one? Simply call us or send email, and we will take care of the rest.

Vedran Kesegić, M.Sc.
SQL Server Database Consultant
Email: [email protected]

A Random Thought

If nobody reacted to alert from monitoring system, that alert should not exist. Quality of alerts is measured by number of reactions divided by number of raised messages. Should be close to 100%. If below 50%, it is a spamming system, not alerting system. Nobody reacts to real alerts if so many false ones occur. Be savvy with alerts.

Categories

  • Backup and Recovery
    • Transaction Log
  • BI
  • Conferences
  • Data Engine
  • Performance
  • Security and encryption
  • Storage
  • TSQL and SQL Client Code
  • Uncategorized

Recent posts

  • Instant SQL Masterpieces
  • Immutable backup against crypto attacks
  • Database recovery IMPORTANT rule
  • SUSPECT database
  • How to partition a really big table?
Copyright © 2026 Vedran Kesegic Blog | Powered by Responsive Theme
Copyright © 2026 Vedran Kesegic Blog | Powered by Responsive Theme
Visit Us On TwitterVisit Us On FacebookCheck Our FeedVisit Us On LinkedinVisit Us On Youtube