|
|
|
|
|
|
| | Total Hits: 26 | Today: 0 | Author: Alexander Chigrik | Rating:  |
| | 
In this article, I want to tell you about undocumented system tables shipped with SQL Server 7.0. These tables are used by some system stored procedures and stored in the master database (only the sysfiles1 system table is stored in each database).... |
| | Total Hits: 33 | Today: 0 | Author: Alexander Chigrik | Rating:  |
| |
In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 6.5.... |
| | Total Hits: 19 | Today: 0 | Author: Randy Dyess | Rating: |
| |
Trace flags are used to temporarily enable or disable specific SQL Server database functions, allowing you to change default database behavior or to observe hidden database behavior, and will remain in effect until they are either manually turned off or SQL Server is restarted. Keep in mind that most trace flags are undocumented and Microsoft can and will change the behavior of the flag between SQL Server versions, service packs or hot fixes.... |
| | Total Hits: 218 | Today: 0 | Author: Ray Barley | Rating:  |
| |
We are just getting started with PerformancePoint Server 2007 and trying to help our business users to develop their first scorecard. For those of you who are new to Office PerformancePoint Server 2007, PPS is a recent addition to the Microsoft Business Intelligence (BI) offering. PPS enables users to develop a variety of reports and scorecards, then compose them into a dashboard which is deployed to SharePoint. Business users can then simply navigate to a URL in a SharePoint site to access t... |
| | Total Hits: 257 | Today: 0 | Author: Ray Barley | Rating: |
| |
We have heard that you can create filters in a Performance Point dashboard then apply them to one or more reports and scorecards. Can you provide some step-by-step instruction on how to do this? The PPS product is a recent addition to the Microsoft Business Intelligence (BI) offering. PPS enables users to develop a variety of reports and scorecards, then compose them into a dashboard which is deployed to SharePoint. Business users can then simply navigate to a URL in a SharePoint site to acce... |
| | Total Hits: 91 | Today: 0 | Author: Goetz Graefe, Jim Ewel, and Cesar Galindo-Legaria | Rating:  |
| |
Microsoft® SQL Server™ version 7.0 is a defining release for Microsoft's database products, building on the solid foundation established by Microsoft SQL Server version 6.5. Customer needs and requirements have driven the significant product innovations in SQL Server 7.0. As the best relational database management system (RDBMS) for the Microsoft Windows® family of operating systems, SQL Server is the right choice for a broad spectrum of corporate customers and independent software vendors (ISVs... |
| | Total Hits: 84 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
Replication provides a fast and reliable way to disseminate corporate information to multiple locations in a distributed business environment, enabling organizations to move their data closer to knowledge workers in corporate, branch, or mobile offices. This paper provides information about the replication capabilities of Microsoft® SQL Server™ version 7.0, and how they can empower users, improve decision-making, and increase the performance and reliability of existing systems by reducing depend... |
| | Total Hits: 100 | Today: 0 | Author: Henry Lau | Rating: |
| |
Shows SAP R/3 database administrators and others who work on very large databases how to tune Microsoft® SQL Server™ version 7.0 for the workload conditions of the SAP R/3 environment. (22 printed pages) Covers:
* Configuration options to consider for Microsoft Windows 2000® Server
* Configuration options for SQL Server in the SAP R/3 environment
* SQL Server index design as it pertains to SAP R/3
"Microsoft SQL Server 7.0 Performance Tuning Guide" is companion reading to... |
| | Total Hits: 108 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
This article describes the concept of full-text search, as well as the design and architecture of the SQL Server 7.0 full-text search system. This article also illustrated how the SQL Enterprise Manager facilitated administration with stored procedures and graphical user interfaces. Microsoft® SQL Server™ version 7.0 introduces facilities that support textual queries on data residing in SQL Server as well as textual queries on data in the file system. This document describes support for textual ... |
| | Total Hits: 80 | Today: 0 | Author: Margaret Li and Frank Pellow | Rating:  |
| |
This article discusses facets of Microsoft SQL Server 7.0 textual searches such as: how SQL queries can be used on file systems lacking tables; how to use SQL extensions to make full-text queries; and how to work with a combination of file and database information. This article also discusses how BackOffice products (including: SQL Server distributed queries, Window NT Server's built-in Web Server, Internet Information Server (IIS), and Index Server 2.0) support textual searches in SQL Server 7.... |
| | Total Hits: 80 | Today: 0 | Author: Ninia Ingram | Rating: |
| |
Explains how to analyze data from different database management systems with Microsoft® SQL Server™ 7.0 and the Visual Studio® 6.0 Database Tools. (7 printed pages) With the linked server and TOP features in Query Designer you can:
* Access outside OLE DB data sources with the linked server feature.
* Limit the data you want returned by using the TOP clause.
* Improve database performance and efficiency with filegroups.
* Generate unique identifiers with the GUID data... |
| | Total Hits: 63 | Today: 0 | Author: Microsoft | Rating: |
| |
Applications and scenarios for high-performance computing (HPC) are increasing in terms of automation, speed, and ease of use. With the growing popularity of compute clusters, application developers are starting to use parallel processing techniques to deliver cutting-edge performance. Microsoft delivers the first step towards Windows-based computational clustering with Windows Compute Cluster Server 2003—a comprehensive HPC solution surrounded by a broad ecosystem of partners, products, and ser... |
| | Total Hits: 196 | Today: 0 | | Rating: |
| |
Most companies' secrets are all in a computer somewhere. Yet, guidelines for determining employees' rights of acess to digitized information are typically based solely on behavior models of the "brick and mortar" world. Modeling employee behavior in cyberspace can help companies and other institutions develop more sophisticated methods to ensure real-world business IT security. In this session, Michael Theis, chief of Cyber Counterintelligence for the National Reconnaissance Office, will discuss... |
| | Total Hits: 58 | Today: 0 | Author: Microsoft | Rating: |
| |
In Part 5 of this webcast series, you learn how to build an interface for your Sudoku game to load and benchmark multiple AIs, as well as a custom graphing component that compares the AIs.... |
| | Total Hits: 553 | Today: 0 | | Rating: |
| |
October 26, 1999
This presentation is designed to give developers an overview of OLE DB provider and data source specific issues with SQL Server 7.0 distributed queries. We will also discuss how to develop and troubleshoot an OLE DB provider to work with SQL Server 7.0 distributed queries.... |
| | Total Hits: 536 | Today: 0 | | Rating: |
| |
October 5, 1999
This presentation covers the internals of the replication mechanism in SQL Server 6.5. It discusses the replication processes in depth and covers administration, performance tuning, and troubleshooting.... |
| | Total Hits: 1204 | Today: 0 | | Rating: |
| |
December 4, 2001
In this session, we will discuss how to configure and troubleshoot an HTTP connection to Analysis Services over both the Internet and an intranet. We will show you how to configure Microsoft Internet Information Services (IIS), and discuss the different security options for IIS in regard to Analysis Services. We will also talk about the client connection string and performance issues that may arise while using the HTTP connection.... |
| | Total Hits: 1001 | Today: 0 | | Rating: |
| |
Thursday, July 18, 2002: 10:00 A.M. Pacific time (Greenwich mean time - 7 hours)
During this WebCast, we will explore the ways to integrate assemblies and Web services written with the .NET Framework, for both tightly coupled and loosely coupled systems. We will first discuss the loosely coupled systems that implement URL queries, templates, and ADO.NET classes to send and receive XML documents. We will then explore the SQLXML 3.0 interface used for automatic exposure to SOAP, and ... |
| | Total Hits: 1110 | Today: 0 | | Rating: |
| |
Tuesday, June 11, 2002: 10:00 A.M. Pacific time (Greenwich mean time - 7 hours)
This WebCast will introduce the new subscription option (queued updating) in Microsoft SQL Server 2000 transactional replication. It will discuss the benefits of using this option, requirements and special considerations to be aware of before implementing it, and show its workflow. The WebCast will also describe the differences between Transactional Replication with queued updating, immediate updating, ... |
| | Total Hits: 522 | Today: 0 | | Rating: |
| |
November 2, 1999
This presentation will cover the basic Full-Text Search (FTS) features and functionality introduced in SQL Server 7.0. We will discuss the Full-Text Indexing and Search processes, compare FTS results to the LIKE function. We will also talk about FTS stored procedures, FTS performance tuning, and basic troubleshooting methods.... |
|
|
|
|
|
|