 |
The comparison of SQL Server 2000 with MySQL v4.1
|
| Total Hit (889) |
Often people in newsgroups ask for a comparison of Microsoft SQL Server and MySQL. In this article, I compare SQL Server 2000 with MySQL version 4.1 regarding price, performance, platforms supported, SQL dialects and product limitations.
|
Rating
 |
|
|
|
Implementing CRUD Operations Using Stored Procedures: Part 1
|
| Total Hit (757) |
That's the American Heritage dictionary definition but not the database definition. When you are working with databases, CRUD is an acronym for the four essential database operations: Create, Read, Update, and Delete.
|
| Rating
|
|
|
|
Linked Servers on MS SQL: Part 1
|
| Total Hit (882) |
Think of a Linked Server as an alias on your local SQL server that points to an external data source. This external data source can be Access, Oracle, Excel or almost any other data system that can be accessed by OLE or ODBC--including other MS SQL servers. An MS SQL linked server is similar to the
....Read More |
| Rating
|
|
|
|
Using xp_fixeddrives to Monitor Free Space
|
| Total Hit (787) |
As a DBA one of your responsibilities is to monitor disk space. You always need to make sure you have enough for your databases, database backups and any other types of files you plan to store on your server. If you don't monitor your disk space and make sure you have enough space, eventually one of
....Read More |
| Rating
|
|
|
|
SQL 2000 and Web Services (XML and SQL part 11)
|
| Total Hit (933) |
In the last article of this series, we will focus on Web Services and their implementation in the SQL Server 2000 environment with the help of the SQLXML component. In particular, we will look into a non-programmatic way of publishing SQL Server 2000 stored procedures, user-defined functions and XML
....Read More |
| Rating
|
|
|
|
Troubleshooting SQL Server Alerts
|
| Total Hit (1091) |
If you have problems with Microsoft SQL Server alerts, review this troubleshooting checklist to find potential solutions.
|
| Rating
|
|
|
|
|
|
Troubleshooting SQL Server Jobs
|
| Total Hit (681) |
If you have problems with SQL Server jobs, review this troubleshooting checklist to find potential solutions.
|
| Rating
|
|
|
|
SQL Server 2000 DTS Part 5 - DTS Designer Tasks and Global Variables
|
| Total Hit (1985) |
In the previous article of this series, we covered types of DTS Designer tasks that are more straightforward. We will continue this discussion here, focusing on ones that are more complex. However, before we proceed, we will look into the concept of DTS Global Variables, which will help us understan
....Read More |
| Rating
|
|
|
|
MDX Essentials: Basic Set Functions: The Intersect() Function
|
| Total Hit (769) |
This is the fourteenth article of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs.
....Read More |
| Rating
|
|
|
|
Linked Severs on MS SQL Part 3
|
| Total Hit (1017) |
In Parts 1 and 2, we introduced the Linked Server. Starting with what a Linked Server is, the benefits to using them, as well as when to avoid them. The Distributed Transaction Coordinator, DTC, was touched on. In addition, our first examples were to create links to an Excel spreadsheet, during whic
....Read More |
| Rating
|
|
|
|
|
|
Configuring Disks and Managing Space in SQL Server Part 1
|
| Total Hit (944) |
Something like fifty percent of system outages are caused by "Out of space" conditions. I kid you not. I run into them all the time. Combine this problem with the need to maintain high availability and peak performance and the consequence is that disk configuration and space allocation become one of
....Read More |
| Rating
|
|
|
|
SQL Server 2000 DTS Part 4 - DTS Designer Tasks
|
| Total Hit (1927) |
In the previous article of our series dedicated to SQL Server 2000 Data Transformation Services, we covered the first of the essential elements of a package - connection. Now it is time to look into another critical component - task - that is responsible for the processing of data retrieved through
....Read More |
| Rating
|
|
|
|
Troubleshooting SQL Mail
|
| Total Hit (745) |
If you have problems with SQL Mail, review this 20-point troubleshooting checklist to find potential solutions.
|
| Rating
|
|
|
|
|
|
|
|
|
|
Application Design Optimization Tips
|
| Total Hit (1019) |
Here are fifteen tips that you can use to ensure your Application Designs are performing in the most efficient manner possible.
|
| Rating
|
|
|
|
SQL Server 2000 DTS Part 3 - DTS Designer Connections
|
| Total Hit (1960) |
In our previous article of this series, we presented a way of creating DTS packages with wizards. Despite its simplicity, this approach has some limitations, which you can overcome in two ways - by using DTS Designer or by manipulating DTS object model with programming languages, such as Visual Basi
....Read More |
| Rating
|
|
|
|
MDX Essentials: Basic Set Functions: The Union() Function
|
| Total Hit (744) |
This is the thirteenth article of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs.
....Read More |
| Rating
|
|
|
|
Linked Servers on MS SQL Part 2
|
| Total Hit (977) |
In Part 1 of this series, we reviewed the purpose and reasons for using linked servers, as well as when not to use them. The first linked server created was to an Excel sheet containing data from the Authors table of the SQL Pubs database. We will now move on to other data sources and security.
....Read More |
| Rating
|
|
|
|
T-SQL Programming Part 2 - Building a T-SQL Loop
|
| Total Hit (975) |
This is the second article in my T-SQL programming series. This article will discuss building a program loop using T-SQL. In addition to talking about building a loop, I will also discuss ways of controlling the loop processing, and different methods to break out of a loop.
....Read More |
| Rating
|
|
|
|
Implementing CRUD Operations Using Stored Procedures: Part 2
|
| Total Hit (547) |
In database terms, CRUD stands for the four essential database operations: Create, Read, Update and Delete. To create a high performance system, these four operations should be implemented by stored procedures, each procedure implementing one of the four operations. This is the second in a two part
....Read More |
| Rating
|
|
|
|
|
|
SQL Server 2000 DTS Part 2 - Creating DTS Packages using Wizards
|
| Total Hit (2032) |
As we explained in the first article of this series, there are three methods of creating DTS packages - with DTS Designer graphical interface, with programming by directly using the DTS object model, or with wizards available from the SQL Server Enterprise Manager interface. We will focus here on th
....Read More |
| Rating
|
|
|
|
|
|
|
|
T-SQL Programming Part 1 - Defining Variables, and IF...ELSE logic
|
| Total Hit (513) |
This is the first of a series of articles discussing various aspects of T-SQL programming. Whether you are building a stored procedure or writing a small Query Analyzer script you will need to know the basics of T-SQL programming. This first article will discuss defining variables, and using the IF.
....Read More |
| Rating
|
|
|
|
MDX Essentials: Basic Set Functions: The Order() Function
|
| Total Hit (961) |
This is the twelfth article of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs.
....Read More |
| Rating
|
|