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
1 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
1 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
1 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
101 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
88 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
126 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
1 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
1 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
97 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-5e81b52edda2c602772598/] The query...
2015-11-11
1 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
3 reads
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Dipping my toes into the waters of Azure and of course before I get...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers