January 2008 - Posts
As anyone working with partitioned tables knows by now, the process of creating stand-alone ‘staging’ tables to support switching data into or out of a partition can be a management challenge, especially if the design of the partition table or its indices
Read More...
At first I was going to write a detailed white paper about the conversion effort. But someone has already done it. There is a very good guide at: http://nationalcom.com/home/download/Conversion-VFP-SQLServer.pdf Since FoxPro is nearing its end of life,
Read More...
The database system in a company that is growing internationally must support multilingual characters in tables with Unicode data types. Existing d atabases that support only non-Unicode information must be migrate d from non-Unicode data type to Unicode
Read More...
It's a new year and, with it, we come bearing gifts! We have a pretty significant update to SQL Server 2005 Best Practices Analyzer. It contains many new and updated rules for Analysis Services, a few important rules for the Relational Engine, a couple bug fixes for the UI and command line tools. And all of these rules have rich documentation telling you what need to know.
...
Read More...
Many Analysis Services applications query members to populate a dropdown or find those that match some criteria – starting or ending with a string, existing with other members, having a member property with a certain value, whatever. For example, say
Read More...
Issue We have seeing some strange behavior when rebuilding indexes. · Total Fragmentation prior to rebuild is 99%. · You rebuild the index. (using both the alter index and the dbcc dbreindex) · Fragmentation is at 0% · You recheck fragmentation about
Read More...
Log shipping and database mirroring can work together to provide solutions for high availability and disaster recovery. You can convert an existing log shipping configuration to a database mirroring configuration. Although Microsoft only supports a single
Read More...
