max memory for SSIS?

If we have a SQL Server 2005 standard edition/Windows 2003 Standard
Environment on a 32 bit 2 dual core proc Dell 2850 server, what is the
maximum size of the memory we could possibly have?
Thank you,
ShivaAnswered in microsoft.public.sqlserver.integrationsvcs
*mike hodgson*
http://sqlnerd.blogspot.com
Shiva wrote:

>If we have a SQL Server 2005 standard edition/Windows 2003 Standard
>Environment on a 32 bit 2 dual core proc Dell 2850 server, what is the
>maximum size of the memory we could possibly have?
>Thank you,
>Shiva
>
>
>

Max Length of "Text" and "Varchar"

I'm trying to save a memo to a database..
Right now it's declared as "text"
what's the max size of that?2,147,483,647 bytes

Max Filegroup Size set to 20 how do I change it?

Hello,

I have been trying to figure out how to temporarily change the max
filegroup size of a SQL 2000 database I "inherited" when our DBA quit.

I just need some breathing room until I can figure out how to properly
archive and remove some filegroups.

Here is the scenario, my filegroup is set to 20. Each filegroup is set
to grow to 4096.
I currently have all 20 filegroups in use and filegroup number 20 is
more than 1/2 full.

I have considered making the max size for each filegroup larger but
believe this is treating the symptom not fixing the problem.

I would RTFM if I knew how to ask the question in 5 words or less.
I have plenty of room to grow in terms of disk space.
In Query Analyzer I suspect I have to use an ALTER DATABASE
In Gui mode I suspect I have to right click on the database properties,
filegoups,,,,

In the past I have setup my databases with 1 filegroup and auto
configured to grow as needed so this is new territory for me so please
feel free to dumb it down for a noob as I need baby steps.Filegroups contain files. Files have settable parameters like max size not
filegroups. Unless something is configured strangely 20 files in a
filegroup usually indicates an attempt to spread out IO operations across
lots of disks (probably SAN based). MS also recommends having at least one
file per processor on multiprocessor servers for performance reasons. Yes.
You are correct you have two choices.

Use the Alter database command or EM and access the properties of the
database.

Ps. Try to keep the file sizes within a Filegroup the same size so that the
proportional fill algorithm can distribute the extents evenly.

<mchang@.allosource.org> wrote in message
news:1118379203.356973.4140@.o13g2000cwo.googlegrou ps.com...
> Hello,
> I have been trying to figure out how to temporarily change the max
> filegroup size of a SQL 2000 database I "inherited" when our DBA quit.
> I just need some breathing room until I can figure out how to properly
> archive and remove some filegroups.
> Here is the scenario, my filegroup is set to 20. Each filegroup is set
> to grow to 4096.
> I currently have all 20 filegroups in use and filegroup number 20 is
> more than 1/2 full.
> I have considered making the max size for each filegroup larger but
> believe this is treating the symptom not fixing the problem.
> I would RTFM if I knew how to ask the question in 5 words or less.
> I have plenty of room to grow in terms of disk space.
> In Query Analyzer I suspect I have to use an ALTER DATABASE
> In Gui mode I suspect I have to right click on the database properties,
> filegoups,,,,
> In the past I have setup my databases with 1 filegroup and auto
> configured to grow as needed so this is new territory for me so please
> feel free to dumb it down for a noob as I need baby steps.|||Filegroups contain files. Files have settable parameters like max size not
filegroups. Unless something is configured strangely 20 files in a
filegroup usually indicates an attempt to spread out IO operations across
lots of disks (probably SAN based). MS also recommends having at least one
file per processor on multiprocessor servers for performance reasons. Yes.
You are correct you have two choices.

Use the Alter database command or EM and access the properties of the
database.

Ps. Try to keep the file sizes within a Filegroup the same size so that the
proportional fill algorithm can distribute the extents evenly.

<mchang@.allosource.org> wrote in message
news:1118379203.356973.4140@.o13g2000cwo.googlegrou ps.com...
> Hello,
> I have been trying to figure out how to temporarily change the max
> filegroup size of a SQL 2000 database I "inherited" when our DBA quit.
> I just need some breathing room until I can figure out how to properly
> archive and remove some filegroups.
> Here is the scenario, my filegroup is set to 20. Each filegroup is set
> to grow to 4096.
> I currently have all 20 filegroups in use and filegroup number 20 is
> more than 1/2 full.
> I have considered making the max size for each filegroup larger but
> believe this is treating the symptom not fixing the problem.
> I would RTFM if I knew how to ask the question in 5 words or less.
> I have plenty of room to grow in terms of disk space.
> In Query Analyzer I suspect I have to use an ALTER DATABASE
> In Gui mode I suspect I have to right click on the database properties,
> filegoups,,,,
> In the past I have setup my databases with 1 filegroup and auto
> configured to grow as needed so this is new territory for me so please
> feel free to dumb it down for a noob as I need baby steps.

