Question : Closed. This question is off-topic. It is not currently accepting answers. Shopping list question – questions about which […]
DbaFix
Does SSMS v17 allow user input in Python scripts?
Question : With the introduction of Python feature shipped with SQL Server 2017, I would like to know if anyone […]
How to create user that can access to “master” database
Question : Recently I have created a TABLE that is under Database > System Databases > master > Tables > […]
RID and Key lock on same object by a Select and Delete query
Question : To be specific how did the select query (spid 128, on the left) is able to acquire a […]
DROP LOGIN fails on SQL Server 2014
Question : We have a database with an owner ‘dbowner’. Our install procedure drops the login for user ‘dbowner’ and […]
How to efficiently design Firebase database for Home service Booking application? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Processor affinity for SQL Server on vmware
Question : A while ago a consultant said that I should set processor affinity when I’m running SQL Server on […]
Running identical queries in sysbench
Question : When benchmarking using sysbench and utilizing concurrency (multiple threads) for example on a table with 1,000,000 records, does […]
Best Practice For Data Views with Linked Server in SQL Server
Question : In SQL Server, I have to design a View that I can map on a DBML file in […]
How to save result from a Stored Procedure in a Linked Server to a variable or table?
Question : I need to read the results of a stored procedure in a linked server, and store them in […]