|
|
|
|
 |
SQL Server Full Text Search Optimization
|
| Total Hit (1843) |
Full text indexing is a great feature that solves a long running database problem, the searching of textual data columns for specific words and phrases in SQL Server databases.
|
Rating
 |
|
|
|
An Introduction to SQL Server Clustering
|
| Total Hit (596) |
If your mission-critical SQL Server should experience a motherboard failure, how long will it be down? One hour, four hours, a day, or longer? How much will this cost your business in lost sales or productivity? And perhaps even more important to you, what will it do to your stress level?
....Read More |
| Rating
|
|
|
|
|
|
How to Install Windows 2000 Cluster Services
|
| Total Hit (623) |
SQL Server clustering is not an easy task. It requires a good knowledge of Windows 2000, SQL Server 7.0 or SQL Server 2000, and time. Lots of it. The purpose of this article is to get you started along your way to SQL Server clustering. As a precursor to this step, you must first install and configu
....Read More |
| Rating
|
|
|
|
Dealing with a SQL Server Cluster Failover
|
| Total Hit (603) |
I had just gotten out of a short meeting and went to my desk to see what important e-mail messages I might had missed. In my inbox was a series of messages sent from ELM Enterprise Manager 3.0, the software we use to monitor our SQL Server event logs. The message had arrived about 30 minutes earlier
....Read More |
| Rating
|
|
|
|
Linking SQL Server to Heterogeneous Systems
|
| Total Hit (2106) |
The ability to link SQL Server to heterogeneous systems such as Oracle, DB2, Sybase, etc., is imminent. This article provides the basic and most important information required to make a linked server connection to heterogeneous systems from SQL Server. We are going to deal with three different RBBMS
....Read More |
| Rating
|
|
|
|
Using DTS to Detect and Process a File
|
| Total Hit (1162) |
There is nothing better than when a new technology lends itself to solving an old problem; well, there may be some things better, but this will have to do for now. One of the classic problems in computing -- classic being defined as a problem I have seen before -- is processing files that were uploa
....Read More |
| Rating
|
|
|
|
Linked Servers : An overview
|
| Total Hit (2094) |
Linked servers provide connectivity to external data sources, allowing you to access data and run procedures in SQL Server other than the one you are currently running on.
|
| Rating
|
|
|
|
|
|
MDX in Analysis Services: Intermediate Concepts - Part 1
|
| Total Hit (969) |
This is the second tutorial article of the series, MDX in Analysis Services. The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis Services (to which I will refer in most cases as simply "Analysis Services" to save time
....Read More |
| Rating
|
|
|
|
Working with SQL Server Date/Time Variables
|
| Total Hit (2048) |
This is the first article in a series of articles that I will discuss various aspects of working with SQL Server date/time columns. SQL Server has two different date/time columns. They are DATETIME and SMALLDATETIME. This article will define the difference between these two SQL Server date/time data
....Read More |
| Rating
|
|
|
|
Find Out What They're Doing with fn_get_sql
|
| Total Hit (1202) |
Not only did SQL Server 2000 introduce the concept of user-defined functions (UDF) but also Microsoft's development team created several such functions as part of the database product. In addition to many undocumented system UDFs, used internally by SQL Server, the product release has nine documente
....Read More |
| Rating
|
|
|
|
A Comparison of SQL Server 2000 with DB2 v8.1
|
| Total Hit (1663) |
Often people in newsgroups ask about a comparison of DB2 and Microsoft SQL Server. In this article I will compare SQL Server 2000 with DB2 Universal Database version 8.1 regarding price, performance, platforms supported, SQL dialects, and products limits.
....Read More |
| Rating
|
|
|
|
SQL Server 2000 Active Directory Integration
|
| Total Hit (2025) |
SQL Server 2000 was designed to operate as an integral part of the Windows 2000 domain environment. Unfortunately, the new features that best exemplify this integration are rarely taken advantage of. The purpose of this article is to present their overview.
....Read More |
| Rating
|
|
|
|
Reporting Options for Analysis Services Cubes: MS Excel 2002
|
| Total Hit (1788) |
This is the tenth article of the series, Introduction to MSSQL Server 2000 Analysis Services. As I stated in the first article, Creating Our First Cube, the primary focus of this series is an introduction to the practical creation and manipulation of multidimensional OLAP cubes. The series is design
....Read More |
| Rating
|
|
|
|
Streamlining the Database Server Recovery Process on SQL Server
|
| Total Hit (752) |
Are you tired of manually restoring each database on a new server when the original server has a melt down? Does the manual process seem slow, and prone to keystoke and mouse click errors? Would you like to have those restore scripts automatically built, so you only have to fire them off? Well this
....Read More |
| Rating
|
|
|
|
Synchronizing Production Data with a Test Database on SQL Server
|
| Total Hit (774) |
Every corporation has a unique infrastructure environment. Let us consider a simple production, testing, and a development environment. The SQL scripts application, developed in a development environment will be tested in a QA environment and then moved to production on a production date. Usually th
....Read More |
| Rating
|
|
|
|
|
|
The comparison of SQL Server 2000 with Oracle 9i
|
| Total Hit (982) |
Often people in newsgroups ask about some comparison of Oracle and Microsoft SQL Server. In this article, I compare SQL Server 2000 with Oracle 9i Database regarding price, performance, platforms supported, SQL dialects and products limits.
|
| Rating
|
|
|
|
MDX Member Functions: The "Family" Functions
|
| Total Hit (910) |
This is the fifth article of the series, MDX Essentials. The primary focus of this series is an introduction to the MDX language. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding fea
....Read More |
| Rating
|
|
|
|
Nightly Failed Jobs Report
|
| Total Hit (979) |
Do you get tired of reviewing each SQL Agent notification nightly to determine which SQL Agent jobs failed? Are there a significant number of SQL Agent job notifications that it takes a while to review each? Here is an alternative that allows you to have a single email report of all job failures.
....Read More |
| Rating
|
|
|
|
Indexed Views Basics in SQL Server 2000
|
| Total Hit (1176) |
Indexes have been a method to improve the performance of SQL queries since the creation of relational databases in the 1970's. You are probably familiar with the ways that indexes can speed query operations at the expense of additional overhead during data inserts, updates, and deletes. Up until rec
....Read More |
| Rating
|
|
|
|
|
|
|
|
Import Files with Date-stamped Filenames or Paths
|
| Total Hit (1298) |
DTS packages are fantastic features available in SQL Server 7.0 and SQL server 2000. One outstanding feature in the DTS package is the ability to run ActiveX scripts. ActiveX gives us an added advantage in handling many situations; we will discuss how to handle three of these situations.
File-nam
....Read More |
| Rating
|
|
|
|
How to Do SQL Server Log Shipping ?
|
| Total Hit (1665) |
This article is about log shipping, a refined variation of the traditional manual standby failover server process. Its two major benefits over the traditional methods is that it automates most of the manual work and helps to reduce potential data loss even more.
....Read More |
| Rating
|
|
|
|
|
|