tag:blogger.com,1999:blog-40004050596815052122024-03-13T20:25:25.073+05:30Business Intelligence & SQL Server ArticlesArticles on SQL Server and Business Intelligence from around the web, mainly for my reference.Guru Smaranhttp://www.blogger.com/profile/13518013078596888090noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-4000405059681505212.post-58230280392398975502009-11-04T11:19:00.000+05:302009-11-04T11:19:09.815+05:30How to connect to a a SQL 2005 Server when you're completely locked outHow to connect to a a SQL 2005 Server when you're completely locked out<br />
<br />
http://www.sqlservercentral.com/articles/Administration/68271/Guru Smaranhttp://www.blogger.com/profile/13518013078596888090noreply@blogger.com0tag:blogger.com,1999:blog-4000405059681505212.post-12929416270997661532009-07-15T15:46:00.003+05:302009-07-15T15:54:21.397+05:30Partitioned Table and Index Strategies Using SQL Server 2008Partitioned Table and Index Strategies Using SQL Server 2008<br />(taken from <a href="http://technet.microsoft.com/en-us/library/dd578580.aspx">http://technet.microsoft.com/en-us/library/dd578580.aspx</a>)<br /><br /><p class="MsoNormal">When a database table grows in size to the hundreds of gigabytes or more, it can become more difficult to load new data, remove old data, and maintain indexes. Just the sheer size of the table causes such operations to take much longer. Even the data that must be loaded or removed can be very sizable, making INSERT and DELETE operations on the table impractical. The Microsoft SQL Server 2008 database software provides table partitioning to make such operations more manageable.</p><p class="MsoNormal">Partitioning a large table divides the table and its indexes into smaller partitions, so that maintenance operations can be applied on a partition-by-partition basis, rather than on the entire table. In addition, the SQL Server optimizer can direct properly filtered queries to appropriate partitions rather than the entire table.</p>This paper covers strategies and best practices for using partitioned tables and indexes in SQL Server 2008. It is intended for database architects, developers, and administrators of both data warehouse and OLTP systems, and the material is presented at an intermediate to advanced level.<br /><br />This paper can be downloaded <a href="http://gurusmaran.googlepages.com/PartTableAndIndexStrat.docx">here</a>.Guru Smaranhttp://www.blogger.com/profile/13518013078596888090noreply@blogger.com0tag:blogger.com,1999:blog-4000405059681505212.post-86314564555799266002009-07-15T15:45:00.001+05:302009-07-15T15:46:05.313+05:30User-defined Hierarchies in SSASDesigning User-defined Hierarchies in SSAS:<br /><br /><a href="http://www.mssqltips.com/tip.asp?tip=1773">http://www.mssqltips.com/tip.asp?tip=1773</a>Guru Smaranhttp://www.blogger.com/profile/13518013078596888090noreply@blogger.com0tag:blogger.com,1999:blog-4000405059681505212.post-5881682685741360052009-07-15T15:42:00.003+05:302009-07-15T15:44:30.109+05:30SQL Server 2008 Database MirroringDatabase Mirroring on SQL Server 2008 - Whatis, Howto.<br /><br /><a href="http://www.databasejournal.com/features/mssql/article.php/3828341/Database-Mirroring-in-SQL-Server-2008.htm">http://www.databasejournal.com/features/mssql/article.php/3828341/Database-Mirroring-in-SQL-Server-2008.htm</a>Guru Smaranhttp://www.blogger.com/profile/13518013078596888090noreply@blogger.com0tag:blogger.com,1999:blog-4000405059681505212.post-55307495289161049612009-07-15T15:23:00.003+05:302009-07-15T15:27:33.661+05:30MDX 'Select' Error ReferenceCommon error messages when 'Selecting' in MDX:<br /><br /><a href="http://cwebbbi.spaces.live.com/Blog/cns%217B84B0F2C239489A%214574.entry">http://cwebbbi.spaces.live.com/Blog/cns!7B84B0F2C239489A!4574.entry</a>Guru Smaranhttp://www.blogger.com/profile/13518013078596888090noreply@blogger.com0tag:blogger.com,1999:blog-4000405059681505212.post-1116002142779369532009-07-15T14:59:00.002+05:302009-07-15T15:01:00.099+05:30Mirrored Database Backup in SQL Server 2008Backing up Mirrored Databases in SQL Server 2008:<br /><br /><a href="http://www.mssqltips.com/tip.asp?tip=1779">http://www.mssqltips.com/tip.asp?tip=1779</a>Guru Smaranhttp://www.blogger.com/profile/13518013078596888090noreply@blogger.com0tag:blogger.com,1999:blog-4000405059681505212.post-46032627942950604712009-07-15T14:53:00.003+05:302009-07-15T15:01:26.196+05:30Mapping IP Addresses to Geographical Locations<span style="font-family:arial;">Mapping IP Addresses to Geographical Locations using GeoLiteCity. Does not use the Spatial datatype.<br /><br /></span><a href="http://www.sqlservercentral.com/articles/SQL+Server/67215/">http://www.sqlservercentral.com/articles/SQL+Server/67215/</a>Guru Smaranhttp://www.blogger.com/profile/13518013078596888090noreply@blogger.com0tag:blogger.com,1999:blog-4000405059681505212.post-33032707999279343632009-07-15T14:03:00.004+05:302009-07-15T14:58:25.709+05:30The 34 Subsystems of ETL Data Integration<span style="font-family:arial;">The 34 Subsystems of ETL Data Integration explained from a SSIS perspective:</span><br /><br /><a style="font-family: arial;" href="http://blog.todmeansfox.com/2007/11/26/34-subsystems-of-etl-data-integration/">http://blog.todmeansfox.com/2007/11/26/34-subsystems-of-etl-data-integration/</a>Guru Smaranhttp://www.blogger.com/profile/13518013078596888090noreply@blogger.com0tag:blogger.com,1999:blog-4000405059681505212.post-70875134213973041792009-07-15T14:00:00.002+05:302009-07-15T14:58:44.476+05:30SSIS Expressions Reference<span style="font-family:arial;">Expressions in SQL Server Integration Services:</span><br /><br /><a style="font-family: arial;" href="http://msdn.microsoft.com/en-us/library/ms141232.aspx">http://msdn.microsoft.com/en-us/library/ms141232.aspx</a>Guru Smaranhttp://www.blogger.com/profile/13518013078596888090noreply@blogger.com0