Viewing 15 posts - 1 through 15 (of 5,893 total)
If you are on Enterprise Edition for SSRS - then you can add the new reporting services server in a scale-out deployment. Configure the new server to use the existing...
September 18, 2021 at 4:34 pm
There is also the schema changes report available - that shows not only changes to tables but will also show changes to any objects and who made the change. However,...
September 15, 2021 at 9:21 pm
Why would you do that? That would just mean rerunning this code over and over until all rows matching the criteria have been deleted. What purpose would that serve?
September 12, 2021 at 2:41 pm
I have already put code in place to block the NULL values for some of the Attributes, not sure why is was ever code to allow those into the...
September 11, 2021 at 4:32 pm
The steps you outlined are correct - that process will allow for patching with minimal interruption.
September 11, 2021 at 3:01 pm
This is a basic template for a batch delete/update/insert process:
Declare @rowsAffected int = 1 , @batchSize int = 50000; --increase/decrease as...
September 10, 2021 at 5:04 pm
What is the purpose of the AG node? I am assuming that the FCI cluster is primary - SERVER3 is an AG secondary, and that secondary is set to asynch...
September 10, 2021 at 4:41 pm
Ola's utility - and many procedures that were built to do the same thing - will have a post-step after an index reorganize that updates the statistics. So either a...
September 7, 2021 at 9:54 pm
That is expected - the /netonly credentials will be used for that connection even though it shows your local windows credentials.
September 7, 2021 at 6:05 pm
Not much we can go on - would help if you showed the code that is causing the issue.
August 24, 2021 at 8:19 pm
I am not sure I understand the request - what are you trying to accomplish? Can you be more specific?
There is the option of filtering the dataset, which you can...
August 23, 2021 at 6:40 pm
You where correct with the " It's the ol' "data mart"... It's kind of a hybrid table.Will that effect the Delta output? THanks.
You where correct with the " It's the ol' "data mart"... It's kind of a hybrid table.
Will that effect the Delta output? THanks.
No - but I ask again. Have...
August 21, 2021 at 3:35 pm
If the user owns a schema - then they will be able to create objects in that schema unless explicitly denied (and I am not sure if that can be...
August 20, 2021 at 9:09 pm
One of the reasons you would not want to loop over a list of tables is the fact that you have now serialized the extract and load process. Using separate...
August 19, 2021 at 8:38 pm
If you run your alternate function without a where clause or group by - does it return any data? If it does return data - does it return data where...
August 18, 2021 at 4:37 pm