<div>
you could create an index on the columns type, serial<br />
that will speed your query up<br />
what do you need this for?
</div>


<div>
I already create the indexes<br />
When i create a new bill with a predefined type, i need the max serial +1 &nbsp;to insert it for the new bill<br />

</div>


<div>
Try this one and compare the Query time.<br />

<pre><code class="code-1 nolinks" id="code-124050"><span>SELECT TOP 1 serial + 1 </span>
<span>FROM bills</span>
<span>WHERE type = 'x'</span>
<span>ORDER BY [PERA DIN] DESC</span>
</code></pre>
</div>


<div>
I will try all options and return ASAP<br />

</div>


<div>
Sorry about my first response<br />
<br />
Please change [Pera Din] to serial<br />
<br />
try the code below and see if it will give you a better response time. <br />

<pre><code class="code-1 nolinks" id="code-124053"><span>SELECT TOP 1 serial + 1 </span>
<span>FROM bills</span>
<span>WHERE type = 'x'</span>
<span>ORDER BY [serial] DESC</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
I have two columns 'serial' and &nbsp;'type' in table 'bills'<br />
I want to get the max serial +1 where type = x<br />
the standard statement:<br />
<br />
&quot;SELECT ISNULL(MAX(serial), 0) + 1 FROM bills<br />
WHERE type = x&quot;<br />
<br />
take a huge response time if there is a huge number of records.<br />
<br />
Is there any better idea?<br />
&nbsp;
</div>
</div>


Hi,
I have two columns 'serial' and  'type' in table 'bills'
I want to get the max serial +1 where type = x
the standard statement:

"SELECT ISNULL(MAX(serial), 0) + 1 FROM bills
WHERE type = x"

take a huge response time if there is a huge number of records.

Is there any better idea?
 

Auto Increment in MS SQL

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.