Best techniques for databse creation ?

Dear Experts,
Any one knows any link regarding best practices for schema and database crea
tion in SQL server 2000 in detail .
Faheem Latif
NETWORK SOLUTIONFaheem,
What specifically are you looking for? There are many things on the web if
you search google. However I recommend these links as a start:
SQL Server 2000 Operations Guide
http://www.microsoft.com/technet/pr...in/sqlops0.mspx
Vyas's article on Best Practices
http://www.sql-server-performance.c...t_practices.asp
Microsoft SQL Server 2000 Best Practices Analyzer 1.0 Beta
E07339C1F22&displaylang=en" target="_blank">http://www.microsoft.com/downloads/...&displaylang=en
Tinyurl: http://tinyurl.com/upzi
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Faheem" <anonymous@.discussions.microsoft.com> wrote in message
news:189C9EC5-9492-4B34-A0D7-C9908D15BA0E@.microsoft.com...
> Dear Experts,
> Any one knows any link regarding best practices for schema and database
creation in SQL server 2000 in detail .
> Faheem Latif
> NETWORK SOLUTION
>

Best techniques for databse creation ?

Dear Experts
Any one knows any link regarding best practices for schema and database creation in SQL server 2000 in detail
Faheem Latif
NETWORK SOLUTIONFaheem,
What specifically are you looking for? There are many things on the web if
you search google. However I recommend these links as a start:
SQL Server 2000 Operations Guide
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx
Vyas's article on Best Practices
http://www.sql-server-performance.com/vk_sql_best_practices.asp
Microsoft SQL Server 2000 Best Practices Analyzer 1.0 Beta
http://www.microsoft.com/downloads/details.aspx?FamilyId=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
Tinyurl: http://tinyurl.com/upzi
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Faheem" <anonymous@.discussions.microsoft.com> wrote in message
news:189C9EC5-9492-4B34-A0D7-C9908D15BA0E@.microsoft.com...
> Dear Experts,
> Any one knows any link regarding best practices for schema and database
creation in SQL server 2000 in detail .
> Faheem Latif
> NETWORK SOLUTION
>

Best techniques for databse creation ?

Dear Experts,
Any one knows any link regarding best practices for schema and database creation in SQL server 2000 in detail .
Faheem Latif
NETWORK SOLUTION
Faheem,
What specifically are you looking for? There are many things on the web if
you search google. However I recommend these links as a start:
SQL Server 2000 Operations Guide
http://www.microsoft.com/technet/pro...n/sqlops0.mspx
Vyas's article on Best Practices
http://www.sql-server-performance.co..._practices.asp
Microsoft SQL Server 2000 Best Practices Analyzer 1.0 Beta
http://www.microsoft.com/downloads/d...displaylang=en
Tinyurl: http://tinyurl.com/upzi
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Faheem" <anonymous@.discussions.microsoft.com> wrote in message
news:189C9EC5-9492-4B34-A0D7-C9908D15BA0E@.microsoft.com...
> Dear Experts,
> Any one knows any link regarding best practices for schema and database
creation in SQL server 2000 in detail .
> Faheem Latif
> NETWORK SOLUTION
>

Best practices for partitions for cubes?

Hi, all here,

Thank you very much for your kind attention.

Would please any experts here give me any guidances and advices for what are best practices for partitions for cubes in SQL Server 2005 analysis services? I mean like when should we use partitions for cubes? And what are the best practices for the partitions memory modes?

Thanks a lot in advance for any helpful guidances and advices for that.

With best regards,

Yours sincerely,

Hi,

This link will give you a good introduction to partitioning

http://www.microsoft.com/technet/prodtechnol/sql/2005/projreal.mspx

|||

Hi, Larrybird02744,

Thank you very much for your kind guidance.

With best regards,

Yours sincerely,

Best practices for partitions for cubes?

Hi, all here,

Thank you very much for your kind attention.

Would please any experts here give me any guidances and advices for what are best practices for partitions for cubes in SQL Server 2005 analysis services? I mean like when should we use partitions for cubes? And what are the best practices for the partitions memory modes?

Thanks a lot in advance for any helpful guidances and advices for that.

With best regards,

Yours sincerely,

Hi,

This link will give you a good introduction to partitioning

http://www.microsoft.com/technet/prodtechnol/sql/2005/projreal.mspx

|||

Hi, Larrybird02744,

Thank you very much for your kind guidance.

With best regards,

Yours sincerely,

Best practice for indexed views and aggregates tables

Hi, all experts here,

Thank you very much for your kind attention.

I am having some questions on indexed views and aggregate tables.

My question is: To improve the performance of the queries, is it better to use indexted views or aggregates tables for those aggregates which are often queried?

I am looking forward to hearing from you.

Thank you very much in advance for your help.

With best regards,

Yours sincerely,

Well...it depends. Indexed views are great because they keep the data from a view materialized...but the database engine must maintain the indexes, which may slow OLTP operations. An aggregate table may be a good idea, but also might be complicated to design and make sure it is updated properly, not to mention that you have to make sure it is updated.
Tim|||

Hi, Tim,

Thank you very much for your kind advices.

In my case, the aggregates residing in a historical data warehouse, where the update of data is not so much likely and it will not have much to do with any operational database. As what you advised, indexed views would be a better idea in this case?

Looking forward to hearing from you.

With best regards,

Yours sincerely,

|||If the data isn't getting updated often, then I personally would design an aggregates table. That will give you a lot of flexibility for your project...flexibility that may be prohibited by the restrictions on designing indexed views (there are a lot of things you need to adhere to so that your view can be indexed). Hope this helps.|||

Hi, Tim,

Thanks a lot for your advices. They've been very helpful.

With best regards,

Yours sincerely,

Best 3rd party Charting Control for RS2005

Hi Experts!
I have tried out Dundas Charting (v2) Evaluation for RS2005 and it turned
out quite nice. At least I know it allowed me do combination charts (e.g.
points, line, coumn, etc) which the default RS cannot do.
Based on your experience and opinions from others that you heard, which is
the best 3rd party Charting control out there for RS2005?
Any info would be greatly appreciated.On Mar 8, 3:19 pm, Thanh Nguyen
<ThanhNgu...@.discussions.microsoft.com> wrote:
> Hi Experts!
> I have tried out Dundas Charting (v2) Evaluation for RS2005 and it turned
> out quite nice. At least I know it allowed me do combination charts (e.g.
> points, line, coumn, etc) which the default RS cannot do.
> Based on your experience and opinions from others that you heard, which is
> the best 3rd party Charting control out there for RS2005?
> Any info would be greatly appreciated.
I am using Dundas for some of my clients. I felt its the best.|||We use ChartFX. As for whether it is the "best" - don't know. I haven't
used Dundas. We use ChartFX to render charts (on reports and web forms)
from data from SQL Analysis Services.
"Thanh Nguyen" <ThanhNguyen@.discussions.microsoft.com> wrote in message
news:C953A74F-CDC9-4ACF-89CC-272E80E0F4E8@.microsoft.com...
> Hi Experts!
> I have tried out Dundas Charting (v2) Evaluation for RS2005 and it turned
> out quite nice. At least I know it allowed me do combination charts (e.g.
> points, line, coumn, etc) which the default RS cannot do.
> Based on your experience and opinions from others that you heard, which is
> the best 3rd party Charting control out there for RS2005?
> Any info would be greatly appreciated.