Bad Practice: Calling Views From w/in Stored Procs

In general, is it bad practice to call a view from w/in a stored proc?
Some sites imply that SQL server creates two connections thereby
straining system resources that much more, some sites claim it doesn't.There is no penalty to using a view, whether inside a stored procedure
or not. There is no second connection from using a view.
If you have a source that actually says that, I would be concerned
about counting on that source for information.
Roy Harvey
Beacon Falls, CT
On 2 May 2006 10:45:32 -0700, "roy.@.nderson@.gm@.il.com"
<roy.anderson@.gmail.com> wrote:

>In general, is it bad practice to call a view from w/in a stored proc?
>Some sites imply that SQL server creates two connections thereby
>straining system resources that much more, some sites claim it doesn't.|||> Some sites imply that SQL server creates two connections thereby
> straining system resources that much more
Can you reference such a site / source?
A

Bad practice for data sources?

I'm just wondering if it is bad programming practice to have many data sources on one page. I need a "Matrix" type of page that grabs data from many tables and so far I have 5 data sources. Is this common or is there something I should be doing to make it more efficient?That's not unbelievable, I think the most I have in my pages currently is 4 or 5. Mostly for filling dropdowns, and then a grid control, and then maybe a couple more to fill dropdowns in the gridcontrol when it's in edit mode.

Backups: Syncing File and Database backups

Hi,
What's the best practice when trying to synchronize the backup of a set of
databases and a set of files on the file system?
I currently create backup schedules using the Maintenance Plan wizard. Is
there a way to trigger an event when the scheduled backup completes? Or is
there a better way to do this?
Thanks!
RossHi
You can add additional steps to the maintainance plan's backup job, or
alternatively you may want to start the job from batch script run by the
windows scheduler and run xp_sqlmaint (the command executed by the job step
of the maintainance job) though isql.
John
"Ross" wrote:

> Hi,
> What's the best practice when trying to synchronize the backup of a set of
> databases and a set of files on the file system?
> I currently create backup schedules using the Maintenance Plan wizard. Is
> there a way to trigger an event when the scheduled backup completes? Or i
s
> there a better way to do this?
> Thanks!
> Ross

Backups: Syncing File and Database backups

Hi,
What's the best practice when trying to synchronize the backup of a set of
databases and a set of files on the file system?
I currently create backup schedules using the Maintenance Plan wizard. Is
there a way to trigger an event when the scheduled backup completes? Or is
there a better way to do this?
Thanks!
RossHi
You can add additional steps to the maintainance plan's backup job, or
alternatively you may want to start the job from batch script run by the
windows scheduler and run xp_sqlmaint (the command executed by the job step
of the maintainance job) though isql.
John
"Ross" wrote:
> Hi,
> What's the best practice when trying to synchronize the backup of a set of
> databases and a set of files on the file system?
> I currently create backup schedules using the Maintenance Plan wizard. Is
> there a way to trigger an event when the scheduled backup completes? Or is
> there a better way to do this?
> Thanks!
> Ross

Backups: Syncing File and Database backups

Hi,
What's the best practice when trying to synchronize the backup of a set of
databases and a set of files on the file system?
I currently create backup schedules using the Maintenance Plan wizard. Is
there a way to trigger an event when the scheduled backup completes? Or is
there a better way to do this?
Thanks!
Ross
Hi
You can add additional steps to the maintainance plan's backup job, or
alternatively you may want to start the job from batch script run by the
windows scheduler and run xp_sqlmaint (the command executed by the job step
of the maintainance job) though isql.
John
"Ross" wrote:

> Hi,
> What's the best practice when trying to synchronize the backup of a set of
> databases and a set of files on the file system?
> I currently create backup schedules using the Maintenance Plan wizard. Is
> there a way to trigger an event when the scheduled backup completes? Or is
> there a better way to do this?
> Thanks!
> Ross