Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Performance / June 2009

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
monitoring locks19 Jun 2009 08:32 GMT3
I having a query that returns data in 2 seconds (average).
Sometimes, the same query take 150 seconds, for no reason. Executing the
same query, it returns to 2 seconds.
I got this information using profiler.
How to make SQL Server choose a smarter query plan?14 Jun 2009 22:35 GMT7
We're having the general problem that -- in one customer's database --
the performance of the queries varies widely. I've found one example
which is easy to explain and which can be reproduced reliably:
SQL A:   SELECT * FROM table WHERE a = 1234 AND b <> 0
Performance Problem14 Jun 2009 22:33 GMT5
I am having problems when searching my database. I can choose to search in
any combination of: Title, Description or Tags. Searching for any combination
except Description and Tags gives subsecond response times. However, when
searching in Description and Tags (or Title, ...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.