He/Him; Senior Software Developer, IT Swiss-army-knife.
Lots of coding, some hardware, some devops & sysops, some micro-controller electronics.
I used Arch BTW :)
Employing the dark magics of SQL Server by assigning stored proc input parameters to local variables in order to appease the capricious gods of parameter sniffing.
Ritual completed, sped up a query in said stored proc by 7 times.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Employing the dark magics of SQL Server by assigning stored proc input parameters to local variables in order to appease the capricious gods of parameter sniffing.
Ritual completed, sped up a query in said stored proc by 7 times.