The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
2answers
519 views

MySQL InnoDB page_cleaner settings might not be optimal

Seeing this note in mysqld.log: [Note] InnoDB: page_cleaner: 1000ms intended loop took 15888ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.) There seems to be ...
0
votes
1answer
99 views

Is there a setting in MySQL that will allow you to see the columns of a table on a query, even if the table is empty?

When I am writing code to go with a certain MySQL query, I like to do a basic select statement to see the columns, and to perhaps see what data is available as a sample. Sometimes, the table I would ...
1
vote
0answers
23 views

SSAS - what could I monitor in SSAS to fine tune its memory settings?

This question is a follow up from the SSAS - what could be a good starting point for memory settings? What and how can I monitor the server resources in order to best identify the settings that I ...
1
vote
0answers
180 views

Changing Quoted_Identifier on existing Constraints / Rules / Procedures

I am currently working with an old-ish database on a 2008-r2 Server which uses a lot of objects that were created with Quoted Identifier set to off. I am mainly looking at these types: ...
0
votes
0answers
275 views

Cannot set ArithAbort to Off on SQL Server

I have 2 SQL 2012 servers. The settings are exactly the same, but on one I can set ARITHABORT to Off but no matter how I try I can't do the same on the second server. The only difference I could find ...