T-SQL for UDFs
SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for our purposes. Such one, for example, is the function...
2016-01-15
6 reads
SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for our purposes. Such one, for example, is the function...
2016-01-15
6 reads
SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for...
2016-01-15
108 reads
SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for our purposes. Such one, for example, is the function...
2016-01-15
2 reads
Once it happend quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and...
2015-12-25
128 reads
Once it happened quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and worst. The average CPU raised over 80% (Figure 1)....
2015-12-25
2 reads
Once it happened quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and...
2015-12-25
99 reads
Once it happened quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and worst. The average CPU raised over 80% (Figure 1)....
2015-12-25
4 reads
Recently I had the chance to take a look at a problematic query in an application. I caught the query...
2015-11-11
110 reads
Recently I had the chance to take a look at a problematic query in an application. I caught the query in profiler and it’s the following: [crayon-5e9656615f713397718274/] The query...
2015-11-11
6 reads
Recently I had the chance to take a look at a problematic query in an application. I caught the query...
2015-11-11
3,215 reads
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Think there's a reason why this is still in preview, but have someone manage...
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
This is a generic question. To the moderators, I wasn't sure where to place...
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers