Viewing 15 posts - 31 through 45 (of 9,123 total)
Run the tasks in series?
that too, but more overhead than required considering partitions can be slid out
May 1, 2024 at 4:51 pm
Why are you truncating partitions and loading them why not just use the partition sliding window to move partitions along and drop any you don’t need
May 1, 2024 at 4:33 pm
sqlserver service account is running under LocalSystem Account on the destination server
I guessed so if agent is running under that too, so have you checked the ACLs at the...
May 1, 2024 at 4:29 pm
there is an Auto_Stats ext event under the execution category, track the incremental and sample_percentage columns
May 1, 2024 at 4:24 pm
if (Test-Path -Path "$($Row)")
{
Throw "File exists"
}
May 1, 2024 at 3:45 pm
They should both support the same record set operations so change the connection providers and rebuild the project then test
May 1, 2024 at 3:09 pm
Path is not passed is it the intention to use a local drive as it’s not specified clearly in the 2nd script.
Bit more info on what it is you’re trying...
May 1, 2024 at 3:04 pm
I don’t see any reason to be concerned about 3NF reqs here it’s a simple metadata table
May 1, 2024 at 12:16 pm
What groups are provisioned on the servers with rdp access too?
that is do you see the same AD group in windows admins as you see as syssdmin in the sql...
May 1, 2024 at 8:37 am
Does anybody know of any drawbacks with this approach?
can’t think of any immediately, the table is small and lightweight.
only the obvious which is the inability to truncate the parent...
May 1, 2024 at 8:26 am
It makes sense for azure sqldb, AGs are more targeted at groups of databases rather than single dbs, ok azure sqldb are pinned to a virtual instance for database connectivity...
April 30, 2024 at 9:12 pm
The best alternative I can think of is a separate table instead of an IsDefault column. This other table has one row with one column, FK to the PK...
April 30, 2024 at 8:58 pm
And that's why there are central management servers and Powershell...
agreed, the deployment of a central management server provides this list centrally for all users, adding warehousing capability and harvesting...
April 30, 2024 at 8:17 pm
If you declare an explicit tran then it is your responsibility to either commit or rollback
Cleaning up uncommitted explicit trans by auto committing them is not something you want
April 30, 2024 at 5:14 pm
Viewing 15 posts - 31 through 45 (of 9,123 total)