Review our tips and tricks from enterprise customer lessons learned; mirrored from our SQLCAT Blog at http://blogs.msdn.com/sqlcat
-
434 Views
Comments
- Author: SQL Server Customer Advisory Team
- 12-07-2008
For the ultimate guide to upgrading to SQL Server 2008, please refer to the SQL Server 2008 Upgrade Technical Reference Guide . A successful upgrade to SQL Server 2008 should be smooth and trouble-free. To achieve that smooth transition, you must devote...
-
488 Views
Comments
- Author: SQL Server Customer Advisory Team
- 11-14-2008
Thomas Kejser and I made some significant updates to the SQL Server Analysis Services Performance Guide for SQL Server 2008 - it's available here . Our hope is to keep it alive and make updates as necessary. So if there is something you'd like...
-
1,050 Views
Comments
- Author: SQL Server Customer Advisory Team
- 11-05-2008
This blog is a result of lessons learned while working with the new Integrated Full Text Search in SQL Server 2008. It is not intended to be an in-depth tutorial on how to implement it. Instead, it will concentrate on best practices. The basics of how...
-
448 Views
Comments
- Author: SQL Server Customer Advisory Team
- 10-29-2008
Recently, Wanda He from SQLCAT ISV team worked with Oracle Siebel group completed a new 12,000 concurrent users Siebel CRM 8.0 benchmark on SQL Server 2008 ( http://www.microsoft.com/isv/oracle/ ). The benchmark demonstrated that the combination of Microsoft...
-
562 Views
Comments
- Author: SQL Server Customer Advisory Team
- 10-22-2008
Check out the the third of five technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series: Reporting Services Scale-Out Deployment Best Practices This technical note reviews the SSRS...
-
504 Views
Comments
- Author: SQL Server Customer Advisory Team
- 10-16-2008
Check out the new look and feel of the sqlcat.com ! Now you have easy access and views of our Top 10 Lists, Technical Notes, Whitepapers, and Toolbox. As well, now our blogs our mirrored to sqlcat.com for easy access to all SQLCAT tips, best practices...
-
1,932 Views
Comments
- Author: SQL Server Customer Advisory Team
- 10-09-2008
The other day we got a call from a puzzled friend. He has rewritten a stored procedure using table variable instead of temp table, it makes the stored procedure code look more tidy. The puzzling part is the same stored procedure now running a lot slower...
-
396 Views
Comments
- Author: SQL Server Customer Advisory Team
- 10-09-2008
After the great work from the ETL World Record (for more information, refer to our other blog at: http://blogs.msdn.com/sqlcat/archive/2008/09/18/scaling-heavy-network-traffic-with-windows.aspx ), Thomas and I (with the help of many others) have created...
-
371 Views
Comments
- Author: SQL Server Customer Advisory Team
- 10-06-2008
Saw an amazing BI demo this morning at the BI Conference here in Seattle. Donald Farmer showed how over 20M rows of data can be modeled and analyzed in memory. To build a model today, a DBA needs to define dimensions and fact tables, get the relationships...
-
283 Views
Comments
- Author: SQL Server Customer Advisory Team
- 09-25-2008
Coming up this November 18-21 st is the SQL PASS Conference in Seattle, WA (right in Microsoft’s backyard). See http://summit2008.sqlpass.org/ for all the details. This SQL PASS will be very special. The SQL Server engineering team is sending up to 300...
1 2 3 Next >
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
|
