Detecting Possible Parameter Sniffing Occurences with DMV

Hi All, Parameter Sniffing is a scenario which most DBAs had to handle at some point. Usually the main challenge is to detect it, as the toolkit to address it is well known and documented. To help in the detection phase, here’s a rather simple query that will just report queries which have a large…


Service Broker – Upgrade

  Avec la fin du support de SQL Server 2005 (12 Avril 2016) un grand nombre d’instances chez les clients doivent être migrées. https://www.microsoft.com/en-us/server-cloud/products/sql-server-2005/   Il existe plusieurs livres blancs et articles sur la migration de SQL Server mais peu d’entre eux évoquent le sujet tant redouté, … Service Broker ! SQL Server Service Broker…