Ok not much of a response - so I decided to use our load tool and test this for myself with the following results. I have 2 environments, ENVA and...
A couple of quick questions (probably easy) on deploying reports using Visual Studio. I can deploy reports to my localhost very simply but when I...
here is a summary of the problem and the steps taken to resolve the problem - if anyone else encountered this problem or anyone know of options...
Has anyone used Reporting Services outside of an Intranet Environment where performance was an issue. If so could you give me a few brief pointers. I...
Has anyone used this outside of an Intranet Environment where performance was an issue. If so could you give me a few brief pointers. I have noticed...
IS the time taken to reindex proportionate the scan density of the index, i.e. if you have a table of 40 million rows, and plan to reindex an...
Microsoft have now analysed the log files, dumps and results from sp_who and sysprocesses and said, "yes, its a problem with parallelism, some...
Hello to all. After spending most of the day with Microsoft, we have identified the problem (as suggested by many of you) as an issue with...
SQL CLustered Box is 4 GB memory, 8 CPU, advanced 2000 server. I think the Threads of the SPID in question are getting deadlocked on resources and...
Its not a recompile of the proc I had considered that option, I had read the article you suggested and had checked the actual waitresource and its...
Have read this already, thanks for help. I understand what the problem is, but still dont know whats causing it, Any suggestions on how to actual...
Following on from my thread http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2275 I have located that the problem may be blocking, I...
It uses all available processors and the cost value is 5 (default)
Thanks for suggestions. I thought it might be parallelism as the box is an 8 CPU box, with 4GB of memory. Is there anyone of determining the...
After our application has crashed, I am trying to trace a problem. I run sp_lock and it shows me there is severe locks on two tables (120,000 row...
Thanks, good link on indexed views. Using the view to partially replace complicated stored proc which was taking to long to return contrived data....
I have tried to create a clustered index on the view - but get the following error 'Msg 1941 - Nonunique clustered index cannot be created on view...
Thanks, though I suppose if I had read the error correctly I would have figured that out myself!
The function is SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS OFF GO CREATE FUNCTION dbo.ufn_CanCancelBatch ( @pi_UserOIDObjectID,...
I am trying to create an indexed view. I have the correct syntax for the view but as it references a User Defined Function I need to amend it. When I...
Separate names with a comma.
