T-SQL developers have been asking MS to address paramerter sinifinng problems since many yrs. It took so many yrs for MS to realize there is a problem which really need their attention. 20+yrs (since SqlServer 2000) is a lot of time to fix this issue.
Say whatever you want. Microsoft enginners ingenuity must be recognized.
T-SQL developers have been asking MS to address paramerter sinifinng problems since many yrs. It took so many yrs for MS to realize there is a problem which really need their attention. 20+yrs (since SqlServer 2000) is a lot of time to fix this issue.
Oracle still struggles with that as well.
Better late than never. This is great news for something that frustrates most of us at some point.
I think it is really a complicated one in general, right? Or you have a simple fix for it?
Very Nice thé Next evolution SQL serveur 👌
How many of these new features will only be available on Enterprise?
We will disclose editions and features when the product becomes Generally Available
Parameter sniffing problem fix 🔥
Will PSP only work for SP or also Parameterized (JDBC Prepared) Statements?
This works for any parameterized statement
@@bobward436 thanks Bob !!!! We are all looking forward to work on PSP
*Does anyone know where I can get certified in SQL SERVER currently?*
parameter sniffing - finally addressed!
Great Great, Keep Going !
The parameter sniffing solution which can't be beat is TWO PROCEDURES lol
You might want to reconsider the title of the video, SQL Server 2022 'Data Exposed'.... Data exposed sounds like a breach in this context
Perhaps REVEALED. Bob Ward has written books titled SQL Server/Azure Revealed.
@@aktanakhmetov I agree. Uncovered also works.
still not yet released
It’s not yet 2022 anyway :)
mas de lo mismo, solo existe azure para microsoft, no se de que me hablan con mejoras a sql server, oracle les lleva mucha ventaja