Viewing 15 posts - 1 through 15 (of 254 total)
Ah, yes good point! Cheers Steve!
July 22, 2020 at 3:53 pm
Ah, looks like sys.sysaltfiles is what I needed.
July 22, 2020 at 11:15 am
Quick update on this as I've now resolved it. I was initially confused by the instance name of POWERPIVOT and made an assumption that it was a very specific installed...
June 30, 2020 at 2:06 pm
Sorry for wasting your time all, turns out this package has never been scheduled! There are very similar named packages in the same project, one letter difference! My eyes glossed...
June 17, 2020 at 5:12 pm
Execution history is what is missing. Not version history.
Execution history is configured for 90 days, whilst Version history is configured for 3 iterations.
June 17, 2020 at 3:39 pm
We keep 3 iterations of the project version.
I didn't think you lost the history on deployment but I can't see any reason for this history to have vanished. It's quite...
June 17, 2020 at 1:56 pm
You raise a good point about other things running on the server, and yes we do have SSAS -- but its usually idle when these problems occur. It only has...
June 9, 2020 at 2:56 pm
Thanks Brian for the reply.
Is it possible to us the Query Store to historically identify Parallel plans or problematic Paralellel plans?
June 8, 2020 at 3:36 pm
We use synonyms a lot between databases so we can keep the general functionality separate and give us lines of demarcation for all sorts of things including the...
October 30, 2019 at 10:06 am
This reply has been reported for inappropriate content.
October 30, 2019 at 10:03 am
I've always used database snapshots for this kind of thing. But this is when such updates to a table are planned and controlled and a snapshot can be created right...
October 29, 2019 at 9:10 am
Seconding Jeff on the SAN Replication if its available.
I've used that for almost exactly this kind fo work and it was AWESOME.
November 21, 2018 at 11:01 am
We are actually going through a very similar problem at the moment with an inherited database. Each iteration of the DB was done so by another short term project-scoped contractor...
November 1, 2018 at 3:23 am
Cheers John for the block size link.
October 30, 2018 at 4:27 am
Jeff this is an entirely unused server, and is purely being used for testing the collation change.
What is performing really slow is putting a primary key back on...
October 30, 2018 at 4:26 am