In this blog post we will see 15 best practices for better Database Performance.
SQLAuthority News – Learn New Things – Self Criticism
I came across two interesting web pages and I really thought they had very good articles. I would like to share that with my blog readers today. I am just listing the abstract here. Please read the original articles they are much more interesting and enjoyable. Readers if you find…
Read MoreSQL SERVER – 2005 – Analysis Services Query Performance Top 10 Best Practices
Analysis Services Query Performance Top 10 Best Practices Optimize cube and measure group design Define effective aggregations Use partitions Write efficient MDX Use the query engine cache efficiently Ensure flexible aggregations are available to answer queries. Tune memory usage Tune processor usage Scale up where possible Scale out when you…
Read MoreSQL SERVER – 2005 – Licensing Model Compared to Other Database Products
Yesterday on this blog I wrote about SQL SERVER – 2005 – Understanding Licensing Model. I have received many questions about pricing and comparing SQL Server with other RDBMS. One of the reason I like SQL Server because I am strong believer of licensed software usage and SQL Server is…
Read MoreSQL SERVER – Top 10 Best Practices for SQL Server Maintenance for SAP
Top 10 Best Practices for SQL Server Maintenance for SAP By Takayuki Hoshino SQL Server provides an excellent database platform for SAP applications. The following recommendations provide an outline of best practices for maintaining SQL Server database for an SAP implementation. 1) Perform a full database backup daily 2) Perform…
Read MoreSQL SERVER – 2005 Best Practices Analyzer (January 2008)
The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. With this tool, you can test and implement a combination of SQL Server best practices and then implement them on your SQL Server. The SQL Server 2005 Best Practices Analyzer gathers data…
Read MoreSQLAuthority New – Best Practices for Speeding Up Your Web Site
Steve Souders, Chief Performance Yahoo! Best Practices for Speeding Up Your Web Site. I suggest everybody should read this basic guidelines. They are extremely important for high performance websites. 1. Make Fewer HTTP Requests 2. Use a Content Delivery Network 3. Add an Expires Header 4. Gzip Components 5. Put…
Read More