Without seeing the execution plan itself, I'm just guessing. However, it's likely that you're seeing lookups because of foreign keys. Modifying columns that don't contain any foreign keys will...

Can you share your execution plan here?

Hi - I setup a new SQL FCI in Azure.  Two newly created VMs with SQL 2019 installed.  Cluster validates successfully and i configured the Load Balancer per the...

How many records does the procedure return during both executions? Is the count same?

Are you...

• This reply was modified 4 years, 10 months ago by VastSQL.

This is a...

Hi all,

I need to create a job to dynamically script out indexes and some other objects from Server A and apply them on Server B. They are linked through...

Hope the Listener did the trick for you.

The listener act as a single name to both the nodes. Use...

I am having the same problem.  my sql 2016 cluster is on azure.  i have opened 1433 tcp and 1434 udp ports in firewall and in azure network security...

We have identified a query which was running on a huge table . The query was selecting the whole table (*) without an index on where clause and the values...

I am looking to export data from SQL 2019 to sql 2017. What if the tables have primary key and foreign key relationship how would be the export is...

• This reply was modified 4 years, 10 months ago by VastSQL.

I am a newbie to SQL Server administration and config. Apologies if I appear to confuse/mix terminologies here.

I am trying to find a way to take a snapshot...

I was working on with requirement to load balance the traffic coming from application to secondary SQL Server replicas in an Always on Availability group. Read-only routing refers to...

• This reply was modified 4 years, 10 months ago by VastSQL.

Thanks! Sorry I wasn't clear, windows cluster is already configured. So I am looking to find how many more IP's is needed for install and configuring for SQL Server...

• This reply was modified 4 years, 10 months ago by VastSQL.

Mainly you need to look for what's using memory in such a way that the pages will be flushed. Again, if everything else is fine, this is probably just...

And you're seeing exactly why PLE is a horrible measure, standing on it's own. In combination with other measures, it may tell you things. Just PLE, nope....