|
|
|
|
 |
Reporting Options for Analysis Services Cubes: MS FrontPage 2002
|
| Total Hit (1659) |
This is the eleventh 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 des
....Read More |
Rating
 |
|
|
|
Scheduled Task Reporting on SQL Server
|
| Total Hit (621) |
If you have a server with a large number of scheduled tasks, you will know that keeping track of them all can be a bit difficult at times - checking and double-checking that your database backups and log backups are in synch, that maintenance tasks go off in the correct order, and that tasks do not
....Read More |
| Rating
|
|
|
|
Dealing with MS SQL Tables that contain Duplicate Rows
|
| Total Hit (706) |
Every so often, you might have to deal with tables that contain duplicate rows. In one case, you might only need to identify the duplicate rows. In other cases, you might need to remove the duplicate rows. This article will show you some different techniques for dealing with duplicate rows.
....Read More |
| Rating
|
|
|
|
Backing Up and Restoring SQL Server Databases and Transaction Logs
|
| Total Hit (1132) |
The backing up and restoring of databases and transaction logs is a way that SQL Server provides to protect from data loss. The backup operation creates a copy of a database. This copy can be used to restore the database if media failure occurs or if the database is somehow damaged (for example, fro
....Read More |
| Rating
|
|
|
|
|
|
XML and SQL 2000 (Part 6)
|
| Total Hit (1202) |
In the previous article, I explained the meaning of the "Allow posted updategrams" and "Allow template queries" options on the Settings tab of the Virtual Directory Properties dialog box in IIS Virtual Directory Management for SQL Server tool. I also presented examples of taking advantage of these o
....Read More |
| Rating
|
|
|
|
Migrating Logins from One SQL Server to Another
|
| Total Hit (1089) |
As part of the normal work, a Database Administrator (DBA) will be required to migrate databases between servers. One of the reasons for a migration might be that you are moving an application from a quality assurance (QA) environment to a production environment. Another reason might be your current
....Read More |
| Rating
|
|
|
|
XML and SQL 2000 (Part 5)
|
| Total Hit (1056) |
In this article, we will continue exploring different ways of accessing SQL Server data in the XML format via HTTP. As we explained in the previous article, this type of functionality becomes available after creating a virtual directory corresponding to the target database using IIS Virtual Director
....Read More |
| Rating
|
|
|
|
Attaching and Detaching Databases on SQL Server
|
| Total Hit (929) |
If you need to move a database, or database file to another server or disk, and you do not want to backup the database, copy the backup on another server, and then re-create the database from the backup, you can use the sp_detach_db and sp_attach_db system stored procedures to detach the database an
....Read More |
| Rating
|
|
|
|
MDX in Analysis Services: Retrieve Data from Multiple Cubes
|
| Total Hit (876) |
This is the fourth 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
|
|
|
|
Export a Table to a Date Stamped File Name in SQL Server
|
| Total Hit (1135) |
Date stamping is a very common requirement in the IT industry for any data extract created. Through the DTS package with ActiveX script, it is very easy to date stamp a file. In this article, I am going to walk you through how to export a table to a date stamped file.
....Read More |
| Rating
|
|
|
|
Padding, Rounding, Truncating and Removing Trailing Zeroes
|
| Total Hit (624) |
In this article, I am going to show you a number of tips for displaying numeric fields as strings. I will show you how to pad zeroes on the left side of numeric numbers, so that each number regardless of the size will be the same length. Also along those same lines below you will find out how to pad
....Read More |
| Rating
|
|
|
|
Reporting Options for Analysis Services Cubes: Cognos PowerPlay
|
| Total Hit (3304) |
This is the twelfth article of the series, Introduction to MSSQL Server 2000 Analysis Services. As I stated in the first article, «a href="http://www.databasejournal.com/features/mssql/article.php/1429671"»Creating Our First Cube«/a», the primary focus of this series is an introduction to the practi
....Read More |
| Rating
|
|
|
|
SQL Server Security Checklist
|
| Total Hit (2561) |
This month we are going to look at the subject of security. The article is not an in depth tutorial, and is in no way comprehensive. Instead, what I have tried to do is to simply highlight some of the areas where many people (myself included) commonly leave gaps in their security.
....Read More |
| Rating
|
|
|
|
Using Microsoft SQL Server Constraints
|
| Total Hit (1256) |
In this article, I want to tell you about SQL Server constraints: what a constraint is, when it is used and for which purposes. You can find in this article some examples of constraint creation and SQL Server 2000 constraints enhancements.
|
| Rating
|
|
|
|
XML and SQL 2000 (Part 4)
|
| Total Hit (1148) |
In the fourth article of the series dealing with XML related features of SQL Server 2000, I will discuss the implications of various configuration options available when using IIS Virtual Directory Management for SQL Server. As described previously, the Settings tab of the Virtual Directory Properti
....Read More |
| Rating
|
|
|
|
Minimizing SQL Server Stored Procedure Recompiles
|
| Total Hit (701) |
This article discusses the reasons that SQL Server 2000 decides to recompile a stored procedure and demonstrates techniques that can be used to minimize recompilation. If your system makes extensive use of stored procedures, minimizing recompilation can give you a nice boost in performance.
....Read More |
| Rating
|
|
|
|
|
|
MDX Essentials: MDX Member Functions: "Relative" Member Functions
|
| Total Hit (720) |
This is the eighth 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 design
....Read More |
| Rating
|
|
|
|
Choosing SQL Server 2000 Data Types
|
| Total Hit (999) |
Choosing an appropriate data type is very important, because the errors made in a table design can result in large performance degradation. These problems often surface later, when a large amount of data is inserted. In this article, I want to tell you about built-in and user-defined data types, how
....Read More |
| Rating
|
|
|
|
MDX in Analysis Services: Intermediate Concepts - Part 2
|
| Total Hit (914) |
This is the third 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
|
|
|
|
XML and SQL 2000 (Part 3)
|
| Total Hit (1079) |
In the third article of this series, we will look into executing T-SQL statements against SQL Server 2000 via HTTP. This functionality is provided by SQLXML component (implemented in the form of SQLISAPI.DLL, which is included as part of SQL Server 2000 installation). The updated versions of this co
....Read More |
| Rating
|
|
|
|
|
|
MDX Member Functions: The Cousin () Function
|
| Total Hit (680) |
This is the seventh 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 desig
....Read More |
| Rating
|
|
|
|
Generate Scripts for SQL Server Objects
|
| Total Hit (2545) |
We all like the Generate Script feature of Enterprise Manager and like to use it programmatically. One of the most important uses would be backing up scripts periodically using SQL Server Scheduler.
|
| Rating
|
|
|
|
Backup Table Data in SQL Server 7.0 and 2000
|
| Total Hit (1987) |
With SQL Server 6.5, Microsoft gave us an opportunity to do a backup (DUMP Table) of the tables. However, after 6.5, with both 7.0 and 2000, that feature has been removed for some reason. Here is a stored procedure that I wrote which gives similar functionality for backing up table data. This is ver
....Read More |
| Rating
|
|
|
|
A Comparison of SQL Server 2000 with Access 2000
|
| Total Hit (1015) |
Often people in newsgroups ask about some comparison of Microsoft SQL Server and Microsoft Access. In this article, I compare Microsoft SQL Server 2000 with Microsoft Access 2000 regarding hardware and software requirements, price, features and products limits.
....Read More |
| Rating
|
|
|
|
XML and SQL 2000 (Part 2)
|
| Total Hit (1749) |
In the first article of the series, I explained the ways of presenting relational data in XML format using the FOR XML clause of the T-SQL SELECT statement. Now it is time to look into the reverse process of inserting XML formatted data into SQL databases using OpenXML function.
....Read More |
| Rating
|
|