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...
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...
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...
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...
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...
How do you switch this to be on. If you do sp_help <tablename> the 8th column returned is "TrimTrailingBlanks". I want to be able to switch this to...
Hello I have a stored proc which sometimes is using a hash/match rather than a bookmark lookup depending on the quantity of data in the database (or...
I am trying to optimise a stored proc to remove table scans and would like anyone to provide a rational explanation to the problem I am about to...
Hello I have the following statement INSERT INTO TableA (OID, ReferenceField) SELECT MyOID, <Sequence>, DependantField, Otherfields FROM TableB...
Has anyone successfully managed to create DTC transactions on a clustered SQL database? We are experiencing problems trying to get the DTCs to work....
I use a stored procedure shown below to reflect the current locks on a specific table within a specific database, is there anyway I can tell add in a...
Is there anyway of outputing from a storedproc what the current isolation level is? i.e. inserting into a table or "print" the current isolation...
I am working on a multiuser 3 tier app, (UI and midtier in .NET), and DB is SQL server 2000 (SP2)<br />While doing concurrency tests, we are noticing...
Separate names with a comma.
