11

I would suggest you follow what the sp_blitz recommended. You can change the option to CHEKSUM. Checksum might be able to detect more problem that torn_page. Torn page allows you to detect whether page was successfully written to disk or not. It would not check what is inconsistency inside the page. While checksum performs more thorough checks. Having said ...


3

I think it is fine; the documentation was just written long before Windows 10 was released and hasn't been updated (I've sent in a note that it should be corrected). In fact it is listed as fully supported here, with no special caveats for MDS. I have never heard of any components of SQL Server 2014 having any compatibility issues with Windows 10.


2

Sounds likes you would be best served by using another Query, not a Table. In Access you can use a Query much like a Table, even use a saved Query as a source in another Query. If you are careful you can create an Editable Query, in which changes you make to the Query results directly affect the Base Table. It can be tricky to do so when you have more ...


2

In short: The official answer is to use the new proc mdm.udpEntityStagingBatchTableCleanup to clean up entity staging tables, but in practice, DELETE or TRUNCATE should work just fine (or might be necessary), as long as you understand your batch detail. I found reference to a SQL 2012 patch that adds 3 stored procedures to MDS, including the one I need: --...


1

I think if you can use SQL Server 2017, this new function Trim() Can help you write it better. if you insist on using DQS for this matter, I think this article can help you find your way. Sorry that I couldn't write it for you. Hope it helps.


1

Thanks to @sqlworldwide for pointing me to this question, which worked https://stackoverflow.com/questions/23358903/troubleshooting-master-data-services-mds-permission-authorization


1

Is there a way to find out what queries are run the most against a particular table? T-SQL – Get a Historical Record of SQL Statements Hitting a Table This query checks the sys.dm_exec_query_stats system view and the sys.dm_exec_sql_text table valued function. Also because these are system tables, you will need to be logged into SQL Server ...


1

If your environment is currently heterogeneous or you're moving in that direction already, look into using an enterprise service bus to abstract away the implementations of each database. If it isn't, then I would advise against doing so unless absolutely necessary -- this will complicate your environment a lot, especially as you start adding in HA/DR ...


1

Since Master Data Services is available on the 64-bit editions of Business Intelligence and Enterprise only, you can leverage partitioning for data management. You can partition the data by month or a quarter or year (depending on your requirements). This way you have a solid archival strategy and you can load new data into new partitions. You can have ...


1

Snapshots do have some performance overhead. With a dozen snapshots you could have up to 12 additional pages written to disk for each page written to the main DB, depending on your write patterns. Consider what you want to do with these snapshots. If they're simply for putative future auditing then do a backup and get them off your production server. You ...


Only top voted, non community-wiki answers of a minimum length are eligible