tag:blogger.com,1999:blog-388709032024-02-22T23:09:51.487+05:30shashank mishraUnknownnoreply@blogger.comBlogger39125tag:blogger.com,1999:blog-38870903.post-16582183669889887642018-02-21T20:31:00.000+05:302018-02-21T20:31:10.548+05:300x80029C4A - 000208D5-0000-0000-C000-000000000046 0 TYPE_E_CANTLOADLIBRARY - How to fix<div dir="ltr" style="text-align: left;" trbidi="on">
Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).<br />
<br />
<br />
<br />
Repair Office from Control Panel and it should resolve the issue.<br />
<br />
Looks like it's often caused by an Office update.<br />
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-9037684967763087302014-12-04T19:26:00.000+05:302014-12-04T19:26:51.680+05:30TTransportException SocketTimeoutException - Hive - Azure HDInsight Emulator<div dir="ltr" style="text-align: left;" trbidi="on">
While working on Hive in Azure HDInsight Emulator I was not able to create database and following exception was being thrown with all the queries:<br />
<br />
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: org.apache.thrift.transport.<br />
<br />
To resolve the issue and assuming Hadoop installation folder is C:\hdp open hive-site.xml from:<br />C:\hdp\hive-....*\conf directory<br />
<br />
Locate<br />
<property><br /> <name>javax.jdo.option.ConnectionDriverName</name><br /> <value>org.apache.derby.jdbc.<b>CommonDriver</b></value><br /> <description>Driver class name for a JDBC metastore</description></property><br />
<br />
and change CommonDriver to EmbeddedDriver:<br /><property><br /> <name>javax.jdo.option.ConnectionDriverName</name><br /> <value>org.apache.derby.jdbc.<b>EmbeddedDriver</b></value><br /> <description>Driver class name for a JDBC metastore</description></property><br />
<br />
From Services restart Apache Hadoop Metastore service and retry running HQL queries. It should work not. In case issue cannot be resolved feel free to drop me an email or comment.</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-80374974516647509512014-07-03T16:44:00.000+05:302014-07-03T16:51:03.737+05:30ODP.NET Managed Data Access (Oracle.ManagedDataAccess.dll) with Enterprise Library<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-size: small;"><span style="font-family: Georgia,"Times New Roman",serif;">Oracle.ManagedDataAccess.dll is managed Oracle connector that doesn't require any Instant Client to be installed and offers advantage over unmanaged counterparts. It doesn't require any installation on the machine and Oracle.ManagedDataAccess.dll should be placed in execution directory or in probing directory specified in configuration.</span></span><br />
<br />
<span style="font-size: small;"><span style="font-family: Georgia,"Times New Roman",serif;">Below are the two errors which you may receive while trying to use Oracle Managed Data Access DLL:</span></span><br />
<span style="font-size: small;"><span style="font-family: Georgia,"Times New Roman",serif;"><br />1. Activation error occured while trying to get instance of type Database, key ""</span></span><br />
<span style="font-size: small;"><span style="font-family: Georgia,"Times New Roman",serif;">Resolution of the dependency failed, type = Microsoft.Practices.EnterpriseLibrary.Data.Database, name = ConnectionString.<br />Exception occurred while: while resolving.<br />Exception is: InvalidOperationException - The type Database cannot be constructed. You must configure the container to supply this value.-----------------------------------------------<br />At the time of the exception, the container was: Resolving Microsoft.Practices.EnterpriseLibrary.Data.Database,ConnectionString (this occurs when wrong provider factory is used or DbProviderFactories hasn't been added to the application configuration or machine.config)</span></span><br />
<br />
<span style="font-size: small;"><span style="font-family: Georgia,"Times New Roman",serif;">2. Configuration system failed to initialize (this occurs when configuration section doesn't have correct entry)</span></span><br />
<br />
<span style="font-size: small;"><span style="font-family: Georgia,"Times New Roman",serif;">Solution: </span></span><br />
<span style="font-size: small;"><span style="font-family: Georgia,"Times New Roman",serif;">To make Oracle.ManagedDataAccess.dll work with Enterprise Library few additional obvious configuration changes are required:</span></span><br />
<br />
<span style="font-size: small;"><span style="font-family: Georgia,"Times New Roman",serif;"> Add configSections section at the top of configuration:</span></span><br />
<configSections>
<section name="oracleConnectionSettings" type="Microsoft.Practices.EnterpriseLibrary.Data.Oracle.Configuration.OracleConnectionSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=5.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="true" />
<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=5.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="true"/>
<section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.121.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
</configSections>
<br />
<br />
<br />
<span style="font-size: small;"><span style="font-family: Georgia,"Times New Roman",serif;">Add Db Provider Factories:</span></span><br />
<br />
<span style="font-size: small;"><span style="font-family: Georgia,"Times New Roman",serif;">In case of ODP.NET to load appropriate factory while creating database machine.config is modified during installation and DbProviderFactories is added however with Oracle.ManagedDataAccess.dll there is no installation required so edit the application configuration file (app.config or web.config) and add following:</span></span><br />
<system.data>
<DbProviderFactories>
<remove invariant="Oracle.ManagedDataAccess" />
<add name="Oracle Managed Data Provider for .NET" invariant="Oracle.ManagedDataAccess" description="Oracle Managed Data Provider for .NET" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.121.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
</DbProviderFactories>
</system.data>
<span style="font-size: small;"><span style="font-family: Georgia,"Times New Roman",serif;"><br /></span></span>
<span style="font-size: small;"><span style="font-family: Georgia,"Times New Roman",serif;"><br /></span></span>
<span style="font-size: small;"><span style="font-family: Georgia,"Times New Roman",serif;"><br /></span></span>
<span style="font-size: small;"><span style="font-family: Georgia,"Times New Roman",serif;">Make sure to change the version and Public Key Token depending on the version being used.</span></span><br />
<span style="font-size: small;"><span style="font-family: Georgia,"Times New Roman",serif;"><br /></span></span>
<br />
<span style="font-size: small;"><span style="font-family: Georgia,"Times New Roman",serif;">Connection string for EZConnect looks like:</span></span><br />
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=//localhost:1521/Shash;User ID=scott;Password=tiger;" providerName="Oracle.ManagedDataAccess" />
</connectionStrings>
<br />
<br />
<span style="font-size: small;"><span style="font-family: Georgia,"Times New Roman",serif;">Above configuration changes allow use </span><span style="font-family: Georgia,"Times New Roman",serif;"><span style="font-family: Georgia,"Times New Roman",serif;">of Oracle.ManagedDataAccess.dll with Enterprise Library.</span></span><span style="font-family: Georgia,"Times New Roman",serif;"><br /></span></span></div>
Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-38870903.post-42594173160372503802013-09-30T15:52:00.002+05:302013-09-30T15:52:55.279+05:30Calling LoadLibraryEx on ISAPI filter "C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_filter.dll" failed<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<span style="font-family: "Trebuchet MS",sans-serif;">Installed .NET Framework 1.1 for Driver caused TDoD Service to stop
with error - Calling LoadLibraryEx on ISAPI filter "C:\Windows\<a href="http://microsoft.net/">Microsoft.NET</a>\Framework\v4.0.30319\aspnet_filter.dll" failed.</span></div>
<div style="text-align: left;">
<br /></div>
<div class="last_child" style="text-align: left;">
<span style="font-family: "Trebuchet MS",sans-serif;">To fix the error remove ISAPI extension from ISAPI filters added in website by .NET Fx 1.1 installer.</span></div>
<div class="last_child">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJ4jBRarflzgZR-Mi-NXRdPzNEzKsaNzooJQt3_eYe7H6FpTboXLrYz5tgX8fT4HvTSYZMTobNd4ohJ2nakraGIMg6J4A_vc_g9Cu8xRvBsOOa0VlcnMN9WLvrPGQucHIJbe5sGQ/s1600/ErrorISAPI.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="201" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJ4jBRarflzgZR-Mi-NXRdPzNEzKsaNzooJQt3_eYe7H6FpTboXLrYz5tgX8fT4HvTSYZMTobNd4ohJ2nakraGIMg6J4A_vc_g9Cu8xRvBsOOa0VlcnMN9WLvrPGQucHIJbe5sGQ/s640/ErrorISAPI.png" width="640" /></a></div>
<div class="last_child">
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-13735966145403227772013-07-16T21:56:00.000+05:302013-07-18T18:14:59.571+05:30Python Libraries For Scraping<div dir="ltr" style="text-align: left;" trbidi="on">
List of python scraping libraries I use to develop crawlers based on my choice of scraping library:<br />
<ol style="text-align: left;">
<li>No other than - <a href="http://scrapy.org/" rel="nofollow" target="_blank">SCRAPY</a> - fast high-level screen scraping and web crawling
framework, used to crawl websites and extract structured data from their
pages. It can be used for a wide range of purposes, from data mining to
monitoring and automated testing</li>
<li>UrlLib2 + Beautiful Soup - If I had to build framework from scratch this is the first choice</li>
<li>Mechanize + Beautiful Soup - Replace UrlLib2 with <a href="http://wwwsearch.sourceforge.net/mechanize/" rel="nofollow" target="_blank">Mechanize </a>- Easy HTML form filling, any URL can be opened, not just <code>HTTP, </code>Automatic handling of HTTP-Equiv and Refresh, Easy link parsing and following </li>
</ol>
Please leave a feedback if you are using some other library that I should list here.<br />
<br />
BeClasp Consulting provides Python and .NET based website scraping service and have wrote 1000's of parsers so far ranging from data crawling for Bank Accounts reconciliation, e-commerce stores or other data mining services. Drop us an email at mail@beclaspconsulting.net to know more about the services we offer.</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-17236312777548074552013-05-01T02:06:00.000+05:302013-07-16T22:12:24.968+05:30Outsource .NET Development<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Are you exploring the possibilities to outsource your next .NET application? Beclasp Consulting offers a dedicated Offshore .NET Developers team to provide you best in class results through Microsoft Certified Developers. To know more please visit:<br />
<br />
<a href="http://beclaspconsulting.net/outsource-dotnet-application-development">http://beclaspconsulting.net/outsource-dotnet-application-development</a><br />
<br /></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-49289508528680312802012-05-17T16:48:00.001+05:302012-05-17T16:48:06.361+05:30The 'DbProviderFactories' section can only appear once per config file<div dir="ltr" style="text-align: left;" trbidi="on">
Open machine.config at:<br />
C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\Machine.Config<br />
<br />
Locate section:<br />
<system.data><br />
<DbProviderFactories><br />
<!-- providers added here --><br />
<add name="... /><br />
</DbProviderFactories><br />
<br />
Line to be removed to resolve the issue<br />
<strong><strike><span style="color: red;"><DbProviderFactories/></span></strike></strong><br />
</system.data><br />
done!<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
</div>Unknownnoreply@blogger.com4tag:blogger.com,1999:blog-38870903.post-66074012080654696972012-04-17T12:37:00.000+05:302012-04-17T12:37:49.578+05:30Could not load file or assembly 'Oracle.DataAccess' or one of its dependencies. An attempt was made to load a program with an incorrect format<div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: Georgia, "Times New Roman", serif;"><strong>Solution</strong>: <strong>In IIS Set 'Enable 32bit Applications' to True for the application pool used in the site.</strong></span><br />
<br />
<span style="font-family: Georgia, "Times New Roman", serif;">If you are using ODP.NET in 64bit machine and have installed ODP.NET 32bit version you may get the error:</span><br />
<br />
<strong><span style="font-family: Georgia, "Times New Roman", serif;">'Could not load file or assembly 'Oracle.DataAccess' or one of its dependencies. An attempt was made to load a program with an incorrect format'</span></strong><br />
<br />
<span style="font-family: Georgia;">To resolve the issue:</span><br />
<ul style="text-align: left;"><li><span style="font-family: Georgia;">Select application pool that is getting used in the site. </span></li>
<li><span style="font-family: Georgia;">Click on Advanced Settings...</span></li>
<li><span style="font-family: Georgia;">Enable 32-Bit Applications - True</span></li>
<li><span style="font-family: Georgia;">OK</span></li>
<li><span style="font-family: Georgia;">You are done!</span></li>
</ul></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-12929638489047832272012-01-30T07:09:00.000+05:302012-01-30T07:09:45.804+05:30SQL Server 2012 (Denali): OFFSET and FETCH Limitations<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">OFFSET and FETCH can be used in any query that allows TOP and ORDER BY with the following limitations:</span></div><ol style="font-family: Verdana,sans-serif; text-align: left;"><li><span style="font-size: x-small;">The OVER clause does not support OFFSET and FETCH.</span></li>
<li><span style="font-size: x-small;">OFFSET and FETCH cannot be specified directly in INSERT, UPDATE, MERGE, and DELETE statements, but can be specified in a subquery defined in these statements. For example, in the INSERT INTO SELECT statement, OFFSET and FETCH can be specified in the SELECT statement.</span></li>
<li><span style="font-size: x-small;">In a query that uses UNION, EXCEPT or INTERSECT operators, OFFSET and FETCH can only be specified in the final query that specifies the order of the query results.</span></li>
<li><span style="font-size: x-small;">TOP cannot be combined with OFFSET and FETCH in the same query expression (in the same query scope).</span></li>
</ol></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-39201182440981736862012-01-30T07:07:00.000+05:302012-01-30T07:07:00.759+05:30SQL Server 2012 (Denali) New Features: Limit number of rows using OFFSET and FETCH clauseLimiting the number of rows returned<br />
<br />
The following example specifies an integer constant as the value for the OFFSET and FETCH clauses. The first query returns all rows sorted by the column ID. Compare the results returned by this query with the results of the two queries that follow it. The next query uses the clause OFFSET 5 ROWS to skip the first 5 rows and return all remaining rows. The final query uses the clause OFFSET 0 ROWS to start with the first row and then uses FETCH NEXT 10 ROWS ONLY to limit the rows returned to 10 rows from the sorted result set.<br />
<br />
-- Return all rows sorted by the column DepartmentID.<br />
SELECT ID, Name, GroupName<br />
FROM Department<br />
ORDER BY ID;<br />
<br />
-- Skip the first 5 rows from the sorted result set and return all remaining rows.<br />
SELECT ID, Name, GroupName<br />
FROM Department<br />
ORDER BY ID OFFSET 5 ROWS;<br />
<br />
-- Skip 0 rows and return only the first 10 rows from the sorted result set.<br />
SELECT ID, Name, GroupName<br />
FROM Department<br />
ORDER BY ID<br />
OFFSET 0 ROWS<br />
FETCH NEXT 10 ROWS ONLY;Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-57174217808609897312012-01-30T06:52:00.000+05:302012-01-30T06:52:19.425+05:30SQL Server 2012 (Denali) New Features for Developers (Programming Enhancements)<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">Programmability enhancements in the Database Engine include FileTables, statistical semantic search, property-scoped full-text search and customizable proximity search, ad-hoc query paging, circular arc segment support for spatial types, support for sequence objects, default support for 15,000 partitions, and numerous improvements and additions to Transact-SQL.<br />
<br />
<b>Native XML Web Services (SOAP/HTTP endpoints) is Removed:</b><br />
Beginning in Microsoft SQL Server 2012 Release Candidate 0 (RC 0), you can no longer use CREATE ENDPOINT or ALTER ENDPOINT to add or modify SOAP/HTTP endpoints.<br />
<br />
<b>FileTables:</b><br />
The FileTable feature builds on top of the SQL Server FILESTREAM technology to bring support for the Windows file namespace and compatibility with Windows applications to the file data stored in SQL Server. This lets an application integrate its storage and data management components, and provides integrated SQL Server services (including full-text search and semantic search) over unstructured data and metadata, along with easy policy management and administration.<br />
<br />
In summary, you can now store files and documents in special tables in SQL Server, but access them from Windows applications as if they were stored in the file system, without making any changes to the Windows applications.<br />
<br />
<br />
<b>Metadata Discovery</b>:<br />
The SET FMTONLY option for determining the format of a response without actually running the query is replaced with <br />
sp_describe_first_result_set, <br />
sp_describe_undeclared_parameters, <br />
sys.dm_exec_describe_first_result_set, and <br />
sys.dm_exec_describe_first_result_set_for_object.<br />
<br />
<b>EXECUTE Statement</b><br />
The EXECUTE statement can now specify the metadata returned from the statement by using the WITH RESULT SETS argument. <br />
<br />
A new family of supplementary characters (SC) collations can be used with the data types nchar, nvarchar and sql_variant. <br />
For example: Latin1_General_100_CI_AS_SC or, if using a Japanese collation, Japanese_Bushu_Kakusu_100_CI_AS_SC. <br />
These collations encode Unicode characters in the UTF-16 format. Characters with codepoint values larger than 0xFFFF require two consecutive 16-bit words. These characters are called supplementary characters, and the two consecutive 16-bit words are called surrogate pairs. SC collations can improve searching and sorting by functions that use the Unicode types nchar and nvarchar. For more information, see Collation and Unicode Support.<br />
UTF-16 Supplementary Characters (SC) Collation Option for XML<br />
<br />
<br />
<b>Ad-hoc Query Paging Implementation</b><br />
You can specify a range of rows returned by a SELECT statement based on row offset and row count values that you provide. This is useful when you want to control the number of rows sent to a client application for a given query.</span> </div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">SELECT ID, Name</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">FROM Person<br />
ORDER BY ID<br />
OFFSET 10 ROWS<br />
FETCH NEXT 10 ROWS ONLY;</span></div><div style="font-family: Verdana,sans-serif;"><br />
<span style="font-size: x-small;">New Spatial Features<br />
Circular Arc Segment Support for Spatial Types<br />
<br />
Three new sub-data types for geometry and geography data types can be used to store circular arc segments, CircularString, CompoundCurve, and CurvePolygon. Methods for geography and geometry data types support the new circular arc segment data types. There are new methods for geometry and geography data types that work with circular arc segments, OGC Methods on Geography Instances, OGC Methods on Geometry Instances, Extended Methods on Geography Instances, Extended Methods on Geometry Instances and SQL MM Methods on Geography Instances. There are new static aggregate methods for geometry data type and geography data type, Extended Static Geography Methods and Extended Static Geometry Methods.<br />
<br />
<b>Sequence Objects</b>A sequence object is a user-defined schema-bound object that generates a sequence of numeric values according to the specification with which the sequence was created. It operates similar to an identity column, but sequence numbers are not restricted to use in a single table.<br />
<br />
<b>THROW statement</b>The THROW statement can be used to raise an exception and transfer execution to a CATCH block of a TRY…CATCH construct.<br />
<br />
14 New Functions and 1 Changed Function:<br />
<br />
Microsoft SQL Server 2012 Release Candidate 0 (RC 0) introduces 14 new built-in functions. These functions ease the path of migration for information workers by emulating functionality that is found in the expression languages of many desktop applications. However these functions will also be useful to experienced users of SQL Server.<br />
<br />
The new functions are:<br />
<b>Conversion functions</b> PARSE<br />
TRY_CONVERT<br />
TRY_PARSE<br />
<b>Date and time functions</b> DATEFROMPARTS<br />
DATETIME2FROMPARTS<br />
DATETIMEFROMPARTS<br />
DATETIMEOFFSETFROMPARTS<br />
EOMONTH<br />
SMALLDATETIMEFROMPARTS<br />
TIMEFROMPARTS<br />
<b>Logical functions</b><br />
CHOOSE<br />
IIF<br />
<b>String functions</b><br />
CONCAT<br />
FORMAT<br />
<br />
In addition to the 14 new functions, one existing function has been changed. The existing LOG function now has an optional second base parameter.</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br />
<b>SQL Server Express LocalDB</b>SQL Server Express LocalDB is a new lightweight edition of Express that has all its programmability features, yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites. The LocalDB edition of SQL Server is targeted to program developers. LocalDB installation copies a minimal set of files necessary to start the SQL Server Database Engine. To use the SQL Server Database Engine, developers connect directly to the database files and the SQL Server infrastructure is transparent to them. Developer Tools can provide developers with a SQL Server Database Engine that lets them write and test Transact-SQL code without having to manage a full server instance of SQL Server. An instance of SQL Server Express LocalDB is managed by using the SqlLocalDB.exe utility. SQL Server Express LocalDB should be used in place of the SQL Server Express user instance feature which is deprecated.<br />
<br />
<b>New and Enhanced Query Optimizer Hints</b>The syntax for the FORCESEEK table hint has been modified. <br />
You can now specify an index and index columns to further control the access method on the index. The existing FORCESEEK syntax remains unmodified and works as before. No changes to applications are necessary if you do not plan to use the new functionality.<br />
<br />
The FORCESCAN table hint has been added. It complements the FORCESEEK hint by specifying that the query optimizer use only an index scan operation as the access path to the table or view referenced in the query. The FORCESCAN hint can be useful for queries in which the optimizer underestimates the number of affected rows and chooses a seek operation rather than a scan operation. FORCESCAN can be specified with or without an INDEX hint.<br />
<br />
<b>Extended Event Enhancements</b>The following new Extended Events are available.<br />
page_allocated:<br />
Fields: worker_address, number_pages, page_size, page_location, allocator_type, page_allocator_type, pool_id<br />
page_freed:<br />
Fields: worker_address, number_pages, page_size, page_location, allocator_type, page_allocator_type, pool_id<br />
allocation_failure:<br />
Fields: worker_address, failure_type, allocation_failure_type, resource_size, pool_id, factor<br />
<br />
The following Extended Events have been modified.<br />
resource_monitor_ring_buffer_record:<br />
Fields removed: single_pages_kb, multiple_pages_kb<br />
Fields added: target_kb, pages_kb<br />
<br />
memory_node_oom_ring_buffer_recorded:<br />
Fields removed: single_pages_kb, multiple_pages_kb<br />
Fields added: target_kb, pages_kb<br />
<br />
<br />
<b>OVER Clause Support Enhanced</b><br />
The OVER clause has been extended to support window functions. Window functions perform a calculation across a set of rows that are in some relationship to the current row. For example, you can use the ROWS or RANGE clause over a set of rows to calculate a moving average or cumulative total.<br />
In addition, ordering rows within a partition is now supported in the aggregate functions that allow the OVER clause to be specified.<br />
<br />
Analytic Functions<br />
The following analytic functions have been added.<br />
CUME_DIST<br />
LAST_VALUE<br />
PERCENTILE_DISC<br />
FIRST_VALUE<br />
LEAD<br />
PERCENT_RANK<br />
LAG<br />
PERCENTILE_CONT</span></div></div>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-38870903.post-50965672833403038202012-01-30T06:36:00.000+05:302012-01-30T06:36:09.350+05:30SQL Server 2012 (Denali) New Features for Developers (Programming Enhancements) - Sequences<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><b>Sequences:</b></span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">Sequence is a user defined object that generates a sequence of a number. Here is an example using Sequence. It operates similar to an identity column, but sequence numbers are not restricted to use in a single table.</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br />
</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><b>How to create Sequence</b>: </span></div><blockquote style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">/****** Create Sequence Object ******/<br />
CREATE SEQUENCE SequenceObj<br />
START WITH 1<br />
INCREMENT BY 1;</span></blockquote><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br />
</span></div><blockquote style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">/****** Create Temp Table ******/<br />
DECLARE @Person TABLE<br />
(<br />
ID int NOT NULL PRIMARY KEY,<br />
FullName nvarchar(100) NOT NULL<br />
);</span></blockquote><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><b>How to get </b>Next Value For </span><span style="font-size: x-small;"><b>Sequence</b></span><span style="font-size: x-small;">: </span></div><blockquote style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">/****** Insert Some Data ******/<br />
INSERT @Person (ID, FullName)<br />
VALUES (NEXT VALUE FOR </span><span style="font-size: x-small;">SequenceObj</span><span style="font-size: x-small;">, 'Brian Lauber'),<br />
(NEXT VALUE FOR MySequence, 'Joel Winstead'),<br />
(NEXT VALUE FOR MySequence, 'Patrick Murphy');</span><br />
<span style="font-size: x-small;">/****** Show the Data ******/<br />
SELECT * FROM @Person;</span><br />
<span style="font-size: x-small;">The results would look like this:</span><br />
<span style="font-size: x-small;"> </span><span style="font-size: x-small;">ID FullName<br />
1 </span><span style="font-size: x-small;">Brian Lauber </span></blockquote><blockquote style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">2 Joel Winstead </span></blockquote><blockquote style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">3 Patrick Murphy</span></blockquote><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"> </span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><b>Viewing Details About Sequences on Your SQL Server</b></span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">You can query SQL Server to show the sequences that are in a database.</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">SELECT * FROM sys.sequences </span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br />
</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><b>When to use Sequence vs Identity Columns</b><br />
<br />
Use sequences instead of identity columns in the following scenarios:</span></div><ol style="font-family: Verdana,sans-serif; text-align: left;"><li><span style="font-size: x-small;">The application requires a number before the insert into the table is made.</span></li>
<li><span style="font-size: x-small;">The application requires sharing a single series of numbers between multiple tables or multiple columns within a table.</span></li>
<li><span style="font-size: x-small;">The application must restart the number series when a specified number is reached. For example, after assigning values 1 through 10, the application starts assigning values 1 through 10 again.</span></li>
<li><span style="font-size: x-small;">The application requires sequence values to be sorted by another field. The NEXT VALUE FOR function can apply the OVER clause to the function call. The OVER clause guarantees that the values returned are generated in the order of the OVER clause's ORDER BY clause.</span></li>
<li><span style="font-size: x-small;">An application requires multiple numbers to be assigned at the same time. For example, an application needs to reserve five sequential numbers. Requesting identity values could result in gaps in the series if other processes were simultaneously issued numbers. Calling sp_sequence_get_range can retrieve several numbers in the sequence at once.</span></li>
<li><span style="font-size: x-small;">You need to change the specification of the sequence, such as the increment value.</span></li>
</ol><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><b>Sequence Limitations:</b></span><br />
<span style="font-size: x-small;">Unlike identity columns, whose values cannot be changed, sequence values are not automatically protected after insertion into the table. To prevent sequence values from being changed, use an update trigger on the table to roll back changes.<br />
<br />
Uniqueness is not automatically enforced for sequence values. The ability to reuse sequence values is by design. If sequence values in a table are required to be unique, create a unique index on the column. If sequence values in a table are required to be unique throughout a group of tables, create triggers to prevent duplicates caused by update statements or sequence number cycling.<br />
<br />
The sequence object generates numbers according to its definition, but the sequence object does not control how the numbers are used. Sequence numbers inserted into a table can have gaps when a transaction is rolled back, when a sequence object is shared by multiple tables, or when sequence numbers are allocated without using them in tables. When created with the CACHE option, an unexpected shutdown, such as a power failure, can lose the sequence numbers in the cache. </span><br />
<span style="font-size: x-small;"><br />
</span><br />
<span style="font-size: x-small;"><b>More on Sequences:</b></span><br />
<span style="font-size: x-small;"><a href="http://msdn.microsoft.com/en-us/library/ff878058%28v=sql.110%29.aspx">http://msdn.microsoft.com/en-us/library/ff878058%28v=sql.110%29.aspx</a></span></div></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-28443888283944903252012-01-24T15:47:00.000+05:302015-07-15T11:55:30.627+05:30SQL Server Performance - Part 1<div dir="ltr" style="text-align: left;" trbidi="on">
I recently delivered training on SQL Server Performance factors. Look for upcoming blog posts for these topics to be covered up in near future:<br />
<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true"
DefSemiHidden="true" DefQFormat="false" DefPriority="99"
LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false"
UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
</style> <![endif]--> <br />
<div class="MsoListParagraphCxSpFirst" style="line-height: normal; mso-add-space: auto; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">1.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Data Organization in SQL Server</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.0in; mso-add-space: auto; mso-list: l0 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">a.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">B-Tree (Balanced Tree)</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.5in; mso-add-space: auto; mso-list: l0 level3 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; mso-text-indent-alt: -9.0pt; text-indent: -1.5in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;"><span style="font: 7.0pt "Times New Roman";"> </span>i.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Index Root</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.5in; mso-add-space: auto; mso-list: l0 level3 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; mso-text-indent-alt: -9.0pt; text-indent: -1.5in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;"><span style="font: 7.0pt "Times New Roman";"> </span>ii.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Data Page</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.5in; mso-add-space: auto; mso-list: l0 level3 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; mso-text-indent-alt: -9.0pt; text-indent: -1.5in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;"><span style="font: 7.0pt "Times New Roman";"> </span>iii.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Intermediate Node</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.5in; mso-add-space: auto; mso-list: l0 level3 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; mso-text-indent-alt: -9.0pt; text-indent: -1.5in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;"><span style="font: 7.0pt "Times New Roman";"> </span>iv.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Leaf Node</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.5in; mso-add-space: auto; mso-list: l0 level3 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; mso-text-indent-alt: -9.0pt; text-indent: -1.5in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;"><span style="font: 7.0pt "Times New Roman";"> </span>v.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Index Row</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.5in; mso-add-space: auto; mso-list: l0 level3 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; mso-text-indent-alt: -9.0pt; text-indent: -1.5in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;"><span style="font: 7.0pt "Times New Roman";"> </span>vi.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Example of Jumps</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.0in; mso-add-space: auto; mso-list: l0 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">b.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Heap</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; mso-add-space: auto; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">2.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Index</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.0in; mso-add-space: auto; mso-list: l0 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">a.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Index Types</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.5in; mso-add-space: auto; mso-list: l0 level3 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; mso-text-indent-alt: -9.0pt; text-indent: -1.5in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;"><span style="font: 7.0pt "Times New Roman";"> </span>i.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Clustered</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.5in; mso-add-space: auto; mso-list: l0 level3 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; mso-text-indent-alt: -9.0pt; text-indent: -1.5in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;"><span style="font: 7.0pt "Times New Roman";"> </span>ii.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Non-Clustered</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 2.0in; mso-add-space: auto; mso-list: l0 level4 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">1.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Included Columns</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 2.0in; mso-add-space: auto; mso-list: l0 level4 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">2.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Covering Index</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 2.0in; mso-add-space: auto; mso-list: l0 level4 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">3.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Filter Index</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; mso-add-space: auto; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">3.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Index Fragmentation</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.0in; mso-add-space: auto; mso-list: l0 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">a.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Fragmentation</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.0in; mso-add-space: auto; mso-list: l0 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">b.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Fill Factor</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; mso-add-space: auto; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">4.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Execution Plan</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.0in; mso-add-space: auto; mso-list: l0 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">a.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Compute Scalar</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.5in; mso-add-space: auto; mso-list: l0 level3 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; mso-text-indent-alt: -9.0pt; text-indent: -1.5in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;"><span style="font: 7.0pt "Times New Roman";"> </span>i.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Stream Aggregate</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.5in; mso-add-space: auto; mso-list: l0 level3 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; mso-text-indent-alt: -9.0pt; text-indent: -1.5in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;"><span style="font: 7.0pt "Times New Roman";"> </span>ii.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Hash Aggregate</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.0in; mso-add-space: auto; mso-list: l0 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">b.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Index Seek</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.5in; mso-add-space: auto; mso-list: l0 level3 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; mso-text-indent-alt: -9.0pt; text-indent: -1.5in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;"><span style="font: 7.0pt "Times New Roman";"> </span>i.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Clustered Index Seek</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.5in; mso-add-space: auto; mso-list: l0 level3 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; mso-text-indent-alt: -9.0pt; text-indent: -1.5in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;"><span style="font: 7.0pt "Times New Roman";"> </span>ii.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Index Seek</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.0in; mso-add-space: auto; mso-list: l0 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">c.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Index Scan</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.5in; mso-add-space: auto; mso-list: l0 level3 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; mso-text-indent-alt: -9.0pt; text-indent: -1.5in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;"><span style="font: 7.0pt "Times New Roman";"> </span>i.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Clustered Index Scan</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.5in; mso-add-space: auto; mso-list: l0 level3 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; mso-text-indent-alt: -9.0pt; text-indent: -1.5in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;"><span style="font: 7.0pt "Times New Roman";"> </span>ii.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Index Scan</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.0in; mso-add-space: auto; mso-list: l0 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">d.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Key Lookup (Bookmark Lookup)</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.0in; mso-add-space: auto; mso-list: l0 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">e.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Nested Loops</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.0in; mso-add-space: auto; mso-list: l0 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">f.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Hash Match</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.0in; mso-add-space: auto; mso-list: l0 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">g.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Merge Join</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.0in; mso-add-space: auto; mso-list: l0 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">h.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Sort</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; mso-add-space: auto; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">5.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Indexed Views</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; mso-add-space: auto; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">6.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Partitioning</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.0in; mso-add-space: auto; mso-list: l0 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">a.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Partition Function (How to partition)</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.5in; mso-add-space: auto; mso-list: l0 level3 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; mso-text-indent-alt: -9.0pt; text-indent: -1.5in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;"><span style="font: 7.0pt "Times New Roman";"> </span>i.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">RANGE RIGHT</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-left: 1.5in; mso-add-space: auto; mso-list: l0 level3 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; mso-text-indent-alt: -9.0pt; text-indent: -1.5in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;"><span style="font: 7.0pt "Times New Roman";"> </span>ii.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">RANGE LEFT</span></div>
<div class="MsoListParagraphCxSpLast" style="line-height: normal; margin-left: 1.0in; mso-add-space: auto; mso-list: l0 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3; text-indent: -.25in;">
<span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Cambria; mso-bidi-font-weight: bold; mso-bidi-theme-font: major-latin; mso-fareast-font-family: Cambria; mso-fareast-theme-font: major-latin; mso-hansi-theme-font: major-latin;"><span style="mso-list: Ignore;">b.<span style="font: 7.0pt "Times New Roman";"> </span></span></span><span style="font-family: "Cambria","serif"; font-size: 10.0pt; mso-ascii-theme-font: major-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin;">Partition Scheme (Where to partition)</span></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-26090086806304711762011-04-14T03:04:00.000+05:302011-04-14T03:04:54.101+05:30Use Table Valued Parameters instead of IN clause (SQL Server Stack Overflow Issue)<div dir="ltr" style="text-align: left;" trbidi="on"><table style="color: #20124d; font-family: Verdana,sans-serif;"><tbody>
<tr><td class="votecell"><div class="post-text"><span style="font-size: x-small;">Every SQL batch has to fit in the <a href="http://msdn.microsoft.com/en-us/library/ms143432.aspx" rel="nofollow">Batch Size Limit</a>: 65,536 * Network Packet Size.</span><br />
<span style="font-size: x-small;">Your query is also limited by run time conditions. It will cause stack overflow because x IN (a,b,c) is nothing but x=a OR x=b OR x=c which creates an expression tree similar to x=a OR (x=b OR (x=c)), so it will become too deep for a large number of OR conditions. SQL 7 would hit a Stack Overflow <a href="http://support.microsoft.com/kb/288095" rel="nofollow">at about 10k values in the IN</a>, but now a days stacks are much deeper (because of x64), so it can go pretty deep.</span><br />
<br />
<span style="font-size: x-small;">Still if the IN clause is getting generated dynamically prefer <a href="http://msdn.microsoft.com/en-us/library/bb510489.aspx">Table Valued Parameters</a> or use XML data type. </span></div></td> <td><span style="font-size: x-small;"><br />
</span></td></tr>
</tbody></table></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-13168157513180772932011-02-19T10:58:00.000+05:302011-02-19T10:58:37.410+05:30Cleared SQL Server 2008 MCITP<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: "Trebuchet MS",sans-serif;">Cleared <a href="http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-451&locale=en-us#tab1">SQL Server 2008 MCITP</a></div></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-5640314150715843842011-02-16T03:46:00.001+05:302011-02-16T03:47:21.313+05:30IncludeTotalCount Silverlight RIA Service (Server Side Paging)<div dir="ltr" style="text-align: left;" trbidi="on"><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><br />
</div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">If you are using Server Side Paging (may be at database or service end) and returning limited set of results you may find it difficult to get the TotalItemCount of your entities.</span></div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><br />
</div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">But the answer is simple enough:</span></div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><br />
</div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">//Enable IncludeTotalCount to true in View/ViewModel before calling the data context to load data</span></div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">EntityQuery<x> query = _assessmentContext.XQuery(1, this._pageIndex, this._pageSize);<br />
<b>query.IncludeTotalCount = true; </b>// Specify that service need to collect the total item count somehow</x></span></div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">//Load your Entity asynchronously here</span></div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"><br />
// Enable your service to set an out parameter for total item count:</span></div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><br />
</div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">[Query]</span></div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">public IQueryable<x> Xs(int xID, int pageIndex, int pageSize, <b>out int totalCount</b>)</x></span></div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">{</span></div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"> <b>totalCount</b> = 110;<br />
}</span></div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">That's it you are done you can now get the total item count in the load operation result:</span></div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="color: #20124d; font-family: "Trebuchet MS",sans-serif;"><span style="font-size: small;">private void XsLoadingCompleted(LoadOperation<x> lo)<br />
{<br />
this.BusyContent = ApplicationStrings.LoadingXs;<br />
<br />
if (!lo.HasError)<br />
{<br />
this.XItemCount = <b>lo.TotalEntityCount</b>; // total item count that you set through the out parameter //in your domain service.</x></span></div></div>Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-38870903.post-81477143141336464642010-11-05T19:43:00.004+05:302010-11-05T20:06:26.646+05:30Cygwin - Pass commands (parameters) at startupThere is a lot of stuff you will find regarding Cygwin but I was willing to pass some commands to Cygwin from Hudson CI server at start up but no body is telling it in simple way. So lets dive into it:<br />
Step 1. Go to Cygwin installation directory<br />
Step 2. Locate Cygwin.bat and right click and select edit (backup before editing :))<br />
Step 3. <br />
Initial Structure:<br />
------------------------<br />
@echo off<br />
C:<br />
chdir C:\cygwin\bin<br />
bash --login -i<br />
------------------------<br />
<br />
Add your command as:<br />
bash --login -i -c 'your commands here'<br />
-- To pass more than one command seperate them using ; (semi) <br />
example:<br />
bash --login -i -c 'cd $X;cd $Y;clear;'<br />
<br />
You are done :) Oops save the file<br />
Start your Cygwin shell it will pass the commands as expected<br />
<br />
<br />
If you want to pass some parameters from outside (e.g. Hudson or command prompt) use %1, %2, %3<br />
e.g. from hudson: cygwin 'shashank'<br />
bash --login -i -c 'print %1'<br />
<br />
print's shashank in the cygwin shell. Use Hudson Console output window to view.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-90761222319224442582010-10-12T20:12:00.007+05:302010-10-15T20:56:27.510+05:30Java! What the Hell (No Support for Unsigned) (UTF-8 Encoding Bug)Recently I got some work again in Java and it's around 5 years back when I last developed any application in Java. A lot of changes are here but I got a lot of issues with Java after coming from C#. In two worlds 'Java Sucks' if you are coming from C#. This was not the thought for me when I switched from Java to C#.<br /><br />Why?<br /><br />1. I required to deal with a lot with the binary data that has unsigned bytes but <span style="font-style: italic;"><u>woh ho</u></span> Java doesn't support unsigned int, unsigned byte. On asking one of my Java colleague (he loves java and hates C# as most of the people from Java background do) he said are you programming for some ancient age. Now no body uses unsigned things. What the solution this is? However wrote a tiny library to solve it. If you require it just drop me a mail I can send it.<br /><br />2. Java Encoding Issue (UTF-8 with BOM): Java has a bug in the bug database from Sep-2001 that has been closed with no-fix and the reasoning behind it is:<br /><br />http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=4508058<br /><i><br />"<br />The assumption we made to implement this RFE is that the change would not<br />break existing real world application, this assumption is obvious<br />not true, see #6378911. We decided to back out the change we've made<br />and closed this RFE as "will not fix", for compatibility reason.<br />Posted Date : 2006-02-18 02:33:09.0<br />" </i><br />What are you talking about?<br />I got some C# files that were getting laxically analyzed and parsed using ANTLR 3.2 in a Linux system using Java. And <span style="font-weight: bold;">what </span>I got an out of memory exception (heap out of space). What the hell I did. I am loading a 4kb file and its going out of memory. It was the encoding issue. However I managed to get the resolution here:<br />http://koti.mbnet.fi/akini/java/unicodereader/<br /><br />Now I think C# is much more richer and friendly language than Java.<br /><br />Please don't mind it and take personally if you love Java and I am not here to remark on any language capabilities but its my personal choice to work with C#.Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-38870903.post-35166140984643109292009-09-17T11:44:00.003+05:302009-09-17T12:36:54.277+05:30Merge Statement SQL Server 2008MERGE statement is introduced in SQL Server 2008 that can greatly enhance the functionality for Data Warehouse and the staging servers.<br /><br />The Merge statement allows you to perform DML actions on target table based on whether<br />or not a row matches information found in source table.<br /><br />A common Merge scenario is moving data from one table to another.<br /><br />Like User and UserHistory<br /><br />User Table :<br /><br />CREATE TABLE [dbo].[User]<br />(<br /> [Id] [int] IDENTITY(1,1) NOT NULL,<br /> [Name] [varchar](50) NOT NULL,<br /> [Age] [int] NOT NULL,<br /> [Is_Active] [bit] NULL,<br /> [CREATE_DATE] [date] NOT NULL<br />)<br /><br />GO<br /><br />ALTER TABLE [dbo].[User] ADD CONSTRAINT [DF_User_CREATE_DATE] DEFAULT (getdate()) FOR [CREATE_DATE]<br /><br />GO<br /><br />AND<br />UserHistory Table is like:<br /><br />CREATE TABLE UserHistory<br />(<br /> HistoryId INT IDENTITY(1, 1),<br /> Id INT NOT NULL,<br /> Name VARCHAR(50) NOT NULL,<br /> Age INT NOT NULL,<br /> Is_Active BIT NULL,<br /> Create_Date DATE NOT NULL<br />)<br /><br />------------------------------------------------------------------------------------<br /><br />Now insert some data in user table and try running this query more than once and look<br />on the results that are produced by OUTPUT and $action clauses:<br /><br />MERGE INTO UserHistory AS UH<br /> USING [User] as U<br /> ON U.Id = UH.Id<br />WHEN MATCHED THEN<br /> UPDATE SET UH.Id = U.Id, UH.Name = U.Name<br /> ,UH.Is_Active = U.Is_Active, UH.Create_date = U.Create_date<br />WHEN NOT MATCHED BY TARGET THEN<br /> INSERT (Id, Name, Age, Is_Active, Create_Date)<br /> VALUES (Id, Name, Age, Is_Active, Create_Date)<br />WHEN NOT MATCHED BY SOURCE THEN<br /> Update SET IS_ACTIVE = 0<br />Output $action, inserted.*;<br /><br />-------------------------------------------------------------------------------------<br />You can perform insert, update and delete operation by matching the Source Table (User)<br />and the Target Table (UserHistory) in a single operation and can have the details about the<br />action from OUTPUT clause and using $action you can know the operation performedUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-17683168572707181282009-09-16T17:41:00.002+05:302009-09-16T17:46:36.049+05:30SQL Server 2008:Output Clause SampleSo with SQL Server 2008 we have output clause available inside the query that means we can access the inserted, deleted or updated value form the output clause inside a Stored Procedure and we need not to write a trigger<br /><br />Ex.<br />Suppose we have a user table on inserting the data we need to insert the same value to a table type variable, we can accomplish this task as given below:<br /><span style="font-size:85%;"><br />DECLARE @User TABLE (ID INT, Name VARCHAR(50), Age INT, Is_Active BIT, CREATE_DATE DATETIME)<br />INSERT INTO [User] (Name, Age, Is_Active, CREATE_DATE)<br /><span style="font-weight: bold;">OUTPUT inserted</span>.* INTO @User VALUES ('TESTING', '26', 1, GETDATE())<br /><br />SELECT * FROM @User</span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-51124122703166906562009-06-30T14:59:00.002+05:302009-06-30T15:02:59.060+05:30Create class variables and properties from database table<meta equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 12"><meta name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CSHASHA%7E1.MIS%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CDOCUME%7E1%5CSHASHA%7E1.MIS%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CDOCUME%7E1%5CSHASHA%7E1.MIS%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><!--[if gte mso 9]><xml> <w:worddocument> <w:view>Normal</w:View> <w:zoom>0</w:Zoom> <w:trackmoves/> <w:trackformatting/> <w:punctuationkerning/> <w:validateagainstschemas/> <w:saveifxmlinvalid>false</w:SaveIfXMLInvalid> <w:ignoremixedcontent>false</w:IgnoreMixedContent> <w:alwaysshowplaceholdertext>false</w:AlwaysShowPlaceholderText> <w:donotpromoteqf/> <w:lidthemeother>EN-US</w:LidThemeOther> <w:lidthemeasian>X-NONE</w:LidThemeAsian> <w:lidthemecomplexscript>X-NONE</w:LidThemeComplexScript> <w:compatibility> <w:breakwrappedtables/> <w:snaptogridincell/> <w:wraptextwithpunct/> <w:useasianbreakrules/> <w:dontgrowautofit/> <w:splitpgbreakandparamark/> <w:dontvertaligncellwithsp/> <w:dontbreakconstrainedforcedtables/> <w:dontvertalignintxbx/> <w:word11kerningpairs/> <w:cachedcolbalance/> </w:Compatibility> <w:browserlevel>MicrosoftInternetExplorer4</w:BrowserLevel> <m:mathpr> <m:mathfont val="Cambria Math"> <m:brkbin val="before"> <m:brkbinsub val="--"> <m:smallfrac val="off"> <m:dispdef/> <m:lmargin val="0"> <m:rmargin val="0"> <m:defjc val="centerGroup"> <m:wrapindent val="1440"> <m:intlim val="subSup"> <m:narylim val="undOvr"> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:latentstyles deflockedstate="false" defunhidewhenused="true" defsemihidden="true" defqformat="false" defpriority="99" latentstylecount="267"> <w:lsdexception locked="false" priority="0" semihidden="false" unhidewhenused="false" qformat="true" name="Normal"> <w:lsdexception locked="false" priority="9" semihidden="false" unhidewhenused="false" qformat="true" name="heading 1"> <w:lsdexception locked="false" priority="9" qformat="true" name="heading 2"> <w:lsdexception locked="false" priority="9" qformat="true" name="heading 3"> <w:lsdexception locked="false" priority="9" qformat="true" name="heading 4"> <w:lsdexception locked="false" priority="9" qformat="true" name="heading 5"> <w:lsdexception locked="false" priority="9" qformat="true" name="heading 6"> <w:lsdexception locked="false" priority="9" qformat="true" name="heading 7"> <w:lsdexception locked="false" priority="9" qformat="true" name="heading 8"> <w:lsdexception locked="false" priority="9" qformat="true" name="heading 9"> <w:lsdexception locked="false" priority="39" name="toc 1"> <w:lsdexception locked="false" priority="39" name="toc 2"> <w:lsdexception locked="false" priority="39" name="toc 3"> <w:lsdexception locked="false" priority="39" name="toc 4"> <w:lsdexception locked="false" priority="39" name="toc 5"> <w:lsdexception locked="false" priority="39" name="toc 6"> <w:lsdexception locked="false" priority="39" name="toc 7"> <w:lsdexception locked="false" priority="39" name="toc 8"> <w:lsdexception locked="false" priority="39" name="toc 9"> <w:lsdexception locked="false" priority="35" qformat="true" name="caption"> <w:lsdexception locked="false" priority="10" semihidden="false" unhidewhenused="false" qformat="true" name="Title"> <w:lsdexception locked="false" priority="1" name="Default Paragraph Font"> <w:lsdexception locked="false" priority="11" semihidden="false" unhidewhenused="false" qformat="true" name="Subtitle"> <w:lsdexception locked="false" priority="22" semihidden="false" unhidewhenused="false" qformat="true" name="Strong"> <w:lsdexception locked="false" priority="20" semihidden="false" unhidewhenused="false" qformat="true" name="Emphasis"> <w:lsdexception locked="false" priority="59" semihidden="false" unhidewhenused="false" name="Table Grid"> <w:lsdexception locked="false" unhidewhenused="false" name="Placeholder Text"> <w:lsdexception locked="false" priority="1" semihidden="false" unhidewhenused="false" qformat="true" name="No Spacing"> <w:lsdexception locked="false" priority="60" semihidden="false" unhidewhenused="false" name="Light Shading"> <w:lsdexception locked="false" priority="61" semihidden="false" unhidewhenused="false" name="Light List"> <w:lsdexception locked="false" priority="62" semihidden="false" unhidewhenused="false" name="Light Grid"> <w:lsdexception locked="false" priority="63" semihidden="false" unhidewhenused="false" name="Medium Shading 1"> <w:lsdexception locked="false" priority="64" semihidden="false" unhidewhenused="false" name="Medium Shading 2"> <w:lsdexception locked="false" priority="65" semihidden="false" unhidewhenused="false" name="Medium List 1"> <w:lsdexception locked="false" priority="66" semihidden="false" unhidewhenused="false" name="Medium List 2"> <w:lsdexception locked="false" priority="67" semihidden="false" unhidewhenused="false" name="Medium Grid 1"> <w:lsdexception locked="false" priority="68" semihidden="false" unhidewhenused="false" name="Medium Grid 2"> <w:lsdexception locked="false" priority="69" semihidden="false" unhidewhenused="false" name="Medium Grid 3"> <w:lsdexception locked="false" priority="70" semihidden="false" unhidewhenused="false" name="Dark List"> <w:lsdexception locked="false" priority="71" semihidden="false" unhidewhenused="false" name="Colorful Shading"> <w:lsdexception locked="false" priority="72" semihidden="false" unhidewhenused="false" name="Colorful List"> <w:lsdexception locked="false" priority="73" semihidden="false" unhidewhenused="false" name="Colorful Grid"> <w:lsdexception locked="false" priority="60" semihidden="false" unhidewhenused="false" name="Light Shading Accent 1"> <w:lsdexception locked="false" priority="61" semihidden="false" unhidewhenused="false" name="Light List Accent 1"> <w:lsdexception locked="false" priority="62" semihidden="false" unhidewhenused="false" name="Light Grid Accent 1"> <w:lsdexception locked="false" priority="63" semihidden="false" unhidewhenused="false" name="Medium Shading 1 Accent 1"> <w:lsdexception locked="false" priority="64" semihidden="false" unhidewhenused="false" name="Medium Shading 2 Accent 1"> <w:lsdexception locked="false" priority="65" semihidden="false" unhidewhenused="false" name="Medium List 1 Accent 1"> <w:lsdexception locked="false" unhidewhenused="false" name="Revision"> <w:lsdexception locked="false" priority="34" semihidden="false" unhidewhenused="false" qformat="true" name="List Paragraph"> <w:lsdexception locked="false" priority="29" semihidden="false" unhidewhenused="false" qformat="true" name="Quote"> <w:lsdexception locked="false" priority="30" semihidden="false" unhidewhenused="false" qformat="true" name="Intense Quote"> <w:lsdexception locked="false" priority="66" semihidden="false" unhidewhenused="false" name="Medium List 2 Accent 1"> <w:lsdexception locked="false" priority="67" semihidden="false" unhidewhenused="false" name="Medium Grid 1 Accent 1"> <w:lsdexception locked="false" priority="68" semihidden="false" unhidewhenused="false" name="Medium Grid 2 Accent 1"> <w:lsdexception locked="false" priority="69" semihidden="false" unhidewhenused="false" name="Medium Grid 3 Accent 1"> <w:lsdexception locked="false" priority="70" semihidden="false" unhidewhenused="false" name="Dark List Accent 1"> <w:lsdexception locked="false" priority="71" semihidden="false" unhidewhenused="false" name="Colorful Shading Accent 1"> <w:lsdexception locked="false" priority="72" semihidden="false" unhidewhenused="false" name="Colorful List Accent 1"> <w:lsdexception locked="false" priority="73" semihidden="false" unhidewhenused="false" name="Colorful Grid Accent 1"> <w:lsdexception locked="false" priority="60" semihidden="false" unhidewhenused="false" name="Light Shading Accent 2"> <w:lsdexception locked="false" priority="61" semihidden="false" unhidewhenused="false" name="Light List Accent 2"> <w:lsdexception locked="false" priority="62" semihidden="false" unhidewhenused="false" name="Light Grid Accent 2"> <w:lsdexception locked="false" priority="63" semihidden="false" unhidewhenused="false" name="Medium Shading 1 Accent 2"> <w:lsdexception locked="false" priority="64" semihidden="false" unhidewhenused="false" name="Medium Shading 2 Accent 2"> <w:lsdexception locked="false" priority="65" semihidden="false" unhidewhenused="false" name="Medium List 1 Accent 2"> <w:lsdexception locked="false" priority="66" semihidden="false" unhidewhenused="false" name="Medium List 2 Accent 2"> <w:lsdexception locked="false" priority="67" semihidden="false" unhidewhenused="false" name="Medium Grid 1 Accent 2"> <w:lsdexception locked="false" priority="68" semihidden="false" unhidewhenused="false" name="Medium Grid 2 Accent 2"> <w:lsdexception locked="false" priority="69" semihidden="false" unhidewhenused="false" name="Medium Grid 3 Accent 2"> <w:lsdexception locked="false" priority="70" semihidden="false" unhidewhenused="false" name="Dark List Accent 2"> <w:lsdexception locked="false" priority="71" semihidden="false" unhidewhenused="false" name="Colorful Shading Accent 2"> <w:lsdexception locked="false" priority="72" semihidden="false" unhidewhenused="false" name="Colorful List Accent 2"> <w:lsdexception locked="false" priority="73" semihidden="false" unhidewhenused="false" name="Colorful Grid Accent 2"> <w:lsdexception locked="false" priority="60" semihidden="false" unhidewhenused="false" name="Light Shading Accent 3"> <w:lsdexception locked="false" priority="61" semihidden="false" unhidewhenused="false" name="Light List Accent 3"> <w:lsdexception locked="false" priority="62" semihidden="false" unhidewhenused="false" name="Light Grid Accent 3"> <w:lsdexception locked="false" priority="63" semihidden="false" unhidewhenused="false" name="Medium Shading 1 Accent 3"> <w:lsdexception locked="false" priority="64" semihidden="false" unhidewhenused="false" name="Medium Shading 2 Accent 3"> <w:lsdexception locked="false" priority="65" semihidden="false" unhidewhenused="false" name="Medium List 1 Accent 3"> <w:lsdexception locked="false" priority="66" semihidden="false" unhidewhenused="false" name="Medium List 2 Accent 3"> <w:lsdexception locked="false" priority="67" semihidden="false" unhidewhenused="false" name="Medium Grid 1 Accent 3"> <w:lsdexception locked="false" priority="68" semihidden="false" unhidewhenused="false" name="Medium Grid 2 Accent 3"> <w:lsdexception locked="false" priority="69" semihidden="false" unhidewhenused="false" name="Medium Grid 3 Accent 3"> <w:lsdexception locked="false" priority="70" semihidden="false" unhidewhenused="false" name="Dark List Accent 3"> <w:lsdexception locked="false" priority="71" semihidden="false" unhidewhenused="false" name="Colorful Shading Accent 3"> <w:lsdexception locked="false" priority="72" semihidden="false" unhidewhenused="false" name="Colorful List Accent 3"> <w:lsdexception locked="false" priority="73" semihidden="false" unhidewhenused="false" name="Colorful Grid Accent 3"> <w:lsdexception locked="false" priority="60" semihidden="false" unhidewhenused="false" name="Light Shading Accent 4"> <w:lsdexception locked="false" priority="61" semihidden="false" unhidewhenused="false" name="Light List Accent 4"> <w:lsdexception locked="false" priority="62" semihidden="false" unhidewhenused="false" name="Light Grid Accent 4"> <w:lsdexception locked="false" priority="63" semihidden="false" unhidewhenused="false" name="Medium Shading 1 Accent 4"> <w:lsdexception locked="false" priority="64" semihidden="false" unhidewhenused="false" name="Medium Shading 2 Accent 4"> <w:lsdexception locked="false" priority="65" semihidden="false" unhidewhenused="false" name="Medium List 1 Accent 4"> <w:lsdexception locked="false" priority="66" semihidden="false" unhidewhenused="false" name="Medium List 2 Accent 4"> <w:lsdexception locked="false" priority="67" semihidden="false" unhidewhenused="false" name="Medium Grid 1 Accent 4"> <w:lsdexception locked="false" priority="68" semihidden="false" unhidewhenused="false" name="Medium Grid 2 Accent 4"> <w:lsdexception locked="false" priority="69" semihidden="false" unhidewhenused="false" name="Medium Grid 3 Accent 4"> <w:lsdexception locked="false" priority="70" semihidden="false" unhidewhenused="false" name="Dark List Accent 4"> <w:lsdexception locked="false" priority="71" semihidden="false" unhidewhenused="false" name="Colorful Shading Accent 4"> <w:lsdexception locked="false" priority="72" semihidden="false" unhidewhenused="false" name="Colorful List Accent 4"> <w:lsdexception locked="false" priority="73" semihidden="false" unhidewhenused="false" name="Colorful Grid Accent 4"> <w:lsdexception locked="false" priority="60" semihidden="false" unhidewhenused="false" name="Light Shading Accent 5"> <w:lsdexception locked="false" priority="61" semihidden="false" unhidewhenused="false" name="Light List Accent 5"> <w:lsdexception locked="false" priority="62" semihidden="false" unhidewhenused="false" name="Light Grid Accent 5"> <w:lsdexception locked="false" priority="63" semihidden="false" unhidewhenused="false" name="Medium Shading 1 Accent 5"> <w:lsdexception locked="false" priority="64" semihidden="false" unhidewhenused="false" name="Medium Shading 2 Accent 5"> <w:lsdexception locked="false" priority="65" semihidden="false" unhidewhenused="false" name="Medium List 1 Accent 5"> <w:lsdexception locked="false" priority="66" semihidden="false" unhidewhenused="false" name="Medium List 2 Accent 5"> <w:lsdexception locked="false" priority="67" semihidden="false" unhidewhenused="false" name="Medium Grid 1 Accent 5"> <w:lsdexception locked="false" priority="68" semihidden="false" unhidewhenused="false" name="Medium Grid 2 Accent 5"> <w:lsdexception locked="false" priority="69" semihidden="false" unhidewhenused="false" name="Medium Grid 3 Accent 5"> <w:lsdexception locked="false" priority="70" semihidden="false" unhidewhenused="false" name="Dark List Accent 5"> <w:lsdexception locked="false" priority="71" semihidden="false" unhidewhenused="false" name="Colorful Shading Accent 5"> <w:lsdexception locked="false" priority="72" semihidden="false" unhidewhenused="false" name="Colorful List Accent 5"> <w:lsdexception locked="false" priority="73" semihidden="false" unhidewhenused="false" name="Colorful Grid Accent 5"> <w:lsdexception locked="false" priority="60" semihidden="false" unhidewhenused="false" name="Light Shading Accent 6"> <w:lsdexception locked="false" priority="61" semihidden="false" unhidewhenused="false" name="Light List Accent 6"> <w:lsdexception locked="false" priority="62" semihidden="false" unhidewhenused="false" name="Light Grid Accent 6"> <w:lsdexception locked="false" priority="63" semihidden="false" unhidewhenused="false" name="Medium Shading 1 Accent 6"> <w:lsdexception locked="false" priority="64" semihidden="false" unhidewhenused="false" name="Medium Shading 2 Accent 6"> <w:lsdexception locked="false" priority="65" semihidden="false" unhidewhenused="false" name="Medium List 1 Accent 6"> <w:lsdexception locked="false" priority="66" semihidden="false" unhidewhenused="false" name="Medium List 2 Accent 6"> <w:lsdexception locked="false" priority="67" semihidden="false" unhidewhenused="false" name="Medium Grid 1 Accent 6"> <w:lsdexception locked="false" priority="68" semihidden="false" unhidewhenused="false" name="Medium Grid 2 Accent 6"> <w:lsdexception locked="false" priority="69" semihidden="false" unhidewhenused="false" name="Medium Grid 3 Accent 6"> <w:lsdexception locked="false" priority="70" semihidden="false" unhidewhenused="false" name="Dark List Accent 6"> <w:lsdexception locked="false" priority="71" semihidden="false" unhidewhenused="false" name="Colorful Shading Accent 6"> <w:lsdexception locked="false" priority="72" semihidden="false" unhidewhenused="false" name="Colorful List Accent 6"> <w:lsdexception locked="false" priority="73" semihidden="false" unhidewhenused="false" name="Colorful Grid Accent 6"> <w:lsdexception locked="false" priority="19" semihidden="false" unhidewhenused="false" qformat="true" name="Subtle Emphasis"> <w:lsdexception locked="false" priority="21" semihidden="false" unhidewhenused="false" qformat="true" name="Intense Emphasis"> <w:lsdexception locked="false" priority="31" semihidden="false" unhidewhenused="false" qformat="true" name="Subtle Reference"> <w:lsdexception locked="false" priority="32" semihidden="false" unhidewhenused="false" qformat="true" name="Intense Reference"> <w:lsdexception locked="false" priority="33" semihidden="false" unhidewhenused="false" qformat="true" name="Book Title"> <w:lsdexception locked="false" priority="37" name="Bibliography"> <w:lsdexception locked="false" priority="39" qformat="true" name="TOC Heading"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman";} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]--> <p class="MsoNormal" style="color: rgb(0, 0, 0);"><span style="font-size: 10pt; font-family: "Courier New";">Use the below given query to create variables and properties from your schema.</span></p><p class="MsoNormal" style="color: rgb(0, 0, 0);"><span style="font-size: 10pt; font-family: "Courier New";">Just replace the @tableName variable with the table name for which you want to generate the variables and properties.</span></p><p class="MsoNormal" style="color: rgb(0, 0, 0);">
<br /><span style="font-size: 10pt; font-family: "Courier New";"></span></p><p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New"; color: rgb(0, 0, 0);">This makes use of systypes and </span><span style="font-size: 10pt; font-family: "Courier New";"><span style="color: rgb(0, 0, 0);">syscolumns</span><span style="color: gray;"><span style="color: rgb(0, 0, 0);"> system defined views to get the name of columns from the table and their type. Also add more types as per your requirement.</span>
<br /></span></span></p><p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">-----------------------------------------------------------------------------
<br /></span></p><p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">declare</span><span style="font-size: 10pt; font-family: "Courier New";"> @tableName <span style="color: blue;">varchar</span><span style="color: gray;">(</span>50<span style="color: gray;">)<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">set</span><span style="font-size: 10pt; font-family: "Courier New";"> @tableName <span style="color: gray;">=</span> <span style="color: red;">'tbTest'<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New"; color: red;"><o:p> </o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">SELECT</span><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: red;">'private '</span> <span style="color: gray;">+</span> <span style="color: gray;">(<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: blue;">case</span> systypes<span style="color: gray;">.</span><span style="color: blue;">name<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: blue;">when</span> <span style="color: red;">'varchar'</span> <span style="color: blue;">then</span> <span style="color: red;">'string'<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: blue;">when</span> <span style="color: red;">'decimal'</span> <span style="color: blue;">then</span> <span style="color: red;">'decimal'<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: blue;">when</span> <span style="color: red;">'datetime'</span> <span style="color: blue;">then</span> <span style="color: red;">'DateTime'<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: blue;">when</span> <span style="color: red;">'int'</span> <span style="color: blue;">then</span> <span style="color: red;">'int'<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: blue;">else</span> systypes<span style="color: gray;">.</span><span style="color: blue;">name</span> <span style="color: blue;">end</span><span style="color: gray;">)</span> <span style="color: gray;">+</span> <span style="color: red;">' _'</span> <span style="color: gray;">+</span> <span style="color: fuchsia;">lower</span><span style="color: gray;">(</span><span style="color: fuchsia;">substring</span><span style="color: gray;">(</span>syscolumns<span style="color: gray;">.</span><span style="color: blue;">name</span><span style="color: gray;">,</span> 1<span style="color: gray;">,</span> 1<span style="color: gray;">))</span> <span style="color: gray;">+</span> <span style="color: gray;">right(</span>syscolumns<span style="color: gray;">.</span><span style="color: blue;">name</span><span style="color: gray;">,</span> <span style="color: fuchsia;">len</span><span style="color: gray;">(</span>syscolumns<span style="color: gray;">.</span><span style="color: blue;">name</span><span style="color: gray;">)</span> <span style="color: gray;">-</span>1<span style="color: gray;">)</span> <span style="color: gray;">+</span> <span style="color: red;">';'<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: blue;">FROM</span> syscolumns <span style="color: gray;">inner</span> <span style="color: gray;">join</span> systypes <span style="color: blue;">on</span> <o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> syscolumns<span style="color: gray;">.</span>xtype <span style="color: gray;">=</span> systypes<span style="color: gray;">.</span>xtype<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">where</span><span style="font-size: 10pt; font-family: "Courier New";"> id <span style="color: gray;">=</span> <span style="color: fuchsia;">Object_ID</span><span style="color: gray;">(</span>@tableName<span style="color: gray;">)<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">order</span><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: blue;">by</span> colorder<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"><o:p> </o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">SELECT</span><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: red;">'public '</span> <span style="color: gray;">+</span> <span style="color: gray;">(<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: blue;">case</span> systypes<span style="color: gray;">.</span><span style="color: blue;">name<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: blue;">when</span> <span style="color: red;">'varchar'</span> <span style="color: blue;">then</span> <span style="color: red;">'string'<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: blue;">when</span> <span style="color: red;">'decimal'</span> <span style="color: blue;">then</span> <span style="color: red;">'decimal'<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: blue;">when</span> <span style="color: red;">'datetime'</span> <span style="color: blue;">then</span> <span style="color: red;">'DateTime'<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: blue;">when</span> <span style="color: red;">'int'</span> <span style="color: blue;">then</span> <span style="color: red;">'int'<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: blue;">else</span> systypes<span style="color: gray;">.</span><span style="color: blue;">name</span> <span style="color: blue;">end</span><span style="color: gray;">)+</span> <span style="color: red;">' '</span> <span style="color: gray;">+</span> syscolumns<span style="color: gray;">.</span><span style="color: blue;">name</span> <span style="color: gray;">+</span> <span style="color: blue;">char</span><span style="color: gray;">(</span>10<span style="color: gray;">)</span> <span style="color: gray;">+</span> <o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: red;">'{'</span> <span style="color: gray;">+</span> <span style="color: blue;">char</span><span style="color: gray;">(</span>10<span style="color: gray;">)</span> <span style="color: gray;">+</span> <span style="color: red;">'get { return'</span> <span style="color: gray;">+</span> <o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: red;">' _'</span> <span style="color: gray;">+</span> <span style="color: fuchsia;">lower</span><span style="color: gray;">(</span><span style="color: fuchsia;">substring</span><span style="color: gray;">(</span>syscolumns<span style="color: gray;">.</span><span style="color: blue;">name</span><span style="color: gray;">,</span> 1<span style="color: gray;">,</span> 1<span style="color: gray;">))</span> <span style="color: gray;">+</span> <span style="color: gray;">right(</span>syscolumns<span style="color: gray;">.</span><span style="color: blue;">name</span><span style="color: gray;">,</span> <span style="color: fuchsia;">len</span><span style="color: gray;">(</span>syscolumns<span style="color: gray;">.</span><span style="color: blue;">name</span><span style="color: gray;">)</span> <span style="color: gray;">-</span>1<span style="color: gray;">)</span> <span style="color: gray;">+</span> <span style="color: red;">'; }'<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: gray;">+</span> <span style="color: blue;">char</span><span style="color: gray;">(</span>10<span style="color: gray;">)</span> <span style="color: gray;">+</span> <span style="color: red;">'set { _'</span> <span style="color: gray;">+</span> <span style="color: fuchsia;">lower</span><span style="color: gray;">(</span><span style="color: fuchsia;">substring</span><span style="color: gray;">(</span>syscolumns<span style="color: gray;">.</span><span style="color: blue;">name</span><span style="color: gray;">,</span> 1<span style="color: gray;">,</span> 1<span style="color: gray;">))</span> <span style="color: gray;">+</span> <span style="color: gray;">right(</span>syscolumns<span style="color: gray;">.</span><span style="color: blue;">name</span><span style="color: gray;">,</span> <span style="color: fuchsia;">len</span><span style="color: gray;">(</span>syscolumns<span style="color: gray;">.</span><span style="color: blue;">name</span><span style="color: gray;">)</span> <span style="color: gray;">-</span>1<span style="color: gray;">)</span> <span style="color: gray;">+</span> <span style="color: red;">' = value; }'</span> <span style="color: gray;">+</span> <span style="color: blue;">char</span><span style="color: gray;">(</span>10<span style="color: gray;">)</span> <span style="color: gray;">+</span> <span style="color: red;">'}'<o:p></o:p></span></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: blue;">FROM</span> syscolumns <span style="color: gray;">inner</span> <span style="color: gray;">join</span> systypes <span style="color: blue;">on</span> <o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New";"> syscolumns<span style="color: gray;">.</span>xtype <span style="color: gray;">=</span> systypes<span style="color: gray;">.</span>xtype<o:p></o:p></span></p> <p class="MsoNormal" style=""><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">where</span><span style="font-size: 10pt; font-family: "Courier New";"> id <span style="color: gray;">=</span> <span style="color: fuchsia;">Object_ID</span><span style="color: gray;">(</span>@tableName<span style="color: gray;">)<o:p></o:p></span></span></p> <p class="MsoNormal"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">order</span><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: blue;">by</span> colorder</span></p><p class="MsoNormal">
<br /></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">-----------------------------------------------------------------------------</span>
<br /><span style="font-size: 10pt; font-family: "Courier New";"><o:p></o:p></span></p> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-7926620989806469492009-06-18T14:12:00.003+05:302009-06-18T14:38:54.694+05:30SQL Server 2008 FeaturesWhat's New in Sql Server 2008<br /><br /><iframe allowfullscreen='allowfullscreen' webkitallowfullscreen='webkitallowfullscreen' mozallowfullscreen='mozallowfullscreen' width='320' height='266' src='https://www.blogger.com/video.g?token=AD6v5dwYACe-lgrxDK8qYLd5tSXNJ7aXa1EqJwer48E8UgXZX7cYf8Z6NSLyFgQh3iA__wpZcc-AkG0r8qg' class='b-hbp-video b-uploaded' frameborder='0'></iframe>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-46668422632391130462009-03-14T15:21:00.003+05:302009-03-14T15:58:35.839+05:30Power of Reflection EmitSome time ago I came across a situation where the end user of my application was willing to add new types at his own. Obviously I was not having any other solution rather using Reflection Emit.<br /><br />It was great creating new types, dynamic methods at run time.<br /><br />So as I did earlier similarly I will produce some code (to create new type (compiled class) with some properties and methods) out here with a little description.<br /><br /><span style="font-size:78%;"><span style="font-style: italic;">But before working with Emit you should look on the MSIL Disassembler to know how the things looks alike after compilation and before JIT compiler processing.</span></span><br /><br /><span style="font-style: italic;">------------------------------ Creating A Whole New Type</span> ------------------------------------<br /><br />using System;<br />using System.Collections.Generic;<br />using System.Text;<br />using System.Reflection;<br />using System.Reflection.Emit;<br />using DataFramework;<br />using System.Data;<br /><br />namespace Generator<br />{<br /> public class ClassGenerator<br /> {<br /> public ClassGenerator()<br /> {<br /><br /> }<br /><br /> public void GenerateClass(string assemblyName, string className, List<fieldstructure> fieldWithType)<br /> {<br /> AssemblyName an = new AssemblyName(assemblyName);<br /> AppDomain ad = AppDomain.CurrentDomain; // Use same app domain otherwise to use<br /> // the generated classes you need to use<br /> // remoting like - object handle unwrap<br /> AssemblyBuilder ab = ad.DefineDynamicAssembly(an, AssemblyBuilderAccess.RunAndSave, AppDomain.CurrentDomain.BaseDirectory);<br /><br /> ModuleBuilder mb = ab.DefineDynamicModule(an.Name, "CustomClasses.dll");<br /><br /> TypeBuilder tb = mb.DefineType(className, TypeAttributes.Class | TypeAttributes.Public);<br /><br /> ConstructorInfo ci = tb.DefineDefaultConstructor(MethodAttributes.Public);<br /><br /> foreach (FieldStructure fieldName in fieldWithType)<br /> {<br /> Type type = GetType(fieldName.type);// Type.GetType(fieldWithType[fieldName], false, true);<br /><br /> FieldBuilder fb = tb.DefineField(fieldName.name, type, FieldAttributes.Private);<br /><br /> CreateProperty(tb, type, fb, fieldName.name);<br /> }<br /><br /><br /><br /> Type generatedType = tb.CreateType();<br /> ab.Save("CustomClasses." + className + ".dll");<br /> }<br /><br /> #region Create Property for field<br /> private void CreateProperty(TypeBuilder tb, Type fieldType, FieldBuilder fb, string key)<br /> {<br /> PropertyBuilder pb = tb.DefineProperty(SystemConstants.GetPropertyName(key), System.Reflection.PropertyAttributes.HasDefault, fieldType, Type.EmptyTypes);<br /><br /> MethodAttributes getSetAttr = MethodAttributes.Public | MethodAttributes.SpecialName | MethodAttributes.HideBySig;<br /><br /> MethodBuilder mbGet = tb.DefineMethod(SystemConstants.getPrefix + key, getSetAttr, fieldType, Type.EmptyTypes);<br /><br /> ILGenerator getIL = mbGet.GetILGenerator();<br /> // For an instance property, argument zero is the instance. Load the<br /> // instance, then load the private field and return, leaving the<br /> // field value on the stack.<br /> getIL.Emit(OpCodes.Ldarg_0);<br /> getIL.Emit(OpCodes.Ldfld, fb);<br /> getIL.Emit(OpCodes.Ret);<br /><br /> MethodBuilder mbSet = tb.DefineMethod(SystemConstants.setPrefix + key, getSetAttr, null, new Type[] { fieldType });<br /><br /> ILGenerator setIL = mbSet.GetILGenerator();<br /> // Load the instance and then the numeric argument, then store the<br /> // argument in the field.<br /> setIL.Emit(OpCodes.Ldarg_0);<br /> setIL.Emit(OpCodes.Ldarg_1);<br /> setIL.Emit(OpCodes.Stfld, fb);<br /> setIL.Emit(OpCodes.Ret);<br /><br /> // Last, map the "get" and "set" accessor methods to the<br /> // PropertyBuilder. The property is now complete.<br /> pb.SetGetMethod(mbGet);<br /> pb.SetSetMethod(mbSet);<br /> }<br /> #endregion<br /><br /> #region Get type based on string representation<br /> private Type GetType(string typeName)<br /> {<br /> switch (typeName.ToLower())<br /> {<br /> case "string":<br /> return typeof(String);<br /> case "int32":<br /> return typeof(Int32);<br /> case "long":<br /> return typeof(long);<br /> case "float":<br /> return typeof(float);<br /> case "decimal":<br /> return typeof(decimal);<br /> default:<br /> return typeof(object);<br /> }<br /> }<br /> #endregion<br /> }<br />}<br /><br /><br /><br />----------------------- Helper Classes (SystemConstants)-----------------------------------<br />using System;<br />using System.Collections.Generic;<br />using System.Text;<br /><br />namespace Generator<br />{<br /> public class SystemConstants<br /> {<br /> public const string getPrefix = "get_";<br /> public const string setPrefix = "set_";<br /> public const string variablePrefix = "m_";<br /> public const string idVariableForClasses = "ID";<br /> public const string idVariableType = "int32";<br /><br /> private static bool IsFieldDicContainsId(Dictionary<string,> fieldWithType)<br /> {<br /> foreach (string fieldName in fieldWithType.Keys)<br /> {<br /> if (fieldName.ToUpper() == idVariableForClasses)<br /> {<br /> return true;<br /> }<br /> }<br /> return false;<br /> }<br /><br /> public static Dictionary<string,> GetFinalDictionary(Dictionary<string,> fieldWithType)<br /> {<br /> if (IsFieldDicContainsId(fieldWithType))<br /> {<br /> if (fieldWithType.ContainsKey(idVariableForClasses))<br /> {<br /> fieldWithType.Remove(idVariableForClasses);<br /> }<br /> }<br /><br /> return fieldWithType;<br /> }<br /><br /> internal static string GetPropertyName(string key)<br /> {<br /> // Implement Logic to create property like m_name ==> Name right now its NAME<br /> return key.ToUpper();<br /> }<br /> }<br />}<br /><br />----------------------- Helper Structure (FieldStructure)-----------------------------------<br /><br />using System;<br />using System.Collections.Generic;<br />using System.Text;<br /><br />namespace Generator<br />{<br /> public struct FieldStructure<br /> {<br /> public string name;<br /> public string type;<br /> public bool isIdentity;<br /> public bool isReference;<br /> public string referenceClassName;<br /> public string referenceColumnName;<br /><br /> }<br />}<br /><br /><br /><br />--------------------------------- Code to be called from UI ------------------------------------<br /><br />ClassGenerator cg = new ClassGenerator();<br /><br /> FieldStructure fStructA = new FieldStructure();<br /> fStructA.name = "name";<br /> fStructA.type = "string";<br /> fStructA.isIdentity = false;<br /><br /> FieldStructure fStructB = new FieldStructure();<br /> fStructB.name = "id";<br /> fStructB.type = "int32";<br /> fStructB.isIdentity = true;<br /><br /> List<fieldstructure> allFields = new List<fieldstructure>();<br /> allFields.Add(fStructA);<br /> allFields.Add(fStructB);<br /><br /> cg.GenerateClass("test", "Test", allFields);<br /> }<br /><br /><br />Thats it. Try to use it, a .dll file will be saved in your application root directory, but beware if you are using web application and you intended to save any .dll file in the bin folder the application domain will reload and all your sessions will be lost as one of the application domain reloading is any change in the bin directory is.<br /><br />For more reading you can look at <a href="http://msdn.microsoft.com/en-us/library/3y322t50.aspx">this msdn link</a>.<br /><br />Let me know for your queries.<br />Shashank.... enjoy coding ....Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-38870903.post-47614843591000830662008-05-06T13:05:00.000+05:302008-05-06T13:06:17.073+05:30Microsoft Product Code Names<p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Know Microsoft Product Code Names:<o:p></o:p></span></span></p> <p class="MsoNormal" style="margin-left: 0.5in;"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p> </o:p></span></span></p> <p class="MsoNormal" style="margin-left: 0.5in;"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p> </o:p></span></span></p> <h1 style="margin-left: 0.5in;"><b><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Current <span style="display: none;"><span id="id4305">'''ProductCodeNames''' - Various Microsoft product codenames from over the years.<o:p></o:p></span></span></span></span></b></h1> <h1 style="margin-left: 0.5in;"><b><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">11/12/2007 4:33:10 AM - Zeus<o:p></o:p></span></span></b></h1> <h1 style="margin-left: 0.5in;"><b><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/default.aspx/Channel9.CodeNames" href="http://channel9.msdn.com/wiki/default.aspx/Channel9.CodeNames">CodeNames</a><o:p></o:p></span></span></b></h1> <table class="MsoNormalTable" style="margin-left: 0.5in;" border="0" cellpadding="0" cellspacing="1"> <tbody> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Avalon<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows Presentation Foundation, WPF is the presentation subsystem class libraries in <span class="defaulttopictiptext"><span style="display: none;"><span id="id4306">Click to read this topic</span></span><span style="display: none;"><o:p></o:p></span></span></span></span></p> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">5/8/2005 7:52:01 PM - <o:p></o:p></span></span></p> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/default.aspx/Channel9.WinFX" href="http://channel9.msdn.com/wiki/default.aspx/Channel9.WinFX">WinFX</a>.<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Aero<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">UI in Windows <st1:place st="on">Vista</st1:place><o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Aruba</span></span></st1:place><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows Media Platform for Blackcomb<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Ajax</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">New Set of asynchonous technologies for web applications enabling richer user experiences<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Blackcomb<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Successor to <st1:place st="on">Vista</st1:place><o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Cairo</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Base collection of technologies which largely evolved into the core technologies in 1.Vista.<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Cider<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">VS Designer for Windows Presentation Foundation<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Longhorn<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows <st1:place st="on">Vista</st1:place><o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Monad<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Longorn Command Shell. Msh is the new<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Vienna</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Office Live Communication Server 2005<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Whidbey<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Visual Studio .NET 2005<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Orcas<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Visual Studio 2008<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:state st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Hawaii</span></span></st1:place></st1:State><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Future version of Visual Studio (after the Orcas release).<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Whitehorse</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">VS.NET 2005 Design Tool Suite<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"><span id="id4307"> <p class="MsoNormal"><span class="defaulttopictiptext"><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">Click to read this topic</span></span></span><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">5/8/2005 7:52:01 PM - <o:p></o:p></span></span></p></span> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/default.aspx/Channel9.WinFx" href="http://channel9.msdn.com/wiki/default.aspx/Channel9.WinFx">WinFx</a><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">The set of next-generation managed <a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.APIs&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.APIs&return=Channel9.CodeNames">APIs</a> provided by Microsoft<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:state st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Yukon</span></span></st1:place></st1:State><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">SQL Server 2005 scripting and automation environment for Windows<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Acrylic<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Microsoft Expression Graphic Designer. A new professional graphics software.<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Sparkle<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Microsoft Expression Interactive Designer.<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Quartz<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Microsoft Expression Web Designer.<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"><span id="id4308"> <p class="MsoNormal"><span class="defaulttopictiptext"><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">Click to read this topic</span></span></span><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">12/19/2006 5:17:49 AM - <o:p></o:p></span></span></p></span> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/default.aspx/Channel9.WinFS" href="http://channel9.msdn.com/wiki/default.aspx/Channel9.WinFS">WinFS</a><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Next-generation Unified Storage Sub-system for Windows.<o:p></o:p></span></span></p></td></tr></tbody></table> <p style="margin-left: 0.5in;"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"> <o:p></o:p></span></span></p> <h1 style="margin-left: 0.5in;"><b><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Operating System Components / Versions<o:p></o:p></span></span></b></h1> <table class="MsoNormalTable" style="margin-left: 0.5in;" border="0" cellpadding="0" cellspacing="1"> <tbody> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Avalon<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows Presentation Foundation, WPF is the presentation subsystem class libraries in <span class="defaulttopictiptext"><span style="display: none;"><span id="id4309">Click to read this topic</span></span><span style="display: none;"><o:p></o:p></span></span></span></span></p> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">5/8/2005 7:52:01 PM - <o:p></o:p></span></span></p> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/default.aspx/Channel9.WinFX" href="http://channel9.msdn.com/wiki/default.aspx/Channel9.WinFX">WinFX</a>.<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Asteroid<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows 2000 <a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.SP1&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.SP1&return=Channel9.CodeNames">SP1</a><o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Aero<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">UI in Windows <st1:place st="on">Vista</st1:place><o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Bearpaw<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows Terminal Services for Windows Server 2003<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Blackcomb<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Is the server version of <st1:place st="on">Vista</st1:place><o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Bobcat<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows Server 2003 Small Business Edition<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Cairo</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Base collection of technologies which largely evolved into the core technologies in <st1:place st="on">Vista</st1:place>.<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Chicago</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows 95<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Daytona<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows NT 3.5<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Detroit</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows 95 OSR 2<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Freestyle<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows XP <st1:place st="on"><st1:placename st="on">Media</st1:PlaceName> <st1:placetype st="on">Center</st1:PlaceType></st1:place> Edition<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Frosting<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows 95 Plus!<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Harmony<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows XP <st1:place st="on"><st1:placename st="on">Media</st1:PlaceName> <st1:placetype st="on">Center</st1:PlaceType></st1:place> Edition 2004<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Impala<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows <a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.NT4&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.NT4&return=Channel9.CodeNames">NT4</a> Embedded<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Indigo<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Communications services used in <st1:place st="on">Vista</st1:place>, also called WCF(Windows Communication Foundation)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Janus<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows 3.1<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Lonestar<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows XP Tablet PC Edition 2005<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Longhorn<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows <st1:place st="on">Vista</st1:place><o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Mantis<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows XP Embedded 5.1<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Memphis</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows 98<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Mesquite</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Batch Management tools for Windows NT/Windows 2000 Server<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Millenium/Georgia<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows ME<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Mir<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Internal Mercury release<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">NAS 3.0<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows Storage Server 2003<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Nashville</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Internet Explorer 4, for Windows 95<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Neptune</span></span></st1:place><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Cancelled successor to Windows 98<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Newshell<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Alpha shell update for Windows NT 3.x<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Panther<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Abandoned <st1:placetype st="on">port</st1:PlaceType> of <st1:placename st="on">Windows NT</st1:PlaceName>, replaced by <st1:city st="on"><st1:place st="on">Chicago</st1:place></st1:City><o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Slalom<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:placename st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows</span></span></st1:PlaceName><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"> <st1:placename st="on">Media</st1:PlaceName> <st1:placetype st="on">Center</st1:PlaceType> for <st1:place st="on">Vista</st1:place><o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Sparta</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows for Workgroups 3.1<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Springboard<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Backporting of Vista technologies to Windows XP <span style="display: none;"><span id="id4310">Service Pack 2<o:p></o:p></span></span></span></span></p> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">6/29/2005 6:01:27 PM - RaiN<o:p></o:p></span></span></p> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/default.aspx/Channel9.SP2" href="http://channel9.msdn.com/wiki/default.aspx/Channel9.SP2">SP2</a><o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Snowball<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows for Workgroups 3.11<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Sundown<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows XP 64-bit<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">SUR<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Patch to Windows 3.51<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Symphony<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows XP <st1:place st="on"><st1:placename st="on">Media</st1:PlaceName> <st1:placetype st="on">Center</st1:PlaceType></st1:place> Edition 2005<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Whistler<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows XP<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows 1.0<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows 286<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows 2.0<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"><span id="id4311"> <p class="MsoNormal"><span class="defaulttopictiptext"><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">Click to read this topic</span></span></span><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">5/8/2005 7:52:01 PM - <o:p></o:p></span></span></p></span> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/default.aspx/Channel9.WinFx" href="http://channel9.msdn.com/wiki/default.aspx/Channel9.WinFx">WinFx</a><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">The set of next-generation managed <a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.APIs&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.APIs&return=Channel9.CodeNames">APIs</a> provided by Microsoft<o:p></o:p></span></span></p></td></tr></tbody></table> <p style="margin-left: 0.5in;"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"> <o:p></o:p></span></span></p> <h1 style="margin-left: 0.5in;"><b><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Server Products<o:p></o:p></span></span></b></h1> <h2 style="margin-left: 0.5in;"><b><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">SQL<o:p></o:p></span></span></b></h2> <table class="MsoNormalTable" style="margin-left: 0.5in;" border="0" cellpadding="0" cellspacing="1"> <tbody> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Starfighter<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">SQL Server 6.0<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Hydra<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">SQL Server 6.5<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Sphinx<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">SQL Server 7.0<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Plato<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">SQL Server 7.0 OLAP Services<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Shiloh</span></span></st1:place><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">SQL Server 2000<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Liberty</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">SQL Server 2000 64-bit Edition<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Rosetta<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">SQL Server 2000 Reporting Services<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Aurum<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">SQL Server 2000, data mining toolkit<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:state st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Yukon</span></span></st1:place></st1:State><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">SQL Server 2005<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Katmai/Acadia<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">SQL Server 2008<o:p></o:p></span></span></p></td></tr></tbody></table> <p style="margin-left: 0.5in;"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"> <o:p></o:p></span></span></p> <h2 style="margin-left: 0.5in;"><b><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Exchange<o:p></o:p></span></span></b></h2> <table class="MsoNormalTable" style="margin-left: 0.5in;" border="0" cellpadding="0" cellspacing="1"> <tbody> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Osmium<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Exchange Server 5.5<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Platinum<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Exchange Server 2002<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Titanium<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Exchange Server 2003<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Kodiak<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Abandoned successor to Exchange 2003.<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Magma<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Embedded Exchange<o:p></o:p></span></span></p></td></tr></tbody></table> <p style="margin-left: 0.5in;"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"> <o:p></o:p></span></span></p> <h2 style="margin-left: 0.5in;"><span id="id4312"><b><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">SharePoint Portal Server 2003 links<o:p></o:p></span></span></b></span></h2> <h2 style="margin-left: 0.5in;"><b><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">9/14/2004 12:10:55 AM - roberdan<o:p></o:p></span></span></b></h2> <h2 style="margin-left: 0.5in;"><b><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/default.aspx/Channel9.SharePoint" href="http://channel9.msdn.com/wiki/default.aspx/Channel9.SharePoint">SharePoint</a><o:p></o:p></span></span></b></h2> <table class="MsoNormalTable" style="margin-left: 0.5in;" border="0" cellpadding="0" cellspacing="1"> <tbody> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Tahoe<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Sharepoint Server 2001<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Matrix<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Sharepoint Portal Server v2<o:p></o:p></span></span></p></td></tr></tbody></table> <p style="margin-left: 0.5in;"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"> <o:p></o:p></span></span></p> <h2 style="margin-left: 0.5in;"><span id="id4313"><b><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">add a one or paragraph summary or description of what's discussed here; put yours after 'Summary:'<o:p></o:p></span></span></b></span></h2> <h2 style="margin-left: 0.5in;"><b><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">9/2/2004 3:33:27 PM - kevinh<o:p></o:p></span></span></b></h2> <h2 style="margin-left: 0.5in;"><b><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/default.aspx/Channel9.BizTalk" href="http://channel9.msdn.com/wiki/default.aspx/Channel9.BizTalk">BizTalk</a><o:p></o:p></span></span></b></h2> <table class="MsoNormalTable" style="margin-left: 0.5in;" border="0" cellpadding="0" cellspacing="1"> <tbody> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Latinum<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"><span id="id4314"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">add a one or paragraph summary or description of what's discussed here; put yours after 'Summary:'<o:p></o:p></span></span></p> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">9/2/2004 3:33:27 PM - kevinh<o:p></o:p></span></span></p></span> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/default.aspx/Channel9.BizTalk" href="http://channel9.msdn.com/wiki/default.aspx/Channel9.BizTalk">BizTalk</a> 2000<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Bizet<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"><span id="id4315"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">add a one or paragraph summary or description of what's discussed here; put yours after 'Summary:'<o:p></o:p></span></span></p> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">9/2/2004 3:33:27 PM - kevinh<o:p></o:p></span></span></p></span> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/default.aspx/Channel9.BizTalk" href="http://channel9.msdn.com/wiki/default.aspx/Channel9.BizTalk">BizTalk</a> 2002<o:p></o:p></span></span></p></td></tr></tbody></table> <p style="margin-left: 0.5in;"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"> <o:p></o:p></span></span></p> <h2 style="margin-left: 0.5in;"><b><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Misc<o:p></o:p></span></span></b></h2> <table class="MsoNormalTable" style="margin-left: 0.5in;" border="0" cellpadding="0" cellspacing="1"> <tbody> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Falcon<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Message Queue Server (MSMQ)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Viper<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Transaction Server 2.0<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Hydra<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows NT Terminal Services<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Babylon</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Host Integration Server<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Cedar<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">COM Transaction Integrator for CICS and IMS (COMTI)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Wolfpack<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Cluster Server<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Vienna</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Office Live Communication Server 2005<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Hermes<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">System Management Server<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Kahiltna<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Commerce Server 2.0<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Comet<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">ISA 2000<o:p></o:p></span></span></p></td></tr></tbody></table> <p style="margin-left: 0.5in;"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"> <o:p></o:p></span></span></p> <h1 style="margin-left: 0.5in;"><b><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Mobile PC<o:p></o:p></span></span></b></h1> <table class="MsoNormalTable" style="margin-left: 0.5in;" border="0" cellpadding="0" cellspacing="1"> <tbody> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Lonestar<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows XP Tablet PC Edition 2005<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Haiku<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Post-2007 mobile PC hardware design<o:p></o:p></span></span></p></td></tr></tbody></table> <p style="margin-left: 0.5in;"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"> <o:p></o:p></span></span></p> <h1 style="margin-left: 0.5in;"><b><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Mobile Platforms<o:p></o:p></span></span></b></h1> <table class="MsoNormalTable" style="margin-left: 0.5in;" border="0" cellpadding="0" cellspacing="1"> <tbody> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Alder<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE 2.1<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Apolllo<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE for Auto PC<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Axe<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Embedded Toolkit for Windows CE 2.0 and 2.1<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Brich<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE 2.11 and 2.12<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Cedar<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE 3.0<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Chainsaw<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE Platform Builder 3.0<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Galileo<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE for Handheld PC 2000<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Goldeneye<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE for <a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.AutoPC&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.AutoPC&return=Channel9.CodeNames">AutoPC</a><o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Gryphon<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE 2.0 for palm-sized <a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.PCs&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.PCs&return=Channel9.CodeNames">PCs</a><o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Hai Ku<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Multimedia Extension for Windows<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Hermes<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE for webphones<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Jameson<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE.NET Update<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Jupiter<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE for Handheld PC Pro 3.0 (or Macallan Windows CE.NET Corporate Edition??)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Laguna<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Upcoming version of SQL Server, for Windows CE<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.McKendrick&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.McKendrick&return=Channel9.CodeNames">McKendrick</a><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE for <a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.Media2G0&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.Media2G0&return=Channel9.CodeNames">Media2G0</a><o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Mercury<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE for Hanheld PC<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Merlin<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Pocket PC 2002 (or Windows CE 2002??)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Mira<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE for Smart Display Devices<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Orion<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE for Chinese Handheld PC<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Ozone<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Pocket PC 2003<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Pegasus<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE 1.0<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Rapier<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE for <span style="display: none;"><span id="id4316">add a one or paragraph summary or description of what's discussed here; put yours after 'Summary:'<o:p></o:p></span></span></span></span></p> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">2/11/2007 4:22:22 AM - abhishek85gupta<o:p></o:p></span></span></p> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/default.aspx/Channel9.PocketPC" href="http://channel9.msdn.com/wiki/default.aspx/Channel9.PocketPC">PocketPC</a> 2000<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Stinger<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Smartphone 2002 (or Windows CE for Smartphones 1.0??)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Starlite<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">.NET Compact Framework 1.0<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Talisker<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE .NET<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Tazz<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Microsoft Phone<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Visine<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Novell Netware Migration Tool<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Venus<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE for webTV<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Wyvern<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows CE for Color Palm PC<o:p></o:p></span></span></p></td></tr></tbody></table> <p style="margin-left: 0.5in;"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"> <o:p></o:p></span></span></p> <h1 style="margin-left: 0.5in;"><b><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Miscellaneous<o:p></o:p></span></span></b></h1> <table class="MsoNormalTable" style="margin-left: 0.5in; width: 10.25in;" border="0" cellpadding="0" cellspacing="1" width="984"> <tbody> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Trident<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Dynamic HTML<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Springboard<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Microsoft's security excellence and review project, who's fruits were deployed via Office 2003 <a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.SP1&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.SP1&return=Channel9.CodeNames">SP1</a>, Windows XP <a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.SP1&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.SP1&return=Channel9.CodeNames">SP1</a> and Windows Server 2003 <a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.SP1&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.SP1&return=Channel9.CodeNames">SP1</a><o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Palladium<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">An on-again off-again secure runtime environment called Next Generation Secure Computing Base (NGSCB<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.AirStream&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.AirStream&return=Channel9.CodeNames">AirStream</a><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Services for wireless connections to Exchange<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Avalanche<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Internet-Information-Services 5.0<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Argo<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Query-Services for SQL-Server 2000<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Aruba</span></span></st1:place><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows Media Platform for Blackcomb<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Athena<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Outlook Express<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Athens</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">New prototype PC design (with HP)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Blackbird<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">MSN SDK<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Blizzard<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Business oriented Set of Services in .NET My Services<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Basecamp<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">VPN dial-up networking update (PPTP) for win95<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Calais</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Smart-Card Technologies<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Cascade<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows Active-Directory<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Cayman<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.NetMeeting&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.NetMeeting&return=Channel9.CodeNames">NetMeeting</a> 3.0 Version 3.01 4.4.3400<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Chrome<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.ChromeEffects&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.ChromeEffects&return=Channel9.CodeNames">ChromeEffects</a> (GUI-Feature)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Cirrus<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Access 1.0<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Comet<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Network-Tools for Windows 2000<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Corona</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows Media-Technologies 9.0<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Coyote<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Distributed Views for SQL-Server 2000<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Darwin</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows Installer 1.1 Version 1.1<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Dart<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Setup for Oracle, SQL-Server ODBC-driver<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.DaVinci&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.DaVinci&return=Channel9.CodeNames">DaVinci</a><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Database-Design & Query-Tools<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Denali</span></span></st1:place><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Active Server Pages<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Europa<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">New GUI for the MSN-Community<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Fahrenheit<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">A defunct collaboration between Microsoft & SGI Graphics to combine <a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.Direct3D&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.Direct3D&return=Channel9.CodeNames">Direct3D</a> and <a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.OpenGL&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.OpenGL&return=Channel9.CodeNames">OpenGL</a> by creating a unified 3D API. <o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Falcon<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows Messaging Queuing Server<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Fusion<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Technologies for DLL improvements<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Gemini<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Succesor GUI "Europa" for MSN-Community<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Gibraltar</span></span></st1:place><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Internet-Information-Server 1.0 Version 3.0<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Grizzly<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Workflow-Designer for SQL-Server 2000<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Hailstorm<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">XML Message Interface<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Hailstorm<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">.NET My Services<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.HardeningPack&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.HardeningPack&return=Channel9.CodeNames">HardeningPack</a><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Internet Explorer Enhanced Security (Windows Server 2003)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Hydra<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows NT Terminal Services<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:state st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Idaho</span></span></st1:place></st1:State><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Preliminary/alpha version of the next Windows-Longhorn<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Jakarta</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">JAVA-Engine for Internet Explorer 3.0<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Kagera (Kajera??)<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">OLE-DB Provider for ODBC-Data<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Kahuna<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows Live Mail<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">K2</span></span></st1:place><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Internet-Information-Server 4.0<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Lightning<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">.NET Common Language Runtime (CLR)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Luna<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Theme technology for Windows XP<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:city st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Luxor</span></span></st1:place></st1:City><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">OLE-Provider-Services for <st1:state st="on"><st1:place st="on">Yukon</st1:place></st1:State><o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Magic Carpet<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Passport-Technologien<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Marvel<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Microsoft Network (MSN)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Merlin<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Microsoft® Internet Explorer for Dreamcast (cancelled circa 1999).<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Mercury<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">DUN 1.2 update for Win95<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Monad<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Longorn Command Shell. Msh is the new scripting and automation environment for Windows<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">NGWS<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">(Next Generation Windows/Web Services) .Net<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:state st="on"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Normandy</span></span></st1:place></st1:State><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Microsoft Commercial Internet System (MCIS)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Oprah<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Netmeeting<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Nile</span></span></st1:place><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">OLE-DB<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">O'hare<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Internet Explorer 1.00.<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Plato<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">OLAP-Server<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Project 42<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">(from Lightning) .NET Common Language Runtime (CLR)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Ren<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Outlook<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Quartz<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Direct Show<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Sideshow<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Task Shelf of Longhorn (MS research)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Slate<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Microsoft Management-Console (MMC)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Spark<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Integration of Windows <span style="display: none;"><span id="id4317">SharePoint Portal Server 2003 links<o:p></o:p></span></span></span></span></p> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="display: none; font-size: 8pt; font-family: Verdana;">9/14/2004 12:10:55 AM - roberdan<o:p></o:p></span></span></p> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/default.aspx/Channel9.SharePoint" href="http://channel9.msdn.com/wiki/default.aspx/Channel9.SharePoint">SharePoint</a> Services and CMS<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Steelhead<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Windows NT Routing & Remote-Access Services (RAS)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><st1:place st="on"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Tahiti</span></span></st1:place><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;"><a title="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.SharedView&return=Channel9.CodeNames Click here to create this topic" href="http://channel9.msdn.com/wiki/wikiedit.aspx?topic=Channel9.SharedView&return=Channel9.CodeNames">SharedView</a> Beta2<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Talisman<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">3D Graphic- und Multimedia Architecture<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Tensor<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">OLE-DB Extensions for OLAP<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Touchdown<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Outlook 97 (Also mentioned:Public folders for MS Exchange)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Trident<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Dynamic HTML (DHTML)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Tungsten<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Microsoft Rights Management Services (RMS)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Whisper<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Speech Recognition (speech-to-text)<o:p></o:p></span></span></p></td></tr> <tr> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Xenon<o:p></o:p></span></span></p></td> <td style="padding: 1.5pt;"> <p class="MsoNormal"><span style="font-family:Verdana;font-size:78%;"><span style="font-size: 8pt; font-family: Verdana;">Xbox 360<o:p></o:p></span></span></p></td></tr></tbody></table>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-38870903.post-57755181727194663442008-05-06T12:34:00.001+05:302008-05-06T12:48:12.006+05:30Read Write and Search XML Document in ASP.NET<span style="font-size:85%;"><span style="font-family:verdana;">You often need to read, write or search some phrase in an XML document and you can use XmlDocument or any class among a lot present in .NET framework but what<br />if you wish to bind your business objects </span></span><span style="font-size:85%;"><span style="font-family:verdana;">the list of business objects to the XmlDocument.<br /><br /></span></span><span style="font-size:85%;"><span style="font-family:verdana;">You can use the code below to do this.</span></span><br /><span style="font-size:85%;"><span style="font-family:verdana;"><br />What you need to do for this is to keep the name of properties of your business objects same as the name of attributes are present in the XML file you wanna load.<br /><br />This class make use of XmlReader and XmlWriter base classes provided by .NET framework.<br /><br />using System;<br />using System.Data;<br />using System.Configuration;<br />using System.Web;<br />using System.Web.Security;<br />using System.Web.UI;<br />using System.Web.UI.WebControls;<br />using System.Web.UI.WebControls.WebParts;<br />using System.Web.UI.HtmlControls;<br />using System.Collections.Generic;<br />using System.Xml;<br />using System.Reflection;<br />using System.IO;<br /><br />/// <summary><br />/// XMLDataHelper provides way to access nodes and bind them directly to custom objects.<br />/// Also Save XMLFragment at the end of the Xml File<br />/// </summary><br />public class XMLDataHelper : IDisposable<br />{<br /> #region Variables<br /><br /> private static string _baseDirectory = AppDomain.CurrentDomain.BaseDirectory;<br /> private static string _documentDirectory = _baseDirectory + "App_Data/";<br /><br /> protected string _query;<br /> protected XmlReader xmlReader;<br /> protected XmlWriter xmlWriter;<br /> #endregion<br /><br /> #region constructors<br /> public XMLDataHelper()<br /> {<br /> string xmlFile = ConfigurationManager.AppSettings["XmlFileName"].ToString();<br /> xmlReader = XmlReader.Create(xmlFile);<br /> }<br /><br /> public XMLDataHelper(string xmlFile)<br /> {<br /> xmlReader = XmlReader.Create(xmlFile);<br /> }<br /> public XMLDataHelper(string xmlFile, string xmlFileForWriter)<br /> {<br /> xmlReader = XmlReader.Create(xmlFile);<br /> xmlWriter = XmlWriter.Create(xmlFileForWriter);<br /><br /> }<br /> #endregion<br /><br /> #region Load Object<br /> public T LoadObject<t>(string nodeName, Dictionary<string,> attrFieldsLookUp) where T : new()<br /> {<br /> T obj = new T();<br /> if (string.IsNullOrEmpty(nodeName))<br /> {<br /> throw new Exception("Node not specified.");<br /> }<br /> bool IsRequestedItem = true;<br /> PropertyInfo[] objPropInfo = obj.GetType().GetProperties();<br /> while (xmlReader.ReadToFollowing(nodeName))<br /> {<br /> if (xmlReader.NodeType == XmlNodeType.Element && xmlReader.NodeType != XmlNodeType.Document)<br /> {<br /> XmlReader nodeXmlReader = xmlReader.ReadSubtree();<br /> while (nodeXmlReader.Read())<br /> {<br /> IsRequestedItem = false;<br /> foreach (string key in attrFieldsLookUp.Keys)<br /> {<br /> if (attrFieldsLookUp[key.ToUpper()] == nodeXmlReader.GetAttribute(key))<br /> {<br /> IsRequestedItem = true;<br /> }<br /> else<br /> {<br /> IsRequestedItem = false;<br /> break;<br /> }<br /> }<br /> if (IsRequestedItem)<br /> {<br /> GetObjectFromReaderNode<t>(ref obj, ref nodeXmlReader, ref objPropInfo, true, nodeName);<br /> }<br /> }<br /> }<br /> }<br /> if (xmlReader.ReadState != ReadState.Closed)<br /> {<br /> xmlReader.Close();<br /> }<br /> return obj;<br /> }<br /> #endregion<br /><br /> #region GetObjectFromReaderNode<br /> private void GetObjectFromReaderNode<t>(ref T obj, ref XmlReader nodeXmlReader, ref PropertyInfo[] objPropInfo, bool AreElementsReq, string nodeName)<br /> {<br /> Dictionary<string,> xmlFileValues = new Dictionary<string,>();<br /> while (nodeXmlReader.MoveToNextAttribute())<br /> {<br /> xmlFileValues.Add(nodeXmlReader.Name.ToUpper(), nodeXmlReader.Value);<br /> }<br /> foreach (PropertyInfo pi in objPropInfo)<br /> {<br /> if (pi.Name == "DEPTH")<br /> {<br /> pi.SetValue(obj, (object)(nodeXmlReader.Depth + 1), null);<br /> }<br /> else<br /> {<br /> string currAttrVal;<br /> if (xmlFileValues.TryGetValue(pi.Name.ToUpper(), out currAttrVal))<br /> {<br /> if (pi.PropertyType == typeof(Boolean))<br /> {<br /> pi.SetValue(obj, Convert.ToBoolean(currAttrVal.ToLower()), null);<br /> }<br /> else<br /> {<br /> pi.SetValue(obj, (object)currAttrVal, null);<br /> }<br /> }<br /> }<br /> }<br /> if (AreElementsReq)<br /> {<br /> bool firstOccur = true;<br /> while (xmlReader.Read() && firstOccur)<br /> {<br /> if (xmlReader.NodeType == XmlNodeType.Element && xmlReader.NodeType != XmlNodeType.Document)<br /> {<br /> string elementName = nodeXmlReader.Name;<br /> // To Stop Retrieving Inner Elements value<br /> if (elementName == nodeName)<br /> {<br /> firstOccur = false;<br /> }<br /> string currElementVal;<br /> foreach (PropertyInfo pi in objPropInfo)<br /> {<br /> if (pi.Name.ToUpper() == elementName.ToUpper())<br /> {<br /> pi.SetValue(obj, (object)nodeXmlReader.ReadElementString(), null);<br /> }<br /> }<br /> }<br /> }<br /> }<br /> }<br /> #endregion<br /><br /> #region LoadList<br /> public List<t> LoadList<t>(string nodeName, bool includeElement) where T : new()<br /> {<br /> T obj = new T();<br /> List<t> retList = new List<t>();<br /> if (string.IsNullOrEmpty(nodeName))<br /> {<br /> throw new Exception("Node not specified.");<br /> }<br /> bool IsRequestedItem = true;<br /> PropertyInfo[] objPropInfo = obj.GetType().GetProperties();<br /> while (xmlReader.Read())<br /> {<br /> if (xmlReader.NodeType == XmlNodeType.Element && xmlReader.NodeType != XmlNodeType.Document)<br /> {<br /> if (xmlReader.Name == nodeName)<br /> {<br /> obj = new T();<br /> GetObjectFromReaderNode<t>(ref obj, ref xmlReader, ref objPropInfo, includeElement, nodeName);<br /> retList.Add(obj);<br /> }<br /> }<br /> }<br /> if (xmlReader.ReadState != ReadState.Closed)<br /> {<br /> xmlReader.Close();<br /> }<br /> return retList;<br /> }<br /> #endregion<br /><br /> #region SaveXmlFragment<br /> // Summary:<br /> // To Save XmlFragment at the end of the file<br /> public void SaveXmlFragment(string rawXmlFragment, string rootItem)<br /> {<br /> try<br /> {<br /> using (xmlReader)<br /> {<br /> while (xmlReader.Read())<br /> {<br /> if (xmlReader.NodeType == XmlNodeType.Element && xmlReader.Name == rootItem)<br /> {<br /> xmlWriter.WriteStartElement(rootItem);<br /> xmlWriter.WriteRaw(xmlReader.ReadInnerXml());<br /> xmlWriter.WriteRaw(rawXmlFragment);<br /> xmlWriter.WriteEndElement();<br /> }<br /> else if (xmlReader.NodeType == XmlNodeType.Comment || xmlReader.NodeType == XmlNodeType.Text || xmlReader.NodeType == XmlNodeType.Whitespace)<br /> {<br /><br /> }<br /> else<br /> {<br /> xmlWriter.WriteNode(xmlReader, true);<br /> }<br /> }<br /> xmlWriter.Flush();<br /> }<br /> }<br /> catch (Exception ex)<br /> {<br /> throw ex;<br /> }<br /> finally<br /> {<br /> xmlReader.Close();<br /> xmlWriter.Close();<br /> FileInfo fi = new FileInfo(_documentDirectory + "SiteData.xml");<br /> File.Copy(_documentDirectory + "_tempSiteData.xml", fi.FullName, true);<br /> } <br /> }<br /> #endregion<br /><br /> #region Search Document<br /> // Summary:<br /> // To Save XmlFragment at the end of the file<br /> public SortedDictionary<int>> SearchDocument<t>(string searchText, string nodeName, string propertyNameToLookFor) where T : new()<br /> {<br /> List<string> searchWords = new List<string>();<br /><br /> string[] allWords = searchText.Split(' ');<br /><br /> for (int i = 0; i <>> retDictionary = new SortedDictionary<int,>>();<br /><br /> T obj = new T();<br /><br /> PropertyInfo[] piAll = obj.GetType().GetProperties();<br /><br /> List<t> retList = this.LoadList<t>(nodeName, true);<br /><br /> foreach (T item in retList)<br /> {<br /> string content = "";<br /> int relevance = 0;<br /> foreach (PropertyInfo pi in piAll)<br /> {<br /> if (pi.Name == propertyNameToLookFor)<br /> {<br /> content = Convert.ToString(pi.GetValue(item, null));<br /> }<br /> }<br /> string[] contentSplitted = content.Split(' ');<br /> foreach (string word in searchWords)<br /> {<br /> for (int i = 0; i <> relCorrList = new List<t>();<br /> relCorrList.Add(item);<br /> retDictionary.Add(relevance, relCorrList);<br /> }<br /> else<br /> {<br /> retDictionary[relevance].Add(item);<br /> }<br /> }<br /> }<br /> return retDictionary;<br /> }<br /> #endregion<br /><br /> #region IDisposable Members<br /> public void Dispose()<br /> {<br /> if (xmlReader.ReadState != ReadState.Closed)<br /> {<br /> xmlReader.Close();<br /> xmlWriter.Close();<br /> }<br /> }<br /><br /> #endregion<br /><br /><br />}<br /><br />if you are getting it difficult to understand or have some queries you can put a reply or mail me at<br />shashank.abes at gmail.com<br /><br /></t></t></t></int,></string></string></t></int></t></t></t></t></t></string,></string,></t></t></string,></t></span></span>Unknownnoreply@blogger.com0