adding secondary database file

Question: When you add secondary files to an already
existing database does SQL automatically stripe existing
data across the new files or only when new data is created?I believe only if you add new data, or do things like rebuild a clustered
index (assuming both files, and the table, are in the same filegroup).
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"John Gossett" <jgossett@.nwedge.com> wrote in message
news:008e01c3c666$b3fbe6e0$a601280a@.phx.gbl...
> Question: When you add secondary files to an already
> existing database does SQL automatically stripe existing
> data across the new files or only when new data is created?|||SQL uses a process called proportional fill. It tries to keep each of the
data file the same percentage full. It does this by writing all new data to
the new file until it is as full as the existing data file..
It does NOT re-balance the existing data. You must do this by drop/re-create
the clustered index or export/import the data..
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John Gossett" <jgossett@.nwedge.com> wrote in message
news:008e01c3c666$b3fbe6e0$a601280a@.phx.gbl...
> Question: When you add secondary files to an already
> existing database does SQL automatically stripe existing
> data across the new files or only when new data is created?

Adding Borders in a matrix report RS 2005?

Hello,

I am wondering if anyone has come across a problem when you try to get formatting like this one below in a matrix report, RS 2005. Basically, I would like to have a border for every question and its related columns. Any help is greatly appreciated.

Thanks!

1. Question

1.SubQuestion

Data

2.SubQuestion

Data

3.SubQuestion

Data

4.SubQuestion

Data

5.SubQuestion

Data

2. Question

1.SubQuestion

Data

2.SubQuestion

Data

3.SubQuestion

Data

4.SubQuestion

Data

3. Question

1.SubQuestion

Data

2.SubQuestion

Data

3.SubQuestion

Data

Hello,

I played a little bit more today with the challenge above and was able to come up with some conditional formatting for a SubQuestion column which may be helpful in creating a border line for. So in RS 2005, I select a SubQuestion cell and go to View/Properties/BorderStyle/Top and paste the following expression statement: =IIF(LEFT(Fields!SubQuestText.Value,1) = "1", "Solid", "None") which copies automatically to BorderStyle property that looks like this:None, , , =IIF(LEFT(Fields!SubQuestText.Value,1) = "1", "Solid", "None") BorderColor property is set to Black. By using the following statements above, I would like to create a border line above every Subquestion cell value that starts with 1. Right now, this code generates a top border for the last question. Maybe someone has some ideas how I could generate a top border above Subquestion cells including values starting with "1"?

Thanks for your help!

|||

Hi!

I have a similar problem, did you get any solution?

Thank you!

Adding Borders in a matrix report RS 2005?

Hello,

I am wondering if anyone has come across a problem when you try to get formatting like this one below in a matrix report, RS 2005. Basically, I would like to have a border for every question and its related columns. Any help is greatly appreciated.

Thanks!

1. Question 1.SubQuestion Data 2.SubQuestion Data 3.SubQuestion Data 4.SubQuestion Data 5.SubQuestion Data 2. Question 1.SubQuestion Data 2.SubQuestion Data 3.SubQuestion Data 4.SubQuestion Data 3. Question 1.SubQuestion Data 2.SubQuestion Data 3.SubQuestion Data

Hello,

I played a little bit more today with the challenge above and was able to come up with some conditional formatting for a SubQuestion column which may be helpful in creating a border line for. So in RS 2005, I select a SubQuestion cell and go to View/Properties/BorderStyle/Top and paste the following expression statement: =IIF(LEFT(Fields!SubQuestText.Value,1) = "1", "Solid", "None") which copies automatically to BorderStyle property that looks like this:None, , , =IIF(LEFT(Fields!SubQuestText.Value,1) = "1", "Solid", "None") BorderColor property is set to Black. By using the following statements above, I would like to create a border line above every Subquestion cell value that starts with 1. Right now, this code generates a top border for the last question. Maybe someone has some ideas how I could generate a top border above Subquestion cells including values starting with "1"?

Thanks for your help!

|||

Hi!

I have a similar problem, did you get any solution?

Thank you!