Grant Fritchey (2/29/2016)

---

In SQL Server 2012 and earlier, if the value falled outside the range of statistics, the optimizer assumed that the number of values returned was 1 row. This...

Grant Fritchey (2/29/2016)

---

Sorry, been on the road.

First, you have OPTION RECOMPILE on your query. Whether your update your statistics or not, you're going to get a recompile every time that...

I tried to logon from another computer and I found in windows log this below, but only one time and if I tried again from my computer, sql error was...

If you have set linked server, on current server execute something like this.

INSERT INTO DATABASE.schema.TABLE

SELECT TOP 1000 * FROM LINKEDSERVER.DATABASE.schema.TABLE WHERE ...

if you dont have try...

So I tested again..

I executed query before updated stats :

Select * from TABLE1 A

LEFT JOIN TABLE2 B

ON

A.1PKCOLUMN=B.1PKCOLUMN

AND A.2PKCOLUMN=B.2PKCOLUMN

WHERE A.1PKCOLUMN='DATE' AND A.1PKCOLUMN+A.2PKCOLUMN>'DATE+SEQ'

OPTION(RECOMPILE)

SET STATISTICS PROFILE showed wrong ex.plan with second condition...

My opinion is that this kind of work is good do during some breaktime or maintenance time in that case something happen or your work is 24/7 ?

Check if these...

So I needed update statistics again with FULL SCAN.. but only on TABLE1,TABLE2

now result is ok....

So Do I have update statistics with full scan ? now I have...

So problem looks like still ex plan from first executions even if I use OPTION(RECOMPILE)

Also tried to use DBCC FREESYSTEMCACHE('SQL Plans') but data was same,,,

With different tables which has...

Brandie Tarvin (2/26/2016)

---

Orlando Colamatteo (2/25/2016)

---

How many tables? I am thinking a simple Transactional Replication Publication on Server B subscribed to...

I think that you have to write whole procedure. will be better for understanding why will be catch and when ..

And I am not sure if this is problem in...

interesting topic also for me, thanks

If I good understand you want to know how much sql really use..

I use these query

First is Free Memory,Target and Total SQL Memory ... and second is Total memory...

So with this query is without problem and update statistics will be helpful...

select * from TABLE1 (NOLOCK) A

LEFT JOIN TABLE2 (NOLOCK) B

ON

A.1PKCOLUMN=B.1PKCOLUMN

AND A.2PKCOLUMN=B.2PKCOLUMN

WHERE A.1PKCOLUMN='DATE'...

do you think like this ? work for me without error , but dont have results

you had more '

DECLARE @search AS VARCHAR(50) = ''

DECLARE @sqlCommand VARCHAR(2000)

SET @sqlCommand ='USE [?]...

Hello,

based on my experiences when I used linked server I found these notes..

- if I have few rows without join , I did directly select from linked table

- if I...