Do you still get the error if you try to remove the user like this? USE SSISDB

DROP USER USERNAME

John

You have replaced "USERNAME" in that query with the name of the login you can't drop, haven't you? And you are running the query in the correct database context...

Do StartDate and EndDate always straddle a month boundary, and if so do they always straddle exactly one? Is the Amount to be divided evenly between the months regardless...

Or dust off your school maths book and use logarithms!WITH Logs AS (

SELECT

PropertyID

,TimePeriodDate

,MIN(Rent) OVER (PARTITION BY PropertyID) AS StartRent

,Growth

,SUM(LOG(Growth)) OVER (

PARTITION BY PropertyID

ORDER BY TimePeriodDate

ROWS BETWEEN UNBOUNDED PRECEDING AND 1...

Yes, it is usually a good idea to have a clustered index on your tables. If you're doing a lot of inserts, make sure the key is monotonically increasing...

What do you mean by this? Has the application's behaviour changed, and if so in what way? Did anything change in...

The first INSERT statement can't work, nested or not, because the ID and date columns in the temp table are not nullable and you haven't specified values for them. ...

Or maybe you've just done something that drags a lot of data pages in and out of memory, such as index maintenance or a data load?

John

You're trying to insert from the dim_person.person_name column, which is (presumably) nvarchar into the person_Ext column in your temp table, which is int.

John

All I've done here in addition to what I posted before is calculate the previous start and end dates based on the given start and end dates. You could...

Twice as much space as you need for all your indexes - is that a big problem? What is the autogrowth increment for the log file? Was there...

Thanks Mike - that was quick!

I get it now... I assume we'll be looking at tables later, so on with the Stairway!

Thanks again

John

What do you mean by "only"? What log file growth are you seeing? What other index rebuilds occur in the hour between the previous transaction log backup and...

Thanks Mike. I've been following the series so far and it's very enlightening! There's just one bit I'm struggling with:

Structured data is data loaded into tables in a...

Since it's a DR server, you're going to need a way to propagate changes to live jobs into DR, so why not use that same technique to do the initial...