BoltonMinx's favorite databases pages, page 1

Last login: 3 weeks agoBoltonMinx: Dee is a 32 year old woman from Bolton, England, UK.; Likes 427 pages, 10 videos, 9 photos • 54 fans • Received 11 reviews; Member since Apr 12, 2007

Favorites » Her databases pages

Indexing in SQL Server 2005 - SQL Server Central: Aug 18, 9:20am 1 review databases, indexing, sql-2005
http://www.sqlservercentral.com/articles/Performance+Tuning/2770/; A guide to indexing on SQL 2005, covering the new toys provided by MS. I'm especially interested in the "Identifying Potential Indexes" tool.

The Ultimate Missing Index Finder - SQL Server Central: Aug 18, 9:17am 1 review databases, indexing, sql-2005, optimizer
http://www.sqlservercentral.com/scripts/Index+Management/63937/; I'm intruiged by this script. I'll be trying it out and comparing the result of it's suggestion on a dev platform soonish.

http://www.ralphkimball.com/html/designtipsPDF/KimballDT51LatestThinking.pdf: Aug 7, 5:44am 1 review databases, time-dimension
http://www.ralphkimball.com/html/designtipsPDF/KimballDT51LatestThinking.pdf; Ralpha Kimball revisits Time Dimensions. Quite wordy but makes sense once you've pondered it. If you have or are about to implement a time dimension, it's worth taking his comments into consideration.

Moving distribution database - how? - microsoft.public.sqlserver.server | Gru…: Aug 7, 1:59am 1 review databases, sql, replication
http://groups.google.pl/group/microsoft.public.sqlserver.server/browse_thread...; How to move your distribution database without making a complete hash of things. Note: this is unsupported, so make a backup before you proceed! You have been warned..

Getting Time Right in Analysis Services & SQL DB Collection: Aug 6, 12:31am 1 review databases, ssas, time-dimension
http://sqldb.wordpress.com/2006/05/31/getting-time-right-in-analysis-services/; This blog explains just why you need a time dimension in your cube. Useful for anyone new to SSAS, but he does recommend a number of non-standard solutions which should be carefully weighed up before implementing.

Running analytical queries with Analysis Services: Aug 5, 12:10am 1 review databases, ssas, storage-settings
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1148970,00.html; I really enjoyed this article about Storage Settings in SSAS. If you are starting to consider how to best process cubes, this article introduces you to the concepts. This high level approach will give you enough information to make an informed decision.

Overview of Comparing Database Schemas: Jul 31, 1:12am 1 review databases, database, visual-studio-2008, schema-comparison
http://msdn.microsoft.com/en-us/library/aa833296.aspx; As I'm new to Visual Studio 2008, I was pleased to discover this built-in tool. It allows you to compare either two databases or a database project and a database. There are several options included which are set via Tools -> Options -> Database Tools -> Schema Compare. Once you've compared the schemas, you can selectively deploy changes to the target database. Careful though, some changes may involve data loss due to dropping objects. To avoid this, don't forget to select the "Block schema updates if data loss might occur" option.