Sean Lange (11/29/2012)

---

There is the rub. The system doesn't see it as wasted space. Do you have lots of heaps in your system? Can you add a clustered index to...

Thanks both for your responses regarding the heap. I guess I'd like to find a way to detect if the same is happening on other tables too (with a big...

Thank you both for your quick replies! I've created a clustered index and now the table reports as being 600MB as expected so that's great.

Just wondered why the sp_spaceused did...

Thanks for that!

A scheduled job would certainly be most suitable but i think for a change like this i would rather be on-hand to know what is going on. We...

We only load a relatively small number of records each night so they are loaded as an append to the existing table. I had thought about reloading into a new...

Thanks for that. The other SQL server i am thinking of belongs to a sister company running similar tools and processes to our own. I'd like to see if these...

I'm not looking to make changes to system setting as such... maybe just trying to understand what i'm looking at. I'd like to get a baseline value for a system...

Ninja's_RGR'us (9/12/2011)

---

Can you run this version?

GO

SELECT

optz.counter

, optz.occurrence

, CONVERT(DECIMAL(18,2), optz.value) AS AvgValue

, conf.name

, conf.value

, conf.value_in_use

,...

Thanks to both of you for your guidance on this. I certainly believe that tuning will bring great benefits here! I just need to prove it! 🙂

Are there any of...

It is primarily a SQL server for data warehouse applications based on the IBM Cognos 8 toolset. So within that toolset the majority of SQL interaction we have are read-only...

I can... attached

Chris

Please find attached the output from the first query.

Unfortunately I do not have the permissions to be able to run the second query (changing the config etc.).

Many thanks for the...

Our SQL Server is used purely for relational queries (the vast majority are not even ad-hoc queries too but pre-authored reports in our reporting solution - IBM Cognos 8). If...

Thanks for the help! It's very much appreciated.

Results for the query you sent are below (Sorry but don't know the best way to post them so I've posted the text...

Thanks for the links - they are certainly detailed and ones that i will give careful consideration to.

At the moment however, I am looking for a little guidance on...