|
|
|
|
|
Total Hits: 402 | Today: 0
|
Author: Nils Bevaart
|
Rating:
|
|
As a SQL Server DBA, one of my tasks is to monitor the performance of our databases. Our primary database holds the data of over 18 million people. A web-based application queries the database with a variety of search options. When examining the performance of these queries, most performed very well. But on the other hand, a few queries have resulted in a time-out. One of the first steps in analyzing the time out problem was to find the search pattern used in the slow running queries. I found th...
|
|
|
|
Total Hits: 461 | Today: 0
|
|
Rating:
|
|
This step-by-step article describes how to move SQL Server user databases and most common SQL Server components between computers that are running SQL Server....
|
|
|
|
Total Hits: 101 | Today: 0
|
Author: John Prabhu
|
Rating:
|
|
In the new version (.NET framework 3.5), Microsoft have provided a way to define the queries in the programming language (C# 3.0, VB.NET 9.0) using LINQ which is called Language-Integrated query. It's basically a programming concept to query the data against the following :
* database (LINQ to SQL),
* dataset (LINQ to Dataset),
* xml (LINQ to XML) and
* objects (LINK to Entities)....
|
|
|
|
Total Hits: 187 | Today: 0
|
|
Rating:
|
|
An APPC transaction program may cause Host Integration Server 2000 to log multiple Event ID 8 messages and cause CPU utilization to reach 100 percent.
Details of the Event ID 8
Event Type: Warning
Event Source: SNA Server
Event Category: None
Event ID: 8
Description:
(1174) Internal Protocol Violation
EXPLANATION
A protocol violation has occurred at the interface between the SNA
Service and another SNA component (for example, the emulator or link
service).
SUBCODE INFORMATION
X'1105' Insufficient space to copy data into node buf..Read More..
|
|
|
|
Total Hits: 243 | Today: 0
|
|
Rating:
|
|
You cannot change the SQL Collation in SQL Server 2000 with the Rebuild Master Utility or the SQL Server 2000 Setup from the current SQL Collation to any of the following SQL Collations:
- SQL_Estonian_CP1257_CI_AS
- SQL_Estonian_CP1257_CS_AS
- SQL_Latin1_General_CP1257_CI_AS
- SQL_Latvian_CP1257_CI_AS
- SQL_Latvian_CP1257_CS_AS
- SQL_Lithuanian_CP1257_CI_AS
- SQL_Lithuanian_CP1257_CS_AS
- SQL_Danish_Pref_CP1_CI_AS
|
|
|
|
Total Hits: 365 | Today: 0
|
Author: Luis Martin
|
Rating:
|
|
As a DBA, it is our regular task to review our databases and see if there is any way we can boost their performance. While adding new or better indexes to a database is one of the primary ways we can boost performance, an often forgotten way to help boost database performance is to remove indexes that are no longer being used, or to identify overly large indexes that take a lot of SQL Server's resources. Unused indexes hurt INSERT, UPDATE, and DELETE performance, and add unnecessary disk I/O. So...
|
|
|
|
Total Hits: 307 | Today: 0
|
|
Rating:
|
|
The rebuilding of the Pubs database requires Instpubs.sql to be executed. This script file rebuilds the database and the objects in the database. However, the data loading is not complete until Pubimage.bat and Pubtext.bat files are executed. These two files complete the text and image data load into the Pub_info table (which is new in SQL Server 6.0). All the files are located in the \Install directory. The rebuilding of the Pubs database requires Instpubs.sql to be executed. This s...
|
|
|
|
|
|
