Running Totals for Each Group
A while ago, I posted a blog on how one could perform running totals using Reporting Services and a user...
2010-10-11
4,382 reads
A while ago, I posted a blog on how one could perform running totals using Reporting Services and a user...
2010-10-11
4,382 reads
Presenting is a huge fear for many and it is no different for me. I have been presenting at SQL...
2010-10-10
584 reads
Recently, I came across a forum post from a user trying to determine if a directory existed in the file...
2010-10-06
13,865 reads
It's official! I am presenting a mini session for SQL Saturday in Orlando. My topic and some details are below:
Delivery...
2010-10-05
447 reads
Have you ever queried the msdb tables to get duration details about a particular job? I’ve had to do this...
2010-10-05
2,755 reads
While working on a project recently, I came across a conversion that was trying to convert a date to an...
2010-10-05
785 reads
Here is another one of those strange but true things that I come across every so often which I thought...
2010-10-01
1,513 reads
The way Reporting Services creates subscriptions is through generating a SQL Server Agent job. This is apparent when you look...
2010-09-01
778 reads
A colleague of mine and I were recently talking about some scripts that they had seen containing the WITH NOLOCK...
2010-09-01
535 reads
Over the many years that I’ve been dealing with SQL Server, I’ve always been told and read about how using...
2010-08-29
584 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
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
Comments posted to this topic are about the item New SQL Server 2022 Functions
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