All Questions
Tagged with tuning sql-server-2008
5 questions
2
votes
1
answer
218
views
Ideas how to make this query faster?
I have the following query:
SELECT TabPohybyZbozi.ID,
TabPohybyZbozi.NazevSozNa2,
TabZakazka.Nazev,
TabDokladyZbozi.DatPorizeni,
TabPohybyZbozi.IDDoklad
FROM ...
- 977
3
votes
1
answer
2k
views
How to monitor load on database server
Could anybody please suggest me a way to monitor the load on my database server?
What perfmon counters should I monitor on daily basis and confirm that load on the server is increasing day by day [or] ...
- 157
0
votes
2
answers
856
views
Tuning query to remove joins for reporting
This is the query I was sent. There is currently no data in the system as I was converting this query from teradata to SQL server.
SELECT user_id FROM user_table
LEFT OUTER JOIN
(
SELECT user_id , ...
- 316
5
votes
2
answers
5k
views
What can I do to speed up this SQL Query?
I've created this SQL query with the help of @Dems :-)
Here is some detail, I tried to make a SQLFiddle but I kept getting errors with my variables... This works in Sql Server 2008... My question is,...
- 151
10
votes
2
answers
4k
views
DTA Recommends to CREATE STATISTICS
I just ran a T-SQL query through DTA and one of the recommendations is to CREATE STATISTICS on one of the columns that is part of many of the queries in the SQL code file.
My question is, how exactly ...
anon