Parameter sniffing has a weird symptom which can take your hours to find out what actually is happening. The stored procedure you created is running on one side, but when you deploy it on another machine or server, it never ends executing despite the fact that everything is the same.
This problem usually occurs when the query contains LIKE condition....
About Me
- Steven Luck
- Is an ordinary man, with a little knowledge to share and high dreams to achieve. I'd be glad if I can help others, 'coz the only thing for the triumph of evil is for a good man to do nothing.
Popular Posts
-
Have just got a lovely blog award, my second one, from a friend, Mona ^^ But there is a rule to accept this award.. hehehe... Post it on yo... -
Are you learning Assembly language , and confused about how to compile assembly file? TASM20 is one of assembly compilers that works with ... -
Error : Xml data type is not supported in distributed queries. Remote object ' <ServerIP> \ <ServerInstance> . <Database...
-
Continuing my last post about compiling and running assembly file , it is actually possible to easier compile and run assembly file from Tex... -
If you are trying to update a table containing XML column via Linked Server in SQL Server, and you are not able to, you are not alone. There...