Solved

Speed up - Microsoft SQL database

Posted on 2010-09-01
6
481 Views
Last Modified: 2012-05-10
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 ?

0
Comment
Question by:radut
6 Comments
 
LVL 9

Expert Comment

by:shalabhsharma
ID: 33578942
0
 

Author Comment

by:radut
ID: 33579104
All that i know ..
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 33579187
What does your request look like?  
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:radut
ID: 33581041
SELECT [Domain]   FROM [tbl_attributes] where Attribute ='meta' and AttributeValue ='Title'
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 33601832
Post your CREATE TABLE SQL statement and the CREATE INDEX for all the indexes.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 34114013
I suspect you inadvertently selected my comment as a solution in error.  Please post a message in CS to have this changed.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question