Fixing SQL Performance Troubles – Live 1

First Live with Pinal Dave where he will discuss various SQL Server Performance troubles and solutions.

Send your questions to me early so I can cover them in this live stream.

source by Pinal Dave

sql

Mourad ELGORMA

Fondateur de summarynetworks, passionné des nouvelles technologies et des métiers de Réseautique , Master en réseaux et système de télécommunications. ,j’ai affaire à Pascal, Delphi, Java, MATLAB, php …Connaissance du protocole TCP / IP, des applications Ethernet, des WLAN …Planification, installation et dépannage de problèmes de réseau informatique……Installez, configurez et dépannez les périphériques Cisco IOS. Surveillez les performances du réseau et isolez les défaillances du réseau. VLANs, protocoles de routage (RIPv2, EIGRP, OSPF.)…..Manipuler des systèmes embarqués (matériel et logiciel ex: Beaglebone Black)…Linux (Ubuntu, kali, serveur Mandriva Fedora, …). Microsoft (Windows, Windows Server 2003). ……Paquet tracer, GNS3, VMware Workstation, Virtual Box, Filezilla (client / serveur), EasyPhp, serveur Wamp,Le système de gestion WORDPRESS………Installation des caméras de surveillance ( technologie hikvision DVR………..). ,

17 réflexions sur “Fixing SQL Performance Troubles – Live 1

  • juillet 21, 2021 à 6:48
    Permalien

    Sorry I missed the video earlier, but this is nice of you to do for everyone. A question I had…is there ever a reason to not update the compatibility mode of a database to the version that it actually is (outside of deprecated code perhaps)? What sort of problems have you seen from this and is there a way to forecast that a problem could occur that needs to be addressed before the update?

    Répondre
  • juillet 21, 2021 à 6:48
    Permalien

    Hello Pinal, I watch almost all of your videos that are amazing, I'm learning many technics with your sixty-second video.
    Can you please make a video on arithmetic overflow error converting float to data type numeric while processing cube?
    How do I find the value that is throwing an error?

    Répondre
  • juillet 21, 2021 à 6:48
    Permalien

    VERY VERY EFFECTIVE MATERIAL FOR THOSE WHO WANT TO BRING PERFORMANCE FOR THEIR DATABASES.
    PLEASE KEEP SHARING YOUR EXPEREINCES WITH US IN A FORM THAT WE CAN LEARN FROM IT…
    THANK YOU THANK YOU.

    Répondre
  • juillet 21, 2021 à 6:48
    Permalien

    Been a while, but isn't there a lazy index update configuration option that allows the index to update after the completion of the query instead of updating before completion? How well does that work here?

    Répondre
  • juillet 21, 2021 à 6:48
    Permalien

    One more feather in your cap. A live stream. Boss hats off. Keep posting such great content and I would be looking forward to see you live the next time 👏🏻👏🏻👍

    Répondre
  • juillet 21, 2021 à 6:48
    Permalien

    Great stream sir! I missed the announcement that you were going on a live stream so had to watch the recording. Hopefully I can join the next one live 🙂

    Répondre
  • juillet 21, 2021 à 6:48
    Permalien

    I was unable to attend the live stream and thank you for having this recorded so useful for many people like us. Much appreciated!

    Répondre

Laisser un commentaire