Viewing 15 posts - 3,826 through 3,840 (of 39,768 total)
It is. I find functions to be a bit strange in R, especially nested ones. I'll get a question on those at some point. Or one of you can write...
June 19, 2019 at 6:27 pm
You might also implement Query Store to get plans to watch and examine. There is a project port of this here: https://github.com/OpenQueryStore/OpenQueryStore/releases/tag/v2.1.0
June 19, 2019 at 6:25 pm
You can implement AGs between to IaaS systems in Azure. This is the same as on prem, though you'll need the networking set correctly for the listener and each to...
June 19, 2019 at 6:24 pm
I think it is a ridiculous waste of time when someone comments on the obvious, like: counter++; // increment counter Really??
I blame professors are unis for this. That's the...
June 19, 2019 at 6:19 pm
I came across a stored procedure recently where there were 2 developers clearly arguing we didn't have source control for sql at the time of the argument (way before...
June 19, 2019 at 6:18 pm
Changing monitoring intervals, or suppressing additional alerts, is something that needs to happen as well. Too easy to keep sending the same thing over and over. However, that's a complex...
June 19, 2019 at 6:03 pm
That's interesting. I wonder if these reports are using your account as a proxy for some WMI call? I don't know, but asking MS if they can comment.
June 19, 2019 at 5:57 pm
You want the SELECT and UPDATE in the same transaction. Otherwise, there is the chance that before you do the assignment, someone else has a chance to perform the select.
If...
June 19, 2019 at 5:53 pm
As the main moderator here, please refrain from arguments over responses. The first reply did give you an easy hint, caveating this as "unlikely to be done often". If that...
June 19, 2019 at 5:46 pm
If the VM isn't working for your workload, either you're a) extreme, or b) improperly set up.
June 18, 2019 at 4:52 pm
The note I got back on this is that the login is a timed item, but it's device independent, so you might not log in from a device (browser/machine/etc) in...
June 18, 2019 at 4:27 pm
MFA - Multi factor.
Having read only access is good, but having a read only account is hard. Then I have doubled my attack area, as well as increased the demand...
June 18, 2019 at 4:25 pm
And suddenly today I got the first newsletter in my inbox since the new site went live. Maybe it was because I was selecting and deselecting the newsletters a...
June 17, 2019 at 3:32 pm
We moved to a newer Askimet implementation with this change and maybe something there changed. It looks like a few rules around repeated stuff, lots of capitals, a few strange...
June 14, 2019 at 1:51 am
NM, opened it up here: https://www.sqlservercentral.com/forums/topic/availability-groups-vs-transactional-replication
June 13, 2019 at 12:46 am
Viewing 15 posts - 3,826 through 3,840 (of 39,768 total)