1

Topic: Re: the Request is fulfilled that second that hour

.;
Well so a moon phase, not differently

2

Re: Re: the Request is fulfilled that second that hour

. wrote:

a name of the table temporal another, it  on spid sessions

It what for such focus?
And how it "is fastened"?

3

Re: Re: the Request is fulfilled that second that hour

. wrote:

Prompt as it is possible to stabilize fast performance of request, which almost completely from temporary tables?

To clarify why different runtime

4

Re: Re: the Request is fulfilled that second that hour

.;
If the global table there can and not in plans business, and in locks. Well and any plan to receive it is not problematic

5

Re: Re: the Request is fulfilled that second that hour

.;
PRINT @@ VERSION that returns?

6

Re: Re: the Request is fulfilled that second that hour

. wrote:

Here still rate  not on a physical disk, and on virtual which is in operative storage.

Well so at waitings look

7

Re: Re: the Request is fulfilled that second that hour

iap wrote:

.;
PRINT @@ VERSION that returns?

What for so? Here arguing generally a certain request, which that quickly it is slowly fulfilled

8

Re: Re: the Request is fulfilled that second that hour

Hupin wrote:

it is passed...
What for so? Here arguing generally a certain request which that quickly the Author is slowly fulfilled

put for this purpose a maximum of efforts. On temporary tables most likely indexes, , structures. Therefore there are no statisticans. The optimizer creates that wants. These temporary tables are made global to maximize probability of locks. And the disk with tempdb is made by virtual (probably, speech about a RAM-disk) that the data permanently fell out in a swap.

9

Re: Re: the Request is fulfilled that second that hour

. wrote:

it is passed...

, the crystal full-sphere is broken

10

Re: Re: the Request is fulfilled that second that hour

.;
Write OPTION (RECOMPILE) and go with the world

11

Re: Re: the Request is fulfilled that second that hour

.;
Well pretending to be the fortuneteller, at you 5 flows wait 6 that  not from for  all that could help the correct estimation

12

Re: Re: the Request is fulfilled that second that hour

. wrote:

it is passed...
Recompile here means does not help?

Why, helps. But the correct index is more logical

13

Re: Re: the Request is fulfilled that second that hour

And what all of you consider?
Somebody saw request, structure of tables or something similar?
The strange talk any.
And I am not assured that tempdb it is possible to allocate on a virtual disk in the last versions of the server.
That is, we deal any with 2000? Though, here I can and be mistaken. And, probably, it is unimportant...

14

Re: Re: the Request is fulfilled that second that hour

. wrote:

it is passed...
Indexes and  there and truth are not present, and what for structure you meant?
Whether  I understood that creation of indexes on temporary tables stabilizes the optimizer?

Indexes and  on temporary tables so, as well as on constant tables, help to build the optimal plan. If at you any table is simply a heap and to speak about an optimality difficult.
Under structure means primary keys and unique indexes. Knowledge of that the index is unique, as well as the knowledge of an amount of the data strongly helps with tables and the other statistics to the optimizer.

15

Re: Re: the Request is fulfilled that second that hour

TaPaK wrote:

.;
Write OPTION (RECOMPILE) and go with the world

And unless by operation it does not happen to temporary tables itself? It seemed to me,  always automatically .

16

Re: Re: the Request is fulfilled that second that hour

[V. Liseev] it is passed...
And unless by operation it does not happen to temporary tables itself? It seemed to me,  always automatically . [/quote]
Well so it most likely that removes a thread and interposes into this temporal and  and the curve estimation arrives. Well so in my crystal full-sphere it is told

17

Re: Re: the Request is fulfilled that second that hour

. wrote:

it is passed...
2012 enterprise

Well went and here took and forced down an intrigue! Never produce the server version, structure of tables, request.