<div>
<a href="http://blogs.techrepublic.com.com/datacenter/?p=173" rel="ugc">http://blogs.techrepublic.com.com/datacenter/?p=173</a><br />
<br />
<a href="http://stackoverflow.com/questions/582333/best-way-to-speed-up-ms-sql-server" rel="ugc">http://stackoverflow.com/questions/582333/best-way-to-speed-up-ms-sql-server</a><br />

</div>


http://blogs.techrepublic.com.com/datacenter/?p=173 [http://blogs.techrepublic.com.com/datacenter/?p=173]

http://stackoverflow.com/questions/582333/best-way-to-speed-up-ms-sql-server [http://stackoverflow.com/questions/582333/best-way-to-speed-up-ms-sql-server]


<div>
What does your request look like? &nbsp;
</div>


<div>
SELECT [Domain] &nbsp; FROM [tbl_attributes] where Attribute ='meta' and AttributeValue ='Title'<br />

</div>


SELECT [Domain]   FROM [tbl_attributes] where Attribute ='meta' and AttributeValue ='Title'


<div>
I suspect you inadvertently selected my comment as a solution in error. &nbsp;Please post a message in CS to have this changed.
</div>


I suspect you inadvertently selected my comment as a solution in error.  Please post a message in CS to have this changed.

<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
I have a database width 145 million posts in a database, when i do a request it take about a minute and 20 sec, that is LONT TIME !!!<br />
<br />
Whau do i speed up my database ?<br />
<br />

</div>
</div>


Hello

I have a database width 145 million posts in a database, when i do a request it take about a minute and 20 sec, that is LONT TIME !!!

Whau do i speed up my database ?



Speed up - Microsoft SQL database

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.