Viewing 9 posts - 1 through 9 (of 9 total)
Thanks for the response Jo.
The server has 960GB with the max memory for SQLServer set to 839GB. That along with no indications in the RING_BUFFER_RESOURCE_MONITOR of IndicatorsSystem with RESOURCE_MEMPHYSICAL_LOW make...
November 26, 2020 at 12:48 pm
Hi,I repeatedly performed a SELECT from sys.database_permissions. You could probably do this manually, but I used a loop (see below). From memory, I think I had to run it a...
July 11, 2018 at 1:25 am
Thanks to Jonathan Kehayias for mentioning that there is a known issue with SQLServer 2014:
April 4, 2017 at 7:27 am
Hi,A quick update. The server has been rebooted and things are looking more like you'd expect:
CPU - 0%There are now thousands of plans in the...
March 23, 2017 at 8:47 am
Yes, that makes sense. As you say, unfortunately it’s a bit inconvenient – but luckily I have some other options to pursue in this case. 🙂
Thanks for your...
April 16, 2015 at 8:40 am
Your earlier comments nudged me in the right direction. 🙂
Yes, checked the QueryPlanHash and they were the same.
I’ve also managed to get access to a few more instances and I...
April 16, 2015 at 8:24 am
Thanks for the replies.
I've just done another quick test (just on one instance - 2008):
Created a table TEST (checked it's object_ID)
Executed a select against the table and got the query_hash...
April 16, 2015 at 7:30 am
This is a nice bit of code on smaller chunks of XML.
It might also be worth adding exec "sp_xml_removedocument @idoc" to the end of the procedure to free up memory.
April 8, 2015 at 1:51 am
If you just want a numbered list from a table you could use the ROW_NUMBER() function:
SELECT col1, ROW_NUMBER() OVER (ORDER BY col1)
I've not used it much myself but it...
April 28, 2008 at 10:10 am