OS - Getting back server disk space

Disk drives filling up - here are some things to look for

Unaccounted couple of gig missing?

1. This can be your pagefile.sys (virtual memory) You can move it to another disk or - for a performance increase - split it across multiple disks (if they are on separate spindles) - there is a good article on this at http://members.shaw.ca/bsanders/WindowsGeneralWeb/RAMVirtualMemoryPageFileEtc.htm

• In Explorer go to Tools -> Options -> View and make sure "Hide protected OS files" is unchecked and "Show Hidden files" is selected
• Look in your c:\ directory and you can see the system files
  
• Go to My Computer -> Properties -> Advanced Tab ->Performance options -> Virtual Memory
  
• Change the size and location of the virtual memory

2. Your disk may be fragmented or have errors. There are tools to correct this. Go to explorer -> right click -> Tools tab

Log Files
Windows log files are located C:\WINNT\system32\LogFiles. Clear out all but the last month

Publish Post

Properties -> Tools tab

Reporting Services - Setting up Drill Downs

Reporting Services - Conditional Formating

Reporting Services - Ordering Matrix Columns

Column header values from a field you are grouping on will be semi randomly in a matrix report. displayed if specified as follows.

1) Right click on the field to be ordered and open "Edit Group".

dffds
2)
dsfdsfdas fdasf dasf asd fdas fadsaf asdf dasf das fdas fads fda fdsa fdasf asd fasd fasd fha iof oasdjfio;asdjio;f asdiofuioaufiopduaiopfduiopa fuiopdasuiopfasduiopfasdu fuasdiop fuiopasdu fiopasdu fiopasdufi uasdiop fuai





dfsfsdfs

fsdfsdfs

sdfsdfsdf

Reporting Services - Exporting reports

I keep getting asked how to get a report off a report server. It is not very intuitive but here is a comppilition various email I have had to write.

Exporting the report
This describes how to export report server reports from one server to another and/or how to export the source code of existing reports
1. Go to the folder with the existing report you wish to export and click on the “Show Details” button.
2. Click on the Edit Properties for the report
3. Click on the Edit link under the Report Definition sub heading
4. Choose the Save option – this will export the report in rdl format

Import Directly of Extract and Build the code
At this point you can go to Reporting Services 2005 and import the rdl file directly or else you can rebuild the report in Visual Studio so that you will have access to the source for modifications.

Import Directly
1. Open SQL Server 2005 Management Studio
2. Choose Reporting Services as the server type and log onto the server you want to upload the report to
3. Move to the directory to import the file to
4. Right click -> Import file – choose the .rdl file exported previously
5. Set up appropriate data sources and permissions using the Report Manager Web interface
Extract and Build the Code
1. Open either:
a. SQL Server Business Intelligence Dev Studio (Programs->Microsoft SQL Server 2005 ->)
b. MS Visual Studio 2005 (Programs-> MS Visual Studio 2005 ->)
2. File->New->Project->Report Server Project
3. Name the project the same as the original