February 12, 2016 at 1:49 pm
Hello All,
I am more of a report writer but definitely trying to learn the Admin side. In Layman terms what does DBCC PINTABLE do?
Our company fears that this is causing a issue with updates and Inserts failing on our third party database. Is it possible that this could be the culprit.
Or would something like this have no effect on updates and inserts into tables?
https://technet.microsoft.com/en-us/library/aa258284%28v=sql.80%29.aspx
Sorry for sounding ignorant. I will continue reading on this but and good explanations would also be very welcome.
Thanks!
***SQL born on date Spring 2013:-)
February 12, 2016 at 1:52 pm
It does nothing anymore 🙂
http://www.sqlskills.com/blogs/paul/dbcc-pintable/
Cheers!
EDIT: Additionally, if powers that be want word from someone other than Paul, it's mentioned by MS as well.
From https://technet.microsoft.com/en-us/library/ms178015(v=sql.90).aspx:
This functionality was introduced for performance in SQL Server version 6.5. DBCC PINTABLE has highly unwanted side-effects. These include the potential to damage the buffer pool. DBCC PINTABLE is not required and has been removed to prevent additional problems. The syntax for this command still works but does not affect the server[/i].
(emphasis mine)
February 12, 2016 at 1:57 pm
Thank you sir that is exactly the info I was looking for!
***SQL born on date Spring 2013:-)
February 12, 2016 at 2:31 pm
Glad I could help!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply