 |
Correct installation of Server service on Windows NT4 for SQL
|
| Total Hit (2688) |
It is especially important to correctly set Windows NT4's Server service in "Application Server" mode to ensure that the Server service doesn't absorb all the available hardware resources while providing network services for file management. As its name suggests, when in "Application Server" mode, r
....Read More |
Rating
 |
|
|
|
|
|
|
|
Send fax from SQL Server using Microsoft Word
|
| Total Hit (9837) |
This article explains how you can create a Microsoft Word document from T-SQL and fax it through a method exposed by its Automation object model.
You can create and destroy OLE Automation object using the sp_OACreate and sp_OADestroy, whereas you can use the sp_OAMethod to invoke a method, and t
....Read More |
| Rating
|
|
|
|
Index Optimization Tips
|
| Total Hit (2963) |
«B»General concepts«/B»
In this article, I want to show how you can improve the speed of your queries by choosing the proper indexes, what kinds of indexes MS SQL supports and what is the advantage and disadvantage of using indexes in particular situation.
There are clustered and nonclustere
....Read More |
Rating
 |
|
|
|
Flight Schedule Ordering problem.
|
| Total Hit (1693) |
A flight schedule ordering problem. This demonstrates the powerful derived table feature. More details regarding the problem is in the link.
|
| Rating
|
|
|
|
|
|
|
|
|
|
How to write a trigger for INSERT, UPDATE or DELETE operation ?
|
| Total Hit (2335) |
Here is very basic code to write trigger for INSERT, UPDATE or DELETE operation on a table. Internally SQL Server manages two tables (inserted and deleted) to perform trigger operations.
All inserted records can be retrived by quering "inserted" table
«code LangId=6»select * from inserted«/cod
....Read More |
Rating
 |
|
|
|
UDF in CHECK & DEFAULT CONSTRAINTS.
|
| Total Hit (3264) |
User-defined functions in SQL2000 provide a powerful way to reuse code / logic. This example shows how you can use UDFs in CHECK & DEFAULT constraints of a table.
|
| Rating
|
|
|
|
|
|
Getting the second recent date from a set of values.
|
| Total Hit (1810) |
ANSI & T-SQL specific solutions for getting the 2nd recent date from a set of values. This can be extended to answer nth date from a set of values but the ANSI version gets unwieldy & has to be modified for bigger values.
|
| Rating
|
|
|
|
Import all files in a directory using DTS (Multi Pkg)
|
| Total Hit (2238) |
This example shows how you can use two DTS packages to control the import of all files in a given directory. For this, it is assumed that all files have the same format, and that all files are imported into the same table.
|
| 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
|
|
|
|
|
|
XML and SQL 2000 (Part 8)
|
| Total Hit (1058) |
So far, this series has concentrated on configuration options available via the graphical interface of IIS Virtual Directory Management for SQL Server. However, newer versions of SQLXML, in addition to the features we have already covered, provide another type of functionality, accessible through sc
....Read More |
| Rating
|
|
|
|
Working with files and the FileSystemObject
|
| Total Hit (1110) |
The ability to work with files gives us great flexibility in how we use DTS. It allows us to add some intelligence into a package, and cope with unexpected situations automatically. The key to working with files is the Scripting Run Time as this gives us the FileSystemObject, which can be fully expl
....Read More |
| Rating
|
|
|
|
MDX in Analysis Services: Calculated Members: Introduction
|
| Total Hit (767) |
This is the seventh 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 ("Analysis Services,"); our primary focus is the manipulation of multidimension
....Read More |
| Rating
|
|
|
|
Working with COM Objects from within T-SQL
|
| Total Hit (2220) |
In this article I want to tell you about how you can work with COM objects from within Transact SQL. You can use OLE Automation Stored Procedures (extended stored procedures with sp_OA prefix) to create a COM object in T-SQL and use that object's methods and properties.
Introduction
General co
....Read More |
| Rating
|
|
|
|
Tutorial : Importing A Text File Using The DTS Wizard
|
| Total Hit (686) |
This tutorial came about from watching the Newsgroups and realising that although people had heard of DTS they were unsure as to what it is and where to find it. We wanted to explain DTS to people and give them an understanding of what it does so they can go away and use it themselves.
....Read More |
| 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
|
|
|
|
SQL Server 2005 Full-Text Search: Internals and Enhancements
|
| Total Hit (989) |
The full-text search feature of Microsoft SQL Server 2005 delivers enterprise search functionality integrated into the database. Significant enhancements in the areas of performance, manageability, and functionality deliver best-of-breed search capabilities for applications of any size.
This pap
....Read More |
| Rating
|
|
|
|
Get More Out of SQL Server Reporting Services Charts
|
| Total Hit (4144) |
This white paper presents general information, best practices, and tips for designing charts within Microsoft SQL Server Reporting Services reports. It provides an overview of some Reporting Services features, answers common chart design and feature questions, and includes advanced examples of how t
....Read More |
| Rating
|
|
|
|
|
|
|
|
Data Extraction, Transformation, and Loading Techniques
|
| Total Hit (2291) |
Chapter 17, "Data Warehouse Design Considerations," discussed the use of dimensional modeling to design databases for data warehousing. In contrast to the complex, highly normalized, entity-relationship schemas of online transaction processing (OLTP) databases, data warehouse schemas are simple and
....Read More |
| Rating
|
|
|
|
SQL Server 2000 DTS Part 6 - DTS Designer Tasks and Package Workflow
|
| Total Hit (2081) |
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
|
|
|
|
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
|
|