|
It is in electronic format, so weight or space shouldn't be a problem
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Truth, as I glance at the books behind me that haven't moved since the pipe burst.
Charlie Gilley
“They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
Has never been more appropriate.
|
|
|
|
|
Oh lord, the TOC looks totally lame.
The only saving thing is that it seems to be so high level and abstract that it won't be obsolete next week.
modified 4-Nov-21 20:35pm.
|
|
|
|
|
Thanks for your comment
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
|
I beg to differ; it's only the USians that have these issues.
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
Also Canadians, but they did the turkey part last month.
|
|
|
|
|
I guy inherited a foul mouthed parrot that he just couldn't get to stop cussing. He tried everything. Finally, out of sheer desperation after one of the parrots tirades, he put the parrot in the freezer for a couple of minutes. When he took the parrot out the parrot said "OK, you win. What did that turkey do?"
|
|
|
|
|
|
Possibly. I did get a kick out of the fact that the advertisement immediately prior to the video was for KFC (Chicken).
|
|
|
|
|
Any recommendations for a decent tutorial on these? I'm seeing them used in stuff the outsourcing team is writing, and in 20 years of writing SQL, I think I had to use "partition" once, and whatever I learned is long lost to age and time.
|
|
|
|
|
This one[^] is as good as any.
What all tutorials fail to mention is that windowing functions only live in the SELECT clause.
This means that it cannot be used in the WHERE or HAVING clauses. (use a subquery or CTE instead)
And more important, windowing always happen AFTER GROUP BY.
|
|
|
|
|
Ok cool, thank you. Looks like a reasonable site. And thanks for the extra info as well.
|
|
|
|
|
Also, indexing works.
Use a composite index with the fields in the PARTITION clause followed by the fields in the ORDER clause, in exactly the same order
|
|
|
|
|
|
scottgp wrote: I find Robert Sheldon's articles to be excellent, e.g.
Thank you!
|
|
|
|
|
How about Find another way Partition clauses suck ?
I’ve given up trying to be calm. However, I am open to feeling slightly less agitated.
|
|
|
|
|
|
What software would you recommend me to use for creating a Video course with screen capture only (it does not need to use the Video Camera)?
I need to be able to convert the resulting video to some popular formats so that the video can be published on say youtube. I also need to be able to do some minor editing on the video - at least to remove some dragged out parts of it and perhaps insert some other parts.
Thank you.
Nick Polyak
|
|
|
|
|
I use Camtasia Nick. It's really good for capturing and editing.
|
|
|
|
|
|
I used to use Camtasia, but after a disastrous start with Win10 when I first updated I went over to OBS and have never looked back.
For me OBS has 2 things I really like:
1) It can record from almost ANYTHING that produces an audio or video stream, and from multiple sources all at the same time without breaking a sweat, I've recorded from Green Screen, Face Cam, Overhead Cam and external video digitiser all at the same time before.
2) It has a JavaScript rest interface buried inside of it and you can automate a LOT of stuff from other software using it.
If your looking for editing, and don't have a budget for the high price stuff such as Adobe Premier, then AVIDemux is about as simple and great as it gets, it's NON Linear, which means you can basically "random access" right down to individual frames in your MP4 (I use it for cutting adverts out of TV programs I record into my Plex server), if you want to go for a Linear editor (More like Premier) with multi tracks, then free open source wise, "Open Shot" is an excellent piece of software.
|
|
|
|
|
OBS Studio does a great job at capturing and recording. It's what I have used for 7 years. No native editing, though their wiki, obsproject, lists 9 options they recommend.
|
|
|
|
|
|
For capturing I have used electa before, but it doesn't work well in windows 10 (not even in a Win7 VM within Windows 10)
For win 10 I have been using the built in recorder but a friend recommended me to use "anyMP4" (not used yet)
For editing (easy editing though) I use Avidemux.
For more complicated editing... I can't tell.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|