Topics
Started by
Posts
Last post
This seems simple enough. SELECT DISTINCT orderID, orderNo, source FROM eventitems_rob WHERE event …
2 replies
I'm getting an index seek on this, but it's taking up about 70 percent of my query time. UPDATE #ev…
4 replies
The statement below takes 2 minutes to execute (table scan). So, I try adding a non clustered on a…
2 replies
I'm having a bear of a time trying to come up with the best indexes for this one proc and one table…
2 replies
I recently installed TFS and reports are taking long to generate. I'm using the default cube that c…
3 replies
I am new as DBA, I need to know which are the best practices for SQL Server 2000, what can I do to …
5 replies
I'm new to troubleshooting performance issues with SQL 2005 and I'm having a problem with a blockin…
2 replies
Are there any performance benefits of using CROSS APPLY OVER INNER JOIN? or vice versa? Or are they…
15 replies
Hi, I am using Linked Server for executing SP's on remote Server. And I have configured SQL Job for…
3 replies
I have a query that runs fine if I do not include Non-Clustered Indexed column in WHERE, but if I i…
7 replies
Hello gurus, I want to create a view with the option 'schemabinding' so i can be able to add an in…
3 replies
This isn't really about performance tuning. But, since I'm here... I have a trace that I want to st…
12 replies
When DTA creates index on large joins, does it analyse each table based on the entire query, or jus…
10 replies
I have a table with two indexes on it. The table and two indexes are: create table member ( ) creat…
11 replies
Im running a select statement on a table, with no ORDER BY clause, but the execution plan is still …
4 replies
Viewing 15 topics - 2,191 through 2,205 (of 3,249 total)
You must be logged in to create new topics.