Viewing 15 posts - 2,626 through 2,640 (of 39,723 total)
I thought this was pretty easy. Hard to make plausible wrong answers here, at least, it was for me.
June 11, 2020 at 4:08 pm
Steve Jones - SSC Editor wrote:Good points. Submitted a PR to add SELECT to DML.
Anyone can do this: http://voiceofthedba.com/2018/01/03/creating-a-books-online-pull-request/
Did it include a request to move TRUNCATE TABLE from DML to DDL?
I didn't,...
June 11, 2020 at 4:04 pm
In addition to what Jeff noted, if you get to move this to different hardware or change the makeup of the LUN, having a different drive letter provides some abstraction.
June 10, 2020 at 4:54 pm
Good points. Submitted a PR to add SELECT to DML.
Anyone can do this: http://voiceofthedba.com/2018/01/03/creating-a-books-online-pull-request/
June 10, 2020 at 4:52 pm
Steve, it's good to know that you weren't truly flat-lined during those missing days.
Hopefully the reports and averages show that!
June 10, 2020 at 4:24 pm
...
There is a danger that your targets become a psychological rod for your back. Getting anxiety because you haven't done your 10,000 steps a day!
I try hard not to...
June 10, 2020 at 4:22 pm
Heh... I wonder if some of the information that the fitness watch is telling you isn't a part of the reason for some of the restless nights 😀
Maybe, but...
June 10, 2020 at 4:18 pm
We haven't supported tables directly. I was surprised myself, and it's on a backlog, but I think it's relatively unimportant. Most of the time, having DDL/DML is better for us...
June 10, 2020 at 4:17 pm
You don't have time zone info, so you can convert this based on EST, knowing that some of your data will be incorrect. During parts of the year, EST is...
June 9, 2020 at 8:12 pm
Can I run this code? Sure, there are security implications, but this can work. Would I do this? No, because you've not littered a three part naming in code. The...
June 9, 2020 at 8:06 pm
I don' t mean to imply SQL 2017 isn't a good product (or 2014 for that matter), but for most people, this isn't a compelling change to move off 2016....
June 9, 2020 at 7:59 pm
I understand how and why this works, but I do think this is inconsistent with other languages. Quick tests when I wrote this in Python and PowerShell show the answer...
June 9, 2020 at 3:48 pm
I'd argue people are the most important part, with process second. The tools/platform/automation/tech bits is the easiest part by far.
Unfortunately, too many people stop with tools/etc. and don't work on...
June 9, 2020 at 3:31 pm
You can't download git to a work laptop? I wouldn't remotely understand that as a technical person. This is highly stable, free, well tested software that millions, likely hundreds of...
June 9, 2020 at 3:06 pm
You can, but why? I'd put the distributor on each publisher. Simpler and works well.
For moving this into a central warehouse, you can use some sort of structure to ensure...
June 8, 2020 at 8:54 pm
Viewing 15 posts - 2,626 through 2,640 (of 39,723 total)