X
Software Functionality Revealed in Detail
We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.
Get free sample report

Compare Software Solutions
Visit the TEC store to compare leading software solutions by funtionality, so that you can make accurate and informed software purchasing decisions.
Compare Now
 

 tuning sql queries


Microsoft Announces SQL Server 2000
On December 13, Microsoft Corp. announced that the next major release of Microsoft« SQL Server, currently code-named

tuning sql queries  Announces SQL Server 2000 Event Summary REDMOND, Wash. - Dec. 13, 1999 - Microsoft Corp. today announced that the next major release of Microsoft SQL Server, currently code-named Shiloh, would officially be named SQL Server 2000. Microsoft also revealed the features within SQL Server 2000 that will take advantage of the Microsoft Windows 2000 operating system, as well as the ways SQL Server 7.0 customers today can reap benefits from Windows 2000. SQL Server 2000 is due to ship in the first

Read More


Software Functionality Revealed in Detail

We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.

Get free sample report
Compare Software Solutions

Visit the TEC store to compare leading software by functionality, so that you can make accurate and informed software purchasing decisions.

Compare Now

Documents related to » tuning sql queries

Access to Critical Business Intelligence: Challenging Data Warehouses?


There is a perception that if business users are given access to enterprise databases and raw query tools, they will create havoc in the system, which is a possibility—unless the business intelligence (BI) product developer understands the potential problem and addresses it as a business-critical factor.

tuning sql queries  IT management costs of tuning the transaction database are likely less than the cost of the ongoing maintenance required by a DW, which becomes a mission on its own, to a degree that the enterprises even forgot the original purpose of the DW. Part Six of the Business Intelligence Report Status Quo series. Improving the DW Model When the DW model was conceived, it was believed that it was necessary to stage data in a warehouse to provide reasonable query performance for users. However, this is a case where Read More

The Art Of Distributed Development Of Multi-Lingual Three-Tier Internet Applications


In this article we describe author's experience with the distributed development of multi-lingual three-tier Java/ CORBA/database Internet applications. We believe that the described tips and tricks of trade may be of great use to readers who are involved with Java applications development.

tuning sql queries  of single-language applications, fine tuning is easier since strings displayed in browsers are not hard-coded, thus they are accessible for quick modification and customization in property files. The property files may be stored in and retrieved from the file system. This approach allows customers, i.e., system administrators of the production site, to edit them and fine-tune appearance of strings in multiple languages. The other approach is to put property files in the application's class hierarchy and p Read More

Comparing the Total Cost of Ownership of Business Intelligence Solutions


For many companies, traditional business intelligence (BI) software is costly and resource-intensive. So are open source alternatives that require significant configuration and integration. In contrast, software-as-a-service (SaaS) solutions can reduce the cost of a BI deployment by providing automation and pre-integration. Compare total cost of ownership (TCO) for traditional, open source, and SaaS BI solutions.

tuning sql queries  (and perhaps execution) Index rebalancing/tuning Index/table defragmentation Database copy/replication (e.g. test environment versus production) Security and security policy management Database file management For cube data stores, index and file management are reduced, but cube reloading is a bigger issue. Moreover, proliferation of cubes exacerbates the other issues. Birst automatically handles all database management tasks. Logical Data Model Changes As a business changes, its BI also needs to change. Read More

A Demand-driven Approach to BI


The core concept behind the Vanguard solution is that business intelligence (BI) must be demand-driven, which means that the business needs of the user dictate the technical solution, not the other way around. In other words, it should let the business users drive the process, and remove the problems of content relevance and software complexity.

tuning sql queries  of system performance. Further tuning of the system occurs during customer implementations, to account for the specifics of their infrastructure and user base. Overall, Vanguard's combination of automated content publishing and managed database access aims at providing an efficient, scaleable model for enterprise information delivery. To build a custom ad hoc query, Vanguard users select the information they need to see from a menu of options, whereby they are able to see all of the data sources they have Read More

Oracle8i Release 2 - Ready to Storm the Web


On November 15, Oracle Corp., announced the pending availability of Oracle8i Release 2, the follow-on to Oracle8i, the most rapidly adopted database product ever released by the company. To date, more than 5000 "Dot Coms" and other enterprises are using Oracle8i. Additionally, over 800 Independent Software Vendors (ISVs) have developed applications and tools optimized for Oracle8i data warehousing and online transaction processing features since the product's release in March 1999. The new release has expanded analytical data warehousing functions, native support for Java2 and performance and management enhancements.

tuning sql queries  Release 2 - Ready to Storm the Web Event Summary LOS ANGELES, ORACLE OPENWORLD '99, Nov. 15 /PRNewswire/ -- At Oracle OpenWorld '99 today, Oracle Corp., announced the pending availability of Oracle8i Release 2, the follow-on to Oracle8i, the most rapidly adopted database product ever released by the company. To date, more than 5000 Dot Coms and other enterprises are powering their e-businesses with Oracle8i, the database designed for the Internet. Additionally, over 800 Independent Software Read More

My Network Engineers are Talking about Implementing Split DNS. What Does that Mean?


You have heard that something called split DNS can speed up websites. What does this mean and how does it work?

tuning sql queries  split dns,dns setting,how to dns,dns service free,dns resolver,dns admin,setting up dns server,dns dig tool,open dns,dns lookup tools,external dns server,dns management,dns check,bind secondary dns,local dns Read More

Dreamforce 2010: Of Cloud Proliferation - Part 2


Part 1 of this blog series talked about my attendance of Dreamforce 2010, salesforce.com’s annual user conference, which has over the past several years become a highly anticipated and entertaining end-of-the-year fixture for enterprise applications market observers. My post concluded that while Dreamforce 2009 was mostly about continued growth of the cloud computing

tuning sql queries  2010: Of Cloud Proliferation - Part 2 Part 1 of this blog series  talked about my attendance of Dreamforce 2010 , salesforce.com ’s annual user conference, which has over the past several years become a highly anticipated and entertaining end-of-the-year fixture for enterprise applications market observers. My post concluded that while Dreamforce 2009 was mostly about continued growth of the  cloud computing  trailblazer and unveiling of Salesforce Chatter , the company’s nascent social Read More

Fenestrae Offers WAP Support for Mobile Data Server


Mobile Data Server 2.0 (MDS) allows access via WAP to a company’s Intranet, Microsoft Back Office databases, such as SQL Server in addition to Microsoft Exchange Integration for messaging.

tuning sql queries  Offers WAP Support for Mobile Data Server Fenestrae Offers WAP Support for Mobile Data Server P. Hayes - July 6, 2000 Event Summary Singapore - Fenestrae has announced the Fenestrae® Mobile Data Server™ with extensive WAP functionality. The Fenestrae Mobile Data Server version 2.0 enables professionals to use their WAP phones to access any information in Microsoft® Exchange/Outlook (inbox, calendar, contacts), databases, and Intranet. Market Impact Fenestrae's Mobile Data server has been Read More

Great Plains' eEnterprise Solution 'N Sync with Microsoft's New Platforms


Great Plains announced that its eEnterprise solution scales considerably better on Microsoft SQL Server 2000 in comparison to Microsoft's SQL Server 7.0.

tuning sql queries  Plains' eEnterprise Solution 'N Sync with Microsoft's New Platforms Great Plains' eEnterprise Solution 'N Sync with Microsoft's New Platforms P.J. Jakovljevic - October 31, 2000 Event Summary In September Great Plains, a leading small-to-mid-market provider of back-office and e-business solutions, announced performance figures showing that its eEnterprise solution scales considerably better on Microsoft SQL Server 2000 in comparison to Microsoft SQL Server 7.0. SQL Server 2000 is Microsoft's latest Read More

M3O Operational Intelligence Suite


Operational intelligence (OI) is a new form of real-time, dynamic business analytics that delivers visibility and insight into business operations. OI solutions run queries analysis against live feeds and event data to deliver real-time, actionable information. This real-time information can be acted upon in a variety of ways: alerts can be sent or executive decisions can be made using real-time dashboards.  

tuning sql queries   Read More

Teradata Introduces Aster Discovery Platform 5.10


Teradata recently announced a new version of its Aster Discovery Platform, which contains important enhancements to the existing functionality set, aiming to deal with the analysis of big data. The Teradata Aster Discovery Platform addresses the issues associated with an organization's big data analytics requirements and aims to reduce the difficulties associated with deploying and managing big

tuning sql queries  Introduces Aster Discovery Platform 5.10 Teradata recently announced a new version of its Aster Discovery Platform , which contains important enhancements to the existing functionality set, aiming to deal with the analysis of big data. The Teradata Aster Discovery Platform addresses the issues associated with an organization's big data analytics requirements and aims to reduce the difficulties associated with deploying and managing big data analytics initiatives (from data collection to Read More

glovia G2 Is Now TEC Certified for ERP for Discrete Manufacturing


I am pleased to announce that Glovia International’s G2 enterprise resource planning (ERP) solution is now TEC Certified and available for online evaluation of ERP for discrete manufacturing solutions in TEC’s ERP Evaluation Center. Glovia has more than 30 years of experience developing its solution to meet the needs of discrete manufacturers. And, based on the data evaluated by Technology

tuning sql queries  G2 Is Now TEC Certified for ERP for Discrete Manufacturing I am pleased to announce that Glovia International’s G2 enterprise resource planning (ERP) solution is now TEC Certified and available for online evaluation of ERP for discrete manufacturing solutions in TEC’s ERP Evaluation Center. Glovia has more than 30 years of experience developing its solution to meet the needs of discrete manufacturers. And, based on the data evaluated by Technology Evaluation Centers (TEC), G2 is one of the more Read More

Microsoft Goes Their Own Way with Data Warehousing Alliance 2000


Microsoft Corp. (Nasdaq: MSFT) today announced that 47 applications and tools from 39 vendors throughout the industry have qualified for Microsoft« Data Warehousing Alliance 2000. Alliance members and partners are committed to delivering tools and applications based on the Microsoft Data Warehousing Framework 2000, an open architecture based on the open standards and services built into the Windows« 2000 operating system, Microsoft SQL Server 7.0 and Office 2000.

tuning sql queries  Goes Their Own Way with Data Warehousing Alliance 2000 Event Summary REDMOND, Wash., Nov. 30 /PRNewswire/ -- Microsoft Corp. (Nasdaq: MSFT) today announced that 47 applications and tools from 39 top vendors throughout the industry have qualified for Microsoft Data Warehousing Alliance 2000. Alliance members and partners are committed to delivering tools and applications based on the Microsoft Data Warehousing Framework 2000, an open architecture for building business intelligence and analytical Read More

SAP HANA-One Technology to Watch in 2012 (and Beyond)


Did you know that SAP HANA is much more than a high-speed analytic appliance? TEC principal analyst P.J. Jakovljevic reveals how HANA is a universal database that will enable companies to analyze large volumes of operational and transactional information in real time, from virtually any data source, and that will eventually deliver an entirely new class of applications that will change the way people think, work, plan, and operate.

tuning sql queries  HANA-One Technology to Watch in 2012 (and Beyond) The third week of December 2011 was the week of my revelations of sorts in the realm of enterprise applications. In all that seemingly endless information technology (IT) talk throughout the year about the cloud computing, analytics, mobile and social apps, and in-memory buzzwords, two concrete announcements at vendor events in mid-December made me pause for thought. Though both vendor announcements are still some time away from commercial application, Read More