Topics
Started by
Posts
Last post
Hi, We have SQL Server 2005 EE x64 with SP3 on Windows 2003 EE x64 with SP2 16 GB of RAM. Max memor…
3 replies
hi all one of our production servers slows down greatly through out the day, it has a backend of s…
19 replies
Hi below is my sql stored proc which takes a hell lot of time for execution of almost 30min. Is the…
3 replies
Hi, I am running Store Procedure in sql server 2005 but sometimes i see deadlock error. Could you p…
9 replies
Hi can any one help to find the query list which ran from particualar date to dar.. this query retu…
1 replies
Hello, Can I set the rule that looks at long running SQL jobs to have different thresholds for each…
1 replies
Hi friends, Is there a way to tune this view by anyway? CREATE VIEW [dbo].[servew] AS select TOP …
6 replies
I'm playing around the index_usage_stats DMV to learn it. there are two fields: user_seek and user_…
2 replies
Hi All, I am trying to understand the dm_exec_cached_plans contents and try to reduce the memory ut…
1 replies
I recently migrated our SQL server from a 32-bit Windows Std 2003 with only 4GB of memory to a bran…
10 replies
Hi I work for the NHS and we have a server running Server 2005 R2 Standard x64 Edition on a Windows…
14 replies
I am moving databases to a dedicated server running: Windows Server 2003 R2 Enterprise Edition 64-…
24 replies
Hi All, Appications are running slowly, If any query's or sp, will take much more time to execut…
9 replies
I done Rebuild On Non clustered Index, before rebuild on my index, framentation percentage is 80%, …
5 replies
Hello Guys, Do you recommend any book to learn and be expert on query tuning and optimization ? Is …
2 replies
Viewing 15 topics - 976 through 990 (of 3,249 total)
You must be logged in to create new topics.