Question : I have a question about what would be the best way to set up SQL Server 2017 as […]
Tag: sql-server-2017
Query to polybase external table giving error “Access to the remote server is denied because no login-mapping exists.”
Question : we have successfully created all pre-requisite of creating external tables using SQL Server 2017 Standard Edition CU22 Polybase. […]
SSIS Transfer Login Task Error
Question : I have created an SSIS Transfer Logins Task. I have selected the SourceConnection and DestinationConnection and both valid […]
SQL Agent stopped recording history (SQL Server 2017)
Question : I have a Dev server that has been running without issue for at least 2 years. This dev […]
Monitoring Query which executes thousand of run/minute and is generally fast
Question : I am looking for some advise here on one of our SQL database server with below behavior- Queries […]
Struggling to create an efficient index for this query
Question : I am struggling to create an index for a query and unfortunately I cannot change the query at […]
Why is this faster and is it safe to use? (WHERE first letter is in the alphabet)
Question : Long story short, we’re updating small tables of people with values from a very large table of people. […]
Increased memory to server, but do I need to change page-file size?
Question : I’m running SQL Server 2017 on Windows Server 2012 R2 and have increased the memory from 256 GB […]
Why is the Read-Only Routing not functioning in this Availability Group?
Question : First off, my apologies if this has already been answered elsewhere. I have not been able to find […]
User info retrieval takes too long – ASP.NET Membership
Question : I have an application that has been taken from a sharepoint user control and converted to plain web […]