Topics
Started by
Posts
Last post
I'm trying to tune a big query. The starting point is a query with a query cost of 4.2, CPU time 4…
29 replies
I am observing a database perfoming very slow for all queries when compared to other database(7 tim…
7 replies
I'm trying to perform SQL query (used for paging) on a table but it's resulting amazingly slow. Why…
46 replies
I have a statement similar to: SELECT column1_output, column2_output FROM table1 t INNER JOIN …
3 replies
Hi folks, I have a sp: select top 20 a.employeeid as [ID], a.account, a.displayname as [Name], w.w…
6 replies
why I can't post any more? page crashed every time I tried to post. But this test post works! weird!
1 replies
Hi folks, I am learning index: here is what I found in DMV: object_idindex_iduser_seeksuser_sc…
6 replies
I've looked over the boards and not yet found an answer, is there a query that will tell me what tr…
2 replies
I'm at a loss on this one. We have a packaged application that's hosted on SQL Server. Throughout…
6 replies
I have a stored procedure that typically takes <10 seconds to run. It builds a dynamic sql state…
5 replies
Hi, I am examining query's executions costs (SELECT queries) using different indexes. it is known t…
29 replies
Hi, I have a where clause which will be used frequently in insert/update/select statements. The …
1 replies
Hello All, I am facing issue for Slow performance of one SP, I tried different ways to improve perf…
4 replies
I was asked by Ramesh to pass on this link to my SQL community. It contains more links to some leve…
2 replies
Hi, We are currently taking a small sample from a 12-million row table several times a day and we n…
11 replies
Viewing 15 topics - 1,291 through 1,305 (of 3,249 total)
You must be logged in to create new topics.