Max database size on SQL-SERVER7

Hello

Does anyone one know the max size of a database that I can create on
MS-SQL server 7. Have had any problems using databases near the max
size (slow performance, etc)

Thanks
Helenahmatijaca@.yahoo.ca (Helena) wrote in message news:<c5a36d06.0310080727.2468ecd5@.posting.google.com>...
> Hello
> Does anyone one know the max size of a database that I can create on
> MS-SQL server 7. Have had any problems using databases near the max
> size (slow performance, etc)
>
> Thanks
> Helena

Hi Helena,

According to Books Online, it's 1,048,516 TB which is definitely a big DB.
Yes definitely for DBs os this size, the hardware needs would change.

Regards,
-Manoj|||"Helena" <hmatijaca@.yahoo.ca> wrote in message
news:c5a36d06.0310080727.2468ecd5@.posting.google.c om...
> Hello
> Does anyone one know the max size of a database that I can create on
> MS-SQL server 7. Have had any problems using databases near the max
> size (slow performance, etc)

Backups are generally one of the biggest problems I've seen with VLDBs.

You have to have a backup/restore strategy that works for your business
rules.

If it takes 24 hours to restore your database and business rules require you
to back it up in less than 6, you'll have to change your infrastructure.

Generally performance comes down a LOT to design. Proper hardware can make
a huge difference, but even with extremely fast hardware, if you have a
lousy design and end up doing a table scan of a multigig DB, your
performance will suck.

On the other hand, if you have mediocre hardware, but you can do index
lookups for every query (as opposed to a table scan) you'll do a lot better.

>
> Thanks
> Helenasql

Matrix width

How do you find out the width of a matrix control, I need this to
enable me to size the width of a Textbox, as the width needs to be the
same size as the Matrix control which keeps growing depending on the
dataThe width of your textbox is changing dynamically? Wow! How did you get it
to do that? The "increase to accomidate contents" checkbox only increases
the height on my version RS. I haven't found out to dynamically change the
width yet. And I believe several other people on this forum are searching
for this same functionality.
BTW, the only place I've seen the size properties (height & width) are in
the properties screen of the individual boxes or the rows or the
tables/matrices/lists. I asked a while back for how to call those properties
in an expression (I know it's similar to "Type!Name.Value" - still don't know
what type to use for properties), but no one answered the question.
Hopefully, someone will help us both out and answer the question here.
Catadmin
"Bryan Avery" wrote:
> How do you find out the width of a matrix control, I need this to
> enable me to size the width of a Textbox, as the width needs to be the
> same size as the Matrix control which keeps growing depending on the
> data
>sql

Matrix report export to Excel

I created a report based on matrix.
I set the can grow property of all fields to false.
In the report the fields are behaving as expected - the size is fixed.
When I'm exporting to excel the fields are growing according to the text size.
(I have other report based on table and the can grow property controls the
fields alos when exporting to excel).
How can I control the can grow?
Thak'sHello,
It seems that you're running into a limitation in Excel. When there are
merged cells in a row, Excel cannot apply it's equivalent of CanGrow on the
row. You're likely running into merged cells due to the layout of your
report. If items in the report don't line up with each other vertically,
SRS are forced to span items across multiple cells in order to preserve
your layout.
I have forwarded your feedback to the product team. In the meantime, I also
encourage you submit via the link below
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Please note that the newsgroups are staffed weekdays with a goal to provide
ONE BUSINESS DAY RESPONSE to all posts.
If this response time does not meet your needs, please contact CSS for more
immediate assistance:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;OfferProPhone#faq607

Matrix column size

Hi
Can I set dynamically the width of a matrix column at runtime?
I'm using VisualStudio 2008 and a rdlc local report.
Thank's in advanceHello Giorgio,
Based on my research, there is not method to modify the width of a matrix
column on the fly when rendering the report. Also, we could use expression
to change the column width.
If you'd like to control column width you can use a table control (or a
matrix control with static columns), which would give you individual
control over the column widths.
Please rest assured your feedback on this is routed to the right channel.
In the mean time, you could submit via the link below
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.