|
|
|
|
|
|
|
|
|
|
|
|
 |
DTS Servers and Schedulers for MS SQL
|
| Total Hit (2093) |
Learn the basics of creating a DTS server, including how to change the DTS package according to batch schedulers used and the steps required to create and schedule jobs in Autosys and Smartbatch.
|
Rating
 |
|
|
|
|
|
|
|
|
|
Monitor Event Viewer on Multiple SQL Servers
|
| Total Hit (695) |
Muthusamy Anantha Kumar discusses three methods to monitor SQL Server Event Log on a list of servers and store the output either in a .CSV file or on a database table.
|
| Rating
|
|
|
|
SQL Server 2000 DTS Part 9 - DTS Designer Tasks
|
| Total Hit (1906) |
The last installment of this series discussed the basic principles and applications of the Transform Data task. This article continues, focusing on its more advanced features.
|
| Rating
|
|
|
|
MDX Essentials: Basic Set Functions: The Filter() Function
|
| Total Hit (1083) |
This is the sixteenth 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
|
|
|
|
Getting the Wrong Identity in Microsoft SQL Server identity Columns?
|
| Total Hit (572) |
An Identity column is used in SQL server to create a surrogate key value for a table. This will be a unique identifier usually in sequential order. Starting at some predefined number, the Identity column increments every time a new record is added to the table. For MS Access users, this is comparabl
....Read More |
| Rating
|
|
|
|
Benchmarking Performance of a Query - Part 2 CPU and I/O
|
| Total Hit (2103) |
This is the second article in a series discussing benchmarking T-SQL query performance. The first article in this series discussed different methods of capturing the elapsed time of a T-SQL batch, pieces of a batch, or a single T-SQL statement. This article will discuss how to determine the amount o
....Read More |
| Rating
|
|
|
|
|
|
|
|
SQL Server and Collation
|
| Total Hit (505) |
Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types and character width.
....Read More |
| Rating
|
|
|
|
|
|
|
|
Benchmarking Performance of a Query - Part 1 Elapsed Time
|
| Total Hit (900) |
How many times have you had more than one way to do something and wanted to determine which method was faster and/or which one used more resources? I am going to guess that most developers have run across this dilemma more than once. So how do you decide with method is faster--or which method requir
....Read More |
| Rating
|
|
|
|
Cubes: ProClarity Professional, Part I
|
| Total Hit (1186) |
This is the nineteenth 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, manipulation and use of multidimensional OLAP cubes. The series
....Read More |
| Rating
|
|
|
|
Monitor Disk Space on Multiple SQL Servers
|
| Total Hit (617) |
In the typical IT department, an un-avoidable task is to monitor the disk space on all drives on certain servers. In addition, the methods presented here will help in monitoring the growth of files. In this article, I am going to discuss three different ways to monitor disk space on a list of server
....Read More |
| Rating
|
|
|
|
|
|
MDX Essentials: Basic Set Functions: The EXCEPT() Function
|
| Total Hit (775) |
This is the fifteenth 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
|
|
|
|
T-SQL Programming Part 5 - Using the CASE Function
|
| Total Hit (561) |
The CASE function is a very useful T-SQL function. With this function you can replace a column value with a different value based on the original column value. An example of where this function might come in handy is where you have a table that contains a column named SexCode, where 0 stands for fem
....Read More |
| Rating
|
|
|
|
Linked Severs on MS SQL Part 4, Oracle
|
| Total Hit (2317) |
In previous articles, we created Linked Servers to Excel, Access and MS SQL. Several stored procedures were introduced for creating links, and the security profiles that accompany them. For this article, sp_AddLinkedServer and sp_AddLinkedSrvLogin should be familiar. Several different access methods
....Read More |
| Rating
|
|
|
|
Control your SQL Server 7.0 and 2000 via E-Mail
|
| Total Hit (908) |
Data Base Administrators are often exposed to a situation where they want to query a table, check on the status of a server, check an error log or run a DBCC command on a SQL Server box when they do not have access to the box directly. This often happens when they are off site or on vacation or they
....Read More |
| Rating
|
|
|
|
SQL Server 2000 DTS Part 6 - DTS Designer Tasks and Package Workflow
|
| Total Hit (2083) |
As we indicated in our previous article, we are going to continue discussing various ways of utilizing global variables in DTS Designer tasks. In particular, we will look into their role in exchanging data between packages, using features built into the Execute Package task. As part of this discussi
....Read More |
| Rating
|
|
|
|
"File Watcher" for SQL Server
|
| Total Hit (1257) |
SQL Server Database administrators often come across situations where the scheduled DTS jobs failed because the Source File didn't arrive on time. It is a tedious process to cleanup if there are dependent jobs that have run before the first DTS job completed successfully. The intent of this article
....Read More |
| Rating
|
|