I frequently use Common Table Expressions (CTEs) when I demo windowing functions and get questions about them. Windowing functions are limited to the SELECT and OVER clause which means that you can’t filter or group on them directly. Using a CTE is one way to separate the logic of the query into multiple steps so […]
Monitoring your SQL Server is important. This article examines one of the metrics you might want to keep an eye on.
Handling a budget can be an interesting experience for many technical professionals. Today Steve wonders if you treat this differently than your budget at home.
How to customize a database deployment process using Flyway, demonstrating how to incorporate tasks such stamping a version number into the latest database build, or writing to the SQL Server log.
Folks sometimes ask, “When a table has more indexes, and SQL Server has more decisions to make, does that slow down execution plan generation?”. Brent Ozar talks through his response in this article.
A good example where the Query optimizer picks the wrong query plan and suggested index.
User interface is a part of software development that many technical people pay little attention to during the process of building something. However, it can be a problem for your customers.
There is more to DevOps than tools and automation. In this article, Robert Sheldon explains how to create a DevOps culture based on collaboration.
This article shows how we were able to migrate a TB size database to new storage with minimal downtime.
Many organizations will change their teams around over time, but not all do this regularly. Steve talks about how Redgate does this every year.
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
By Will Assaf
Say you have a temp table and you want to see the columns names. For...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I am using SQL server 2008 R2 express edition. Out of below 3 method...
DBAs are being asked to know everything for 6 figures which cap out for...
Comments posted to this topic are about the item Common Table Expression Misunderstandings
Ask SSC