Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2012
OS:
Windows Server 2012 R2
Network:
Windows Server 2012 R2
Virtual environment:
Hyper-V
>>>Or simplify your query. What edition of SQL Server?
>>>
>>>
>>>>I need something more powerful :)
>>
>>the query is very simple join.
>>the issue is this:
>>on a sp
>>declare a variable table
>>uses it ... no problem.
>>
>>declare the variable table with a primary key and sql stop working.
>
>How many records you insert to variable table?
>
>MartinaJ
I know that with a few lines is not appropriate to add an index.
99% 10 records,
but in rare cases can be 10,000.
The procedure performs one operation of the operator ( save document ),
then pay price microsecond almost always
and gain a few seconds in the worst case improves
his experience in the use of the application.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement