|
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.
|
|
|
|
|
Thanks Nelek!
Nick Polyak
|
|
|
|
|
Camtasia is a good choice. I used it and it is very friendly.
diligent hands rule....
|
|
|
|
|
Thank you! so far 2 against 1 for Camtasia against anything else
Nick Polyak
|
|
|
|
|
|
|
I haven't played with Camtasia, but another editor worth being aware of is HitFilm. They have an express version available which they will let you pick up for free, although they do try to guilt trip you. Even the express version is extremely powerful, and easy to use with a little play. It does not do screen recording, though (as far as I've found).
|
|
|
|
|
Thanks David - I do need screen recording though - this is the most important part for me.
Nick Polyak
|
|
|
|
|
Hi Nick,
1. For screen recording, I recommend OBS Studio[^] -- it's free.
2. For editing, I shamelessly recommend my own software -- Cinematic Studio - trimming/editing is a bliss, and you can do some pretty slick text effects 
Best,
John
|
|
|
|
|
For recording, I would go for OBS.. It's used by lots of streamers/youtuber's. You could even go Streamlabs OBS which is a reskinned version.
For editing, you cant go past Davinci Resolve. You'll only need the free version.
|
|
|
|
|
For editing get Davinci Resolve. It is simply amazing. I've used some other programs in the past to edit videos and no one is as powerful as this one FOR FREE and, moreover it is easy to use.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
