|
|
|
|
|
| | Total Hits: 361 | Today: 0 | | Rating:  |
| | 
If SQL Server is hit with multiple and simultaneous TCP/IP connection requests, such as the case with World Wide Web servers, the requests are quickly rejected by responding with a TCP/IP Reset Frame.... |
| | Total Hits: 2992 | Today: 0 | | Rating: |
| |
This article describes how to handle errors in DTS Package and Step objects by using the GetExecutionErrorInfo method call, OnError event and Visual Basic Err object.... |
| | Total Hits: 426 | Today: 0 | | Rating: |
| |
SQL Server allows you to choose from a number of different network libraries that you can use when connecting. You can configure these network libraries when you create a data source name (DSN) for your data source. However, an alternative way to specify the DSN is to pass in the network library, which you want to use, with the connection string. This article describes how to specify the network library that you want to use for connecting to SQL Server when connecting from a Visual Basic applica... |
| | Total Hits: 243 | Today: 0 | | Rating:  |
| |
You can configure the SQL Server replication agents (that is, the Snapshot Agent, Log Reader Agent, Queue Reader Agent, Distribution Agent, and Merge Agent) to capture more information about error messages and procedure calls to a text file. For instance, you can capture the additional information about error messages and procedure calls to troubleshoot agent failures.... |
| | Total Hits: 936 | Today: 0 | | Rating: |
| |
This article explains and illustrates the use of the following Linear Regression functions in a calculated member:
- LinRegIntercept
- LinRegPoint
- LinRegR2
- LinRegSlope
- LinRegVariance
MORE INFORMATION
Linear Regression is a statistical method that predicts the value of one variable, based on knowledge of another variable and the statistical relationship between the two. The Linear Regression functions use the...
|
| | Total Hits: 112 | Today: 0 | | Rating:  |
| |
A loss of INSERT commands into child tables at a subscriber may occur under the following conditions:
- The merge replication topology is hierarchical, with a publisher, one or more republishers, and one or more subscribers.
- One or more parent and child articles exist in a merge replication publication, with a join filter defined between them.
- A NOT FOR REPLICATION foreign key constraint exists at the republisher and subscriber for the relationship betwee...
|
| | Total Hits: 298 | Today: 0 | | Rating: |
| |
Special considerations must be made for performance optimization of queries built on attached SQL database tables. An SQL database, for this article, is defined as any client/server database that supports some level of ANSI SQL as an intrinsic part of the database's programming language. Optimal query strategy for these queries is to ensure that all query operations are performed on the server. This article outlines tips on how to ensure that queries against attached SQL database tables are..... |
| | Total Hits: 421 | Today: 0 | | Rating: |
| |
SQL Server 7.0 allows the addition of external data sources as linked servers. This feature provides access to distributed, heterogeneous queries against OLE DB data sources. When connecting to SQL Server, a cursor listing available tables can be returned with the SQLTables(file_handle) command. The SQLTables() command, however, does not return information about tables available in Linked Servers. Information regarding linked servers is returned by three different SQL Server 7.0 stored procedure... |
| | Total Hits: 322 | Today: 0 | | Rating: |
| |
Troubleshooting performance issues involves using a series of steps to isolate and determine the cause of an application slowdown. Possible causes include blocking, system resource contention, application design problems, or a particular set of queries or stored procedures with long execution times. This article walks you through the process of determining the source of a performance issue. It also references other articles in the Microsoft Knowledge Base that cover the details of specific perfo... |
| | Total Hits: 281 | Today: 0 | | Rating: |
| |
This article deals with one specific type of performance issue that applications may experience with Microsoft SQL Server: the run-time recompilation of stored procedures. If you are troubleshooting a performance issue, but you have not determined that this is the precise source of your problem, refer to the following article in the Microsoft Knowledge Base before proceeding..... |
| | Total Hits: 274 | Today: 0 | | Rating: |
| |
During this session, we will discuss the tools used to collect performance data and how to use this data to analyze some common SQL Server performance issues. We will review how to set up these tools and analyze the data collected. In addition, we will talk about troubleshooting techniques used to identify SQL Server performance issues.... |
| | Total Hits: 281 | Today: 0 | | Rating: |
| |
This article documents the usage and design of a stored procedure that you can use to diagnose blocking and performance issues. For a description of how to understand and resolve blocking... |
| | Total Hits: 323 | Today: 0 | | Rating: |
| |
The opportunity to trap error and warning messages sent to a client from the SQL Server can provide powerful information when you are tracking down a problem. This document explains, in detail, how to accomplish this from both SQL Server version 6.5 and 7.0.... |
| | Total Hits: 324 | Today: 0 | | Rating: |
| |
The easiest way to convert an Access database to SQL Server is to use the Upsizing Wizard. The Upsizing Wizard: Preserves database structure including data, indexes, defaults, and so on. Automatically converts Access validation rules and defaults to the appropriate SQL Server equivalents. Maintains table relationships and referential integrity after upsizing.... |
|
|
|
|
|
|
|
|
|
|
|
|
|