|
|
|
SQL Server Full Text Search Optimization
|
Total Hit (1703) |
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 (533) |
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 (546) |
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
|
|
|
XML and SQL 2000 (Part 1)
|
Total Hit (1204) |
One of the most common problems with managing data is its versatility. This becomes evident when exchanging data between multiple data sources and results mainly from incompatibilities in data representation and format. The impact of this type of problem affects most companies internally, but is eve
....Read More |
Rating
|
|
|
A Server by Any Other Name
|
Total Hit (750) |
It is imperative to change the server name when infrastructure policy changes, naming convention standard changes or making a standby server the production server (when production server fails). When a server name is changed, SQL server should go through a process to acknowledge and assimilate the c
....Read More |
Rating
|
|
|
A Comparison of SQL Server 2000 With Sybase ASE 12.5
|
Total Hit (1611) |
Often people in newsgroups ask about some comparison of Microsoft SQL Server and Sybase Adaptive Server. In this article, I compare SQL Server 2000 with Sybase Adaptive Server Enterprise 12.5 (Sybase ASE 12.5) regarding price, performance, platforms supported, SQL dialects, and products limits.
....Read More |
Rating
|
|
|
Backup--Transfer--FTP!
|
Total Hit (2025) |
Having a standby server in a remote site, copying backup files directly to a Disaster recovery site or other requirements such as transfering files from one location to another using FTP creates the need for creating a FTP batch file using a changing parameter file. In this article, I will walk you
....Read More |
Rating
|
|
|
MDX Essentials: Member Functions: More "Family" Functions
|
Total Hit (679) |
This is the sixth article of the series, MDX Essentials. The primary focus of this series is an introduction to MDX. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designe
....Read More |
Rating
|
|
|
MDX in Analysis Services: Intermediate Concepts - Part 1
|
Total Hit (891) |
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 (1908) |
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 (1112) |
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 (1563) |
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 (1902) |
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 (1665) |
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 (683) |
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 (711) |
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 (929) |
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 (857) |
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 (922) |
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 (1098) |
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 (1182) |
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 (1559) |
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
|
|
|
|