Topics
Started by
Posts
Last post
I just created a little script to log response times during the day of several SQL 2000 & SQL …
2 replies
I am using SQL 2005 x32 with SP2 installed. The Access database is connected to the SQL Server usin…
8 replies
we have a server that is slowing way down after running for a few hours. a query that would normall…
42 replies
Hi all. I'm supporting a SQL 2005 DB (around 18GB), where on top sits Microsoft Dynamics NAV 5.01. …
4 replies
if you receive any error related to query cost you can use exec sp_configure it will display d…
1 replies
how to defrag the table which has no indexes.
2 replies
If I have a query indexed to the point that its estimated execution plan basically looks like 3% in…
6 replies
Hi All, I came across a typical issue in my data warehousing solution. We are providing a backup jo…
4 replies
select * from main_table m (nolock) where exists (select 's' from childa a (nolock) …
4 replies
I've been having a weird problem as of late. I have a DTS Package (also tried converting it to SSI…
2 replies
Hi all, I got a question regarding adding plan guides I am using Microsoft's Dynamics CRM 3.0 and o…
13 replies
Dear Gurus, Please suggest me to Speed up this Sp. I checked it is taking around 15 mili sec. Still…
5 replies
Hi, I have a table with 100 M+ rows. As the table grows, the select queries are getting slower. In …
17 replies
Hello, Could someone comment on or direct me to any documentation regarding database compatibility …
9 replies
Hey all, I'm taking a decent performance hit due to having an index scan instead of seek ... my ind…
24 replies
Viewing 15 topics - 2,821 through 2,835 (of 3,249 total)
You must be logged in to create new topics.