T-SQL Tip: OVER and PARTITION BY
OVER allows you to get aggregate information without using a GROUP BY. In other words, you can retrieve detail rows, and get aggregate data alongside each. Let’s look at examples!
t-sql
5 steps to become a SQL visionary
Solutions to age-old problems are often very hard to see. It takes a new, visionary perspective to see the issue clearly and to find a solution that’s better, easier, and kinder. Learn the process of being a SQL visionary here!
Which is the performance killer: SELECT INTO or INSERT INTO?
There are many ways to kill performance in a script or stored procedure. However, not many think about the possibility that adding columns to a temporary table can kill performance. Here, I’m going to show you how a simple design decision – using INSERT vs ALTER TABLE – can have a huge impact on your procedure …
Which is the performance killer: SELECT INTO or INSERT INTO? Read More »
I’m the new DBA, and I’m locking down development servers
As the new DBA, I’m here to fix things for you. I’m going to take care of the things that keep causing fires and outages and slowdowns….and I’m locking down your dev environment. Here’s why.
Avoid this sp_executesql issue
If you don’t use this feature very often, you can come across some unexpected sp_executeSQL issues. This time we’ll look at an sp_excuteSQL output issue.
Using SQL Server OUTPUT Parameters
Let’s talk about using SQL Server OUTPUT parameters!
Learn SQL Server OUTPUT Parameters
There are plenty of sites out there that show the syntax of using SQL Server OUTPUT parameters in your SPs, but not many take the time to explain the syntax in detail, or even why you should care. Here I’m going to show you why OUTPUT parameters are a great way to achieve your programming goals.