Question : What is the difference between these two “Connect SQL” permissions in SQL Server 2012? Answer : While I […]
Tag: sql-server-2012
Deny certain user from updating certain rows [duplicate]
Question : This question already has an answer here: SQL Server Row by Row Access (1 answer) Closed 2 years […]
How to hint Remote Scan operator to estimate more than 10000 rows?
Question : I need to read data from a linked server and insert into a local table. I need to […]
Understanding MAXDOP behaviour for queries going parallel
Question : For my current server as below 4 Sockets with 10 cores per socket and 20 logical processors per […]
Execution Plan is NOT using INDEX, It uses Table Scan
Question : I know when it comes to using an index or a table scan, SQL Server uses statistics to […]
solve high stolen memory
Question : I’ve a SQL Server 2012 SP2 with max memory set to 13GB but there is 8GB of stolen […]
Can I combine SELECT TOP() with the IN operator?
Question : I was wondering if there is a way for a SELECT query to be made on each matched […]
Should I create two endpoints for two availability groups on the same SQL Instance?
Question : I have a two node cluster running SQL Server 2012. I want to create two Availability groups within […]
Optimize Subquery with Windowing Function
Question : As my performance tuning skills never seem to feel sufficient, I always wonder if there is more optimization […]
Implementing gMSA account for SQL FCI
Question : I have a question on implementing gMSA account for managing authentication to SQL server. Our goal is to […]