LOL... for me it definitely is not, but...

You could download adventureworks database and just write some complex queries against that?

But it depends on what you consider complex.  I have some stored procedures at my workplace that are...

Where I work, I have 60+SQL instances with roughly 5 databases per instance.  Not an ideal setup with 3 physical servers, but it works for what we need.

We have our ...

Just to confirm, if the date was the 15th, would you want it from the 28th/29th/30th/31st (depending on the month) to the 14th?

Basically, are you wanting it from 15 days...

ReportServer and ReportServerTempDB are databases used exclusively by SSRS.  If you are not using SSRS, you don't need those.

To take a different approach, it depends on what you are trying to capture with the audit trail.  Do you care about who and when each and every change was...

My first step - grab an execution plan.  Have a look under the  hood at what is happening.

But I don't think those 2 queries are doing the same thing.  Having...

My  preference is any production level server, maintenance is done in a controlled maintenance window outside of business hours where possible.

You are giving yourself a 1 hour window to do...

Another way to check would be to run:

EXEC sp_configure

and then check if the configured value matches the running value, right?  If you ran RECONFIGURE, they should match...

My approach is to do as little data manipulation on the SQL side as possible before presenting it to the end user or application.  I'm not saying that it is...

I agree with jcelko here 100%.

If this table structure is not pre-defined for you, I would definitely look at doing it in at least 1st normal form.  You will also...

Never mind... sounds like the issue is actually not in the DATEADD part, but possibly in the JOIN.

• This reply was modified 5 years, 5 months ago by Mr. Brian Gale.

for the jobs that run SSIS packages, my approach is to script out the job steps table joined to the jobs table.  Something like:

USE [msdb]
GO
SELECT 
name, step_name,...

I've not done something like this (we don't use SSAS or MDX at our shop), but it sounds like a good use case for CASE:

https://docs.microsoft.com/en-us/sql/mdx/case-statement-mdx?view=sql-server-ver15

My thought, based on past experiences, is that you are having memory pressure.

We had an intermittent SSIS package.  Most of the time it completed in under an hour (40-ish minutes),...