query

Solution Search:
Getting Started with LINQ to XML by Global Knowledge
LINQ is an acronym which stands for Language Integrated Query. This new technology comes built into the .NET Framework 3.5 and can be used with any of the different languages that run under .NET. This...
Using Visual Analysis to Answer any Question by Tableau Software
Intelligence software that helps people visually query and interpret information in databases. It enables users to transform raw data into smart decisions using a drag and drop process...
eGuide: Performance tuning SQL Server via queries, indexes and more by Microsoft
by SearchSQLServer.com and Microsoft, learn how to improve query performance, troubleshoot memory configurations, design optimal indexes, utilize database storage methods and solve common SQL...
The Vertica Analytic Database: Rethinking Data Warehouse Architecture by Vertica Systems
a lower cost approach to meeting the performance demands of query-intensive analytic applications should consider the Vertica Analytic Database solution. In today's market, leveraging...
Idera SQL diagnostic manager - SQL Server performance monitoring and alerting by Idera
Degradation in SQL Server performance has a noticeable and immediate impact on business productivity. Database administrators need to proactively manage...
Embarcadero® DB Optimizer™ by Embarcadero Technologies, Inc.
queries, focusing on specific SQL statements through query statistics (CPU, I/O, wait times), and fine-tuning problematic statements.

Download size: 163MB

What's Cool about Columns by ParAccel
and it is not surprising that business intelligence and query systems in general are under increasing pressure. Worse, demands on this information are increasingly widespread and of a real...
All Information, All People, One Platform: What's New In SAP® BusinessObjects™ XI 3.1 by SAP BusinessObjects
a full spectrum of BI functionality--from reporting, query and analysis, and dashboards and visualization, to intuitive discovery and advanced predictive analytics capabilities--as well...
Applied JSON: HTTP REST, Ajax Databases and Beyond by The Ajax Experience
with these simple interfaces and how to use JSONPath as a query language for JSON data stores. We see how these dynamic databases utilize JavaScript on the server for a consistent client/server...
Postgres Plus® Advanced Server by EnterpriseDB Corporation
at a wide range of application types, including both OLTP and query-intensive applications. Built upon PostgreSQL the world's most advanced open source database, Advanced Server includes the high...
Squeezing More Value out of Data Warehouses through the Power of Database Compression by Vertica Systems
its columnar storage architecture and compression-aware query engine, Vertica can speed up queries to run orders of magnitude faster (50x-300x based on customer benchmarks), and at the same time...
Large School District Transitions from Kronos to GHG for Their Time & Attendance Solution by GHG Corporation
By implementing eEMS, Killeen has integrated its business processes, and consolidated vital organizational data into a centralized data repository that...
Why Data Loss Prevention? Top Security Initiative for Fortune 1000 by Symantec Corporation
Do you know where your confidential data is? How is it being Used? How to prevent data loss? The research paper from The InfoPro (TIP) delivers the findings to these...
Oracle Database 11g for Data Warehousing and Business Intelligence by Oracle Corporation
This white-paper provides an overview of Oracle Database 11g's capabilities for data warehousing, and discuses its key features and technologies. Discover...
DBAs, Developers and Analysts - Everyone Can Benefit from Toad for Oracle by Quest Software
This technical brief explores the challenges of accessing and managing Oracle and non-Oracle data sources, then explains how Toad for Data Analysts...
Enterprise Security Reporter Version 3.6.3 by ScriptLogic Corporation
the administrator with tools to compare, analyze, query and report on the security and configuration of the network. Enterprise Security Reporter includes numerous ready-made and...
Enterprise Security Reporter for SharePoint Version 3.6.3 by ScriptLogic Corporation
the administrator with tools to compare, analyze, query and report on the security and configuration of the SharePoint site, users, document ownership, permissions and document...
Oracle Business Intelligence Suite Enterprise Edition Plus ---Technical Overview by Oracle Corporation
Business intelligence (BI) needs to evolve such that it is no longer about reporting results but driving business processes. Learn how BI can bring you greater...
Faster SQL Profiling for Better Database Performance by Embarcadero Technologies, Inc.
Find out how Embarcadero's DB Optimizer™ can help you to quickly discover and fix problematic SQL statements that can cause performance bottlenecks in...
Maximize Availability with Oracle Database 11g by Oracle Corporation
Attend this Webcast to learn how innovations in intelligent data protection and availability in Oracle Database 11g makes implementing high availability...
10 Ways to Reduce Your Email Costs by Iron Mountain Digital
Thinking about cutting costs by switching to email archiving and management in the cloud, but not sure how it all adds up? Learn how Iron Mountain's Total Email...
Cisco EnergyWise: At-A-Glance by Cisco Systems, Inc.
EnergyWise uses a unique domain-naming system to query and summarize information from large sets of devices, making it simpler than traditional network management capabilities...
Increasing Enterprise Data Warehouse Performance, Longevity and ROI with the Vertica® Analytic Database by Vertica Systems
Today EDWs are commonplace and a necessity if an organization is to remain competitive and successful. This paper describes how its possible to increase the...
SQL Server Resource Center
FAQ: Troubleshooting SQL Server Reporting Services
created. Once the data source is set up, you can create datasets in the query designer by running SQL statements against the Excel data. For example, let's say you... More...
Nov 3, 2008
SQL Server out of memory: Troubleshoot and avoid SQL memory problems
allocation_units and sys.partitions DMVs are database-specific. This query tells you which tables and in what percentages they are loaded into memory. Only... More...
Oct 16, 2008
Additional T-SQL operations in SQL Server 2008
Scalar Operators

Scalar operators are used for operations with scalar values. Transact-SQL supports numeric and Boolean... More...

Oct 15, 2008
SQL Related Articles
SQL Server vs. MySQL: Syntax differences, similar GUIs by MiMi Yeh, Assistant Editor
in Microsoft SQL Server and MySQL affect the syntax of a dynamic query?

Scott Noyes: There is no "TOP" clause in MySQL. Instead, you need to use ORDER BY and LIMIT clauses at the end of the query to return the... More...

Aug 2, 2006
Best practices for improved database management by Steve Lemme, Contributor
using application: Do your customers rely on you for setup, query and reporting from the databases managed? Skill set, experience and training of database management staff: Is your staff updating... More...
Jul 14, 2006