Viewing 15 posts - 2,056 through 2,070 (of 39,859 total)
You can pick profile in the upper right, then on the side bar, edit profile. You can go down and change the email, but not the user name.
June 2, 2021 at 5:50 pm
Gail is still around, but less on technical sites. Life has taken a turn for her, and we chat at times, but mostly she's less engaged in this space. She...
June 2, 2021 at 2:12 pm
I like the Dog Mode having a big sign on the display and the temp setting. We'd certainly use that with our pups.
I'm torn with a lot of the electronic...
June 1, 2021 at 5:38 pm
The framing is the size of the window. The default is range. This is separate from the partitioning, which you can choose. Without an ORDER BY and without a framing,...
June 1, 2021 at 1:35 pm
I tend to agree, though I think at times it's not bad.
It is, however, not sustainable for a healthy lifestyle and highly productive work for the vast majority of people.
May 28, 2021 at 6:59 pm
That last sentence is often the key. The "don't realize this" is the issue.
The architect of SQL Server overall would say what Jeffrey said. The rows are all inserted at...
May 24, 2021 at 6:50 pm
This is one of those tough design decisions. I might say that until the transaction completes, the row isn't inserted. It shouldn't be visible, though I know you can get...
May 24, 2021 at 5:37 pm
Always Encrypted is different than TDE. If you are using ALways Encrypted, the keys are in sys.column_encryption_keys and sys.column_master_keys.
May 24, 2021 at 4:53 pm
There is a default range regardless of the order by. However, an ORDER BY is required to have rows/range applied.
I've amended the question to note there is an ORDER BY.
May 24, 2021 at 4:52 pm
bperry's comment made me smile. My son, a few years ago, had an issue with his laptop. We had to go into the cli to restore things and I was...
May 24, 2021 at 4:36 pm
I'll add that while I thought R would be way better, a lot of the same modules and packages from R have been ported to Python, so I find the...
May 21, 2021 at 3:31 pm
Not an error. A warning. This still works:
> i <- c(1,2,3)
> j <- c(4,5)
> k <- i * j
Warning message:
In i * j : longer object length...
May 19, 2021 at 10:03 pm
Thanks, good catch. You are correct.
this is fixed.
May 19, 2021 at 2:12 pm
I'd think your "AND" is a problem here, as an event doesn't have all 3.
May 18, 2021 at 7:19 pm
I'm not entirely sure what you want to do here. You can do this in SQL Server (https://www.sqlservercentral.com/articles/geocode-addresses-in-t-sql), directly by using the spatial types. Or you could call the...
May 18, 2021 at 7:15 pm
Viewing 15 posts - 2,056 through 2,070 (of 39,859 total)