When you mouse over measures in proclarity a text box appears with the name of the measure. Does anyone know a way to modify this to make it...
I want to modify the styletemplates.xml so I can add a template to the report wizzard. Is there a way to specify a header and foot in this file....
The button is missing on my Report Manager? I have all my reports in a project they were using a shared datasource so I switch one to use an embedded...
Is there a way not to send a subscriber Email when the report returns zero records? Thanx Adam
Bummer, I really liked that feature. Thanx Adam
I setup an Alert to Email me on Deadlock issues. It doesn't tell me a lot of information. Is there a way to return more about the process in the...
K, I do that but I can't right click the graphical objects in the execution plan anymore to create indexes or update statistics on that object...
I am trying to get used to Management Studio and my biggest frustration is in the execution plan. In query analyzer you could right click a table in...
Aren't pages that are inserted with an incremental key automatically put at the end of the current index? Isn't fillfactor just for when inserting...
I'm using 100% for the key is a sequential key. So each new row gets the next value. Thanx Adam
I had the issue again today. I was able to delve in more. There is a query in the stored proceedure that is switching execution plans to use the...
Here's a weird question. On the Index Primary Key there doesn't appear to be any statistics. Should I have statistics on this or since it is a key...
Thanx, I will try that out. Thanx Adam
It is not an identity column, the account app is on SQL 2000 but runs in 6.5 compatibility mode. It has a stored proc that actually keeps track of...
I have a primary key cluster index on a table (4-5 million rows) which is one of the bigger tables in our DB. Key field is incremented then inserted...
I have not tried that. I thought that might really hurt performance on our longer queries. Is that a good thing to do? Thanx Adam
Our ERP system is under a bit of load and I was reading up on some performance tuning articles. I was reading that complex queries that use Parallel...
I will look at the hardware, but the SQL Server Processors has the same name for all four processors. 2 being HT and 2 being physical. Thanx Adam
I want to turn off hyperthreading in SQL server. How do I know which processor is the HT processor and which one is the physical one. I would hate...
Thank you for all the input on this. One thing I do have in place is a disk defragment using O&O Defrag. It works with the 64K size. It allows me...
Separate names with a comma.
