Видео

ghanta kuch samajh mei nahi aya...sirf chilam challi kuch query run karke ke batata to thik tha

Extremely useful video! I've been leaning on window functions heavily since I first learned about them, only to now realise that I may have been slowing my queries down drastically. Whoopsie.

Thanks! for explaining with practical examples

Too simplistic to use in real scenarios...

Very late to the game... Couldn't get the "animation" working at first. Had to go to Options Search for "Results to Text" Check "Scroll as results are recieved" Fiddle with the result pane size and it's working like a champ! Hope this helps someone.

great stuff

Found just stories in all videos. normally we watch video tutorials to understand practical stuff otherwise theory we can read from some web page(s).

talk slower, let people absorb what you are saying. Also explain how you ingested the co-ordinates polygons

There is not a single chance in the world to get rid off Nested loops, not even 0,0000001% chance buddy

Video này rất thú vị và hữu ích. Ý tưởng đề cập đến rất sáng tạo và giải thích rõ ràng. Nội dung được thể hiện rất tốt và gây ấn tượng mạnh. Tôi rất thích xem video này. 🌻🌹

hey Bert (or anyone else that knows :)) - at 6:50 you talk about viewing the cach plans by looking at the 'DMV' called dm exec etc etc. What is a DMV in this context? Just trying to understand what those commands are... where do they come from? What is this 'DMV' that you refer to?

Hi Bert, I didn't set up payment in the OpenAI settings but they still gave me an API key. Took me a minute to figure out why the Talkie wasn't working. Working now, thanks!

Thanks🎉

content that is worth its time :) credits for such valuable materials :) thx!!! btw why You have the Polish emblem (white eagle on red shield) on your laptop? :)

That's a very cool solution. Thanks!

Awesome video

Hiya Bert; I don’t have an alternative/better/likely worse solution to your problem (though I do love these kinds of things!), nor do I even know if you ever come back and read the comments (hopefully so, I’ve watched quite a lot of them and everyone seems mostly positive - which is about the best you can hope for with RUclips comments). I do just want to say THANK-YOU for taking the time to put these together; they’re VERY well done, concise, span and broad range of SQL topics, provide in-depth knowledge in an understandable fashion, and go far beyond the deluge of basic/beginner topics that so many channels seem to focus on. I’m a dev, and as you know it’s a lifelong commitment to learning about things that change every day and potentially won’t even be relevant in a decade or so (ᕕ( ᐛ )ᕗ), and part of that commitment is reading articles, SO, and watching RUclips videos to try and keep my knowledge current, refreshed, and hopefully ever-growing. Your videos are phenomenal for that: I can’t find the mental bandwidth after a long day to watch a slow, dry, hour long video on SQL that MAY make some interesting points. The cost/benefit analysis just doesn’t check out. Your videos, on the other hand, are spectacular! They’re fast-paced, you don’t pontificate ad infinitum, and (as mentioned) the content is phenomenal. So, Bert: I say thank-you! I’ve already begun recommended your channel to the coworkers that I like :)

Great video!

Very good examples. Thanks man.

your content and explanation is good but for further videos can you please remove background music, difficult focus on what you said

k j n

可能，你，那麼，那麼，那麼，那麼，你，嗎你們，你，m

I must say, I was kinda skeptical but this really helped me get a quick overview of Cardinality. Thank you!!!

I like the 3rd option, but hate it too and not just for maintenance. The idea of having to put that through peer review and production approval would be lovely to explain to others as well as documenting everything so people know why you have duplicate code.

cool introduction 👍

Temporal SQL and Complex Event Processing (CEP) serve different purposes and are not direct substitutes for each other. Temporal SQL, also known as "time-centric SQL," extends traditional SQL with features for handling temporal data, such as valid-time and transaction-time semantics. It allows querying data based on time intervals, historical snapshots, and temporal relationships. Temporal SQL is useful for scenarios where you need to track changes to data over time, analyze historical trends, or perform time-based queries. On the other hand, Complex Event Processing (CEP) is a technology used for analyzing and correlating streams of events in real-time to identify patterns, detect complex conditions, and trigger actions or alerts. CEP systems typically process high volumes of streaming data from various sources and apply rules or patterns to identify meaningful events or combinations of events. CEP is commonly used in applications such as fraud detection, monitoring IoT devices, and financial trading. While both Temporal SQL and CEP deal with time-related data, they address different aspects of data processing. Temporal SQL focuses on querying and managing temporal data stored in databases, while CEP focuses on real-time analysis and processing of streaming event data. In some cases, you may use both technologies together to handle different aspects of time-sensitive data processing in your applications. ChatGPT verified Used some versioning built in into databases

Have you seen a QBSQL query that requires W - with the bar over laid onto the W to replace a / symbol?

what is sound track plays?

ㅠㅠㅠ 너무 감사합니다 이 문제로 삽질을 얼마나 했는지 ㅠㅠ 정말 요즘 세상에 8000자로 짜른다니 이해가 안되네요

Perfect explanation

Mine doesn't do anything when I click it. Doesn't work for me.

The way this has to be done feels like all the things database classes tell you not to do :(

These videos are gold. Thank you for making them.

Thank you for the info, is it an issue if the execution plans are never reused? We have an EHR data base and the execution plans are showing 0 for reuse. Just wondering if that's normal.

this video is really helpful . I have a doubt. If I have defined clustered and non clustered index and we are inserting new row, it will add the newly added row in specific position and shift other rows as per clusterd index. So, how non clustered index is getting benefitted here on inserting new rows. And is that possible to have table without any clustered index.

Great video!

Pinal Dave is my hero.

Misleading at best

Thank you For Spatial DB we have lots of information on PostGIS very less for SQL This is highly informative for MS SQL DBA's

We can also use the keyword N'' before the string to specify the encoding unicode and it would be able to store more data

Am I the only one who noticed the Polish eagle sticker on his laptop? Where do I get one?

Thanks for this making tutorial. It's just what I needed.

Thanks Bert! Big Help 😁👍 You're a Cool Dude.

You're new I'm just starting this video... I'm gonna watch this..

Thank you that was so useful!

4:05 im confused why a insert would be so slow in this situation. Can clustered indexas not be sorted by some sort of tree?

I have been using jrnl for over two years now, and it has made my life really easy. I can have multiple journals, add metadata to my entries and do a search on that. I have managed to define my own metadata format and use some functionality of the system to quickly filter on that. But it is nice to see your app, as it is somehow similar, although a little less powerful, and also written in Python

Are you Austrian?

This is fascinating SQL code... what I was hoping to find was a way to generate a possible table definition by inspecting a subset of a list of data from the json response of an API. For example using python, C#, etc to output a definition and get the types right, even if precision, keys etc might need modified.

what camera u used to glow ur face