Move DB files

For some reasons, you may need to change DB file location from one to another.
As i can think of, there are at least 3 wways.
1.detach DB, move files, attach
2.backup/restore(indicate a new location when restoring)
3.This is a way I prefer to use but seems it does not have a formal name.
scripts for your reference
use USSut003
go
–tell SQL server, you wanna change the physical place for one file(could be log or data)
ALTER DATABASE USSut003
MODIFY FILE (NAME = ‘USSut003_PG_DAT_1’, FILENAME = ‘J:\BIILAND\MSSQL\DATA\USSut003.MDF’)

use master
go

ALTER DATABASE USSut003
SET offline

–Physical move data from one place to another

ALTER DATABASE USSut003
SET online

All done.

Advertisements

How to repeat the column header for tablix in SSRS2008 R2

Issue: “When creating a tablix control with Repeat Column Header set to true the Column Headers are not repeated”.

In the tablix control, when click row header handle then right click it to set the “Repeat header column in each page” in the “tablix property”, as we all ses the option name is quite self-explanation but unfortunately it does not work in most cases.

Below the steps are listed to solve this.

1) Select the Tablix that you want to repeat column headers for by clicking on it.

2) At the bottom of the screen, find the “Row Groups” and “Column Groups” section.
3) Click the small drop-down-arrow on the right side of that section.
4) In the “Row Groups” section, locate the top-outermost “static” row and click on it.
5) In the properties pane, you need to set the following TWO properties:
a) RepeatOnNewPage = True
b) KeepWithGroup = After

SQL Server (BI) Training Log

Only for log….

 

Year of 2010

  • July 17, 2010– SQL Server 2008 R2 (Course 6231, 6232A), Public training, Shanghai
  • Aug 28, 2010–SQL Server 2005 BI (Courses: 2791, 2792, 2793),Client-Customized Training, Acxiom Corporation, Shanghai
  • Oct 23, 2010–SQL Server 2008 R2 Training (Course 6231, 6232A), Public training, Shanghai
  • Dec 1, 2010–SQL Server APO Training (SQL 2008 R2 new features), Public training, Shanghai
  • Dec 27, 2010–SQL Server 2008 R2 BI (Courses: 6234A, 6235A, 6236A),Client-Customized Training, Microsoft Corporation, Beijing

 

Year of 2011

  • Mar 25, 2011–SQL Server Hands-On-Lab (SQL 2008 R2 new features), Public training, Shanghai
  • Apr 16~19, 2011–SQL Server 2008 R2 (Course 6231, 6232A), Public training, Shanghai
  • May 19~22, 2011–SQL Server 2008 R2 BI (Courses: 6234A, 6235A, 6236A), Public Training, Shanghai
  • July 3, 9, 10, 2011–SQL Server 2008 R2 BI (Courses: 6234A, 6235A, 6236A),Client-Customized Training, Metlife Corporation, Beijing
  • July 4~8, 2011–SQL Server 2008 R2 BI (Courses: 6234A, 6235A, 6236A), Public Training, Beijing
  • Aug. 17~19, 2011–SQL Server 2008 R2 HOL (Hands On Lab, Exam Instruction 70-432 and 70-450), Public Training to MS partners, Shanghai
  • Aug. 31~Sep.2, 2011–SQL Server 2008 R2 HOL (Hands On Lab, Exam Instruction 70-432 and 70-450), Public Training to MS partners, Chengdu