Difference between multiple primary and secondary files..

Hi all..!

If I want to split an SQL DB into several physical files (as its 500GB
disk ran out of space, won't even run shrinks any more, and we bought
another 500GB disk to add to the PC)
then what is the difference between:
Adding another File to the primary group which will reside on the new
group;
Adding another file in another group.
We do not want to set any db objects (Tables, indexes)
to a secondary file, as this will involve lengthy data moving
operations. We would like the DB to continue working from where it is
utilizing the added space in a contigous (striped) manner.

Will striping occur in both cases? as I understand striping it means
that our stuck SQL Server will awake back to life as it will now have
500GB more data for its DB, even though we haven't set any of its
objects (tables, indexes) to explicitly use the secondary NDF file on
the new disk?
or will it only utilize the new space if we set some objects to reside
on that NDF?

for example if we run large queries which crash now (due to lack of
space) when we add the second drive will they start to work as the
process will grow striped from the full drive to the new drive, even if
all the queries' source tables are all still set to the old drive?

Thanks for any replies?(developmental2@.walla.com) writes:
> If I want to split an SQL DB into several physical files (as its 500GB
> disk ran out of space, won't even run shrinks any more, and we bought
> another 500GB disk to add to the PC)
> then what is the difference between:
> Adding another File to the primary group which will reside on the new
> group;
> Adding another file in another group.

If you add another filegroup, you need to move objects, as objects
below to a filegroup. Since you don't want to that, you should add
a secondary file to the primary filegroup.

I don't have much experience of secondary files myself, but I would
expect SQL Server start to spill over the new file, as soon as it is
available.

If you want to have certainty, it could be a good idea to set up a
small-size test, before you go ahead with the big database.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Diagramming Multiple Databases

I have a database that contains a product listing. I also have several other
databases that looks at this product listing database. When diagramming one
of these databases that uses the product listing database is there a way to
add this product listing database to my diagram? I only see where you can add
tables from the one database that you are trying to diagram.
Thanks
I guess you are talking to EM diagrams. They are limited to a single
database only. Maybe you could use some other tool, like Visio?
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"GORAMS" <GORAMS@.discussions.microsoft.com> wrote in message
news:AFE58B3D-90CE-4775-BB5B-099F8B6E4414@.microsoft.com...
>I have a database that contains a product listing. I also have several
>other
> databases that looks at this product listing database. When diagramming
> one
> of these databases that uses the product listing database is there a way
> to
> add this product listing database to my diagram? I only see where you can
> add
> tables from the one database that you are trying to diagram.
> Thanks

Diagram multiple database

Hi,
I have an application that use 2 databases. I would like to be able to
produce a diagram with tables from both databases. Is this possible ?
USE VISIO
"TheOne" <TheOne@.discussions.microsoft.com> wrote in message
news:7081D496-9125-42E9-A670-AFA499487514@.microsoft.com...
> Hi,
> I have an application that use 2 databases. I would like to be able to
> produce a diagram with tables from both databases. Is this possible ?
|||Hi Randy,
Thanks for your quick answer but I realized that I needed to
clarify my question. My goal is to apply referential integrity between two
tables that are not part of the same database.
"Randy Pitkin" wrote:

> USE VISIO
> "TheOne" <TheOne@.discussions.microsoft.com> wrote in message
> news:7081D496-9125-42E9-A670-AFA499487514@.microsoft.com...
>
>

Diagram multiple database

Hi,
I have an application that use 2 databases. I would like to be able to
produce a diagram with tables from both databases. Is this possible ?USE VISIO
"TheOne" <TheOne@.discussions.microsoft.com> wrote in message
news:7081D496-9125-42E9-A670-AFA499487514@.microsoft.com...
> Hi,
> I have an application that use 2 databases. I would like to be able to
> produce a diagram with tables from both databases. Is this possible ?|||Hi Randy,
Thanks for your quick answer but I realized that I needed to
clarify my question. My goal is to apply referential integrity between two
tables that are not part of the same database.
"Randy Pitkin" wrote:
> USE VISIO
> "TheOne" <TheOne@.discussions.microsoft.com> wrote in message
> news:7081D496-9125-42E9-A670-AFA499487514@.microsoft.com...
> > Hi,
> > I have an application that use 2 databases. I would like to be able to
> > produce a diagram with tables from both databases. Is this possible ?
>
>

Development/Production Environment with Visual Source Safe

Am new to RS. Installed it on test server and was quickly able to
generate a report with multiple datasources and even write some code to
render it directly to a PDF file. Quite a useful and efficient tool.
Now, we want to bring RS into our development environment. We have
multiple developers working on an internal web app in VS.NET that we
want to incorporate reports into. Developers use Visual Source Safe to
bring project files from the development server to their own machines
to do development and then check changes back into the development
server. Periodically, our app is release from development to
production. Pretty straightforward.
What I'm curious about is:
(1) Does SourceSafe version control the report definitions? They look
like files in VS .NET but they reside in the RS database, so I'm
uncertain.
(2) Can developers install RS on their machines for developing reports
under VS.NET while using the RS server/database on the development
server for previewing?
Thanks.
JeffAnswers to your questions:
1. You can (and should) check reports, report projects, report
solutions--however you want to organize it--into VSS. But it is a separate
process that you have to enforce with policy and procedure as VSS will not
reach into the report catalog (database) and handle versioning there.
2. Yes. If your developers have VS.NET 2003, then just install any version
of Reporting Services on their workstations, just unselect and server
components if they are offered in the setup.
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"JeffW" <jwilson@.telnetww.com> wrote in message
news:1110499289.694022.73370@.g14g2000cwa.googlegroups.com...
> Am new to RS. Installed it on test server and was quickly able to
> generate a report with multiple datasources and even write some code to
> render it directly to a PDF file. Quite a useful and efficient tool.
> Now, we want to bring RS into our development environment. We have
> multiple developers working on an internal web app in VS.NET that we
> want to incorporate reports into. Developers use Visual Source Safe to
> bring project files from the development server to their own machines
> to do development and then check changes back into the development
> server. Periodically, our app is release from development to
> production. Pretty straightforward.
> What I'm curious about is:
> (1) Does SourceSafe version control the report definitions? They look
> like files in VS .NET but they reside in the RS database, so I'm
> uncertain.
> (2) Can developers install RS on their machines for developing reports
> under VS.NET while using the RS server/database on the development
> server for previewing?
> Thanks.
> Jeff
>

Determining which email failed.

I have a data driven subscription which delivers multiple reports to
multiple subscribers.
For the most part, it works great.
But, sometimes there is a failure in the delivery.
Ie 10 reports were to be delivered to XXX@.xx.com.
It says that 8 were successful, and 2 failed.
Unfortunately, I cannot seem to determine which of the 10 failed.
This causes me no end of grief, as I cannot know which to resend.
I've tried looking at the log files to no avail.
Is there any way to determine which ones failed?As far as I understand the most straightforward method would be examination
the mail server logs.
Still quite a challenge.
"Zresse" <zresse@.yahoo.com> wrote in message
news:1128518677.725131.233550@.f14g2000cwb.googlegroups.com...
>I have a data driven subscription which delivers multiple reports to
> multiple subscribers.
> For the most part, it works great.
> But, sometimes there is a failure in the delivery.
> Ie 10 reports were to be delivered to XXX@.xx.com.
> It says that 8 were successful, and 2 failed.
> Unfortunately, I cannot seem to determine which of the 10 failed.
> This causes me no end of grief, as I cannot know which to resend.
> I've tried looking at the log files to no avail.
> Is there any way to determine which ones failed?
>|||Hey, Guess who?