|
|
 |
How to change owner of DTS Package
|
| Total Hit (2749) |
Here is an example to change ownership of a DTS Package of SQL Server. You can use undocumented stored procedure msdb.dbo.sp_reassign_dtspackageowner to change ownership. This stored proc requires 3 parameters. First parameter is @name which is name of package. Second parameter is @id which unique I
....Read More |
Rating
 |
|
|
|
|
|
|
|
How to implement nested transactions
|
| Total Hit (4238) |
SQL Server allows you to nest transactions. Basically, this feature means that a new transaction can start even though the previous one is not complete. Transact-SQL allows you to nest transaction operations by issuing nested BEGIN TRAN commands. The @@TRANCOUNT automatic variable can be queried to
....Read More |
Rating
 |
|
|
|
|
|
Getting the second recent date from a set of values.
|
| Total Hit (1814) |
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
|
|
|
|
Script - Update Blank Values of Group until Next group starts
|
| Total Hit (2643) |
Recently I came across simple scenario where I had to update some blank values of certain records. Here is what i mean
Assume you have two columns. You want to update Order# column with same order number until next group starts (e.g. ID 2,3 update with Order# => 1000).
ID Order#
1 1000
2
....Read More |
| Rating
|
|
|
|
|
|
Import all files in a directory using DTS (Multi Pkg)
|
| Total Hit (2240) |
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
|
|
|
|
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
|
|
|
|
Dealing with a SQL Server Cluster Failover
|
| Total Hit (541) |
I had just gotten out of a short meeting and went to my desk to see what important e-mail messages I might had missed. In my inbox was a series of messages sent from ELM Enterprise Manager 3.0, the software we use to monitor our SQL Server event logs. The message had arrived about 30 minutes earlier
....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
|
|
|
|
How to loop through a global variable Rowset
|
| Total Hit (843) |
The Execute SQL Task for SQL Server 2000 allows both input and parameters to be specified. In this article we will be focusing on the Rowset output parameter functionality, and what we can then do with the Recordset it returns. The Rowset parameter takes the result set of a SELECT statement and stor
....Read More |
| Rating
|
|
|
|
Implementing CRUD Operations Using Stored Procedures: Part 1
|
| Total Hit (759) |
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
|
|
|
|
|
|
|
|
MDX Essentials: Basic Set Functions: The Union() Function
|
| Total Hit (746) |
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
|
|
|
|
Make the Execute Package Task name dependent only
|
| Total Hit (756) |
By default the Execute Package Task will use the PackageID (GUID) to load and execute a package. The PackageID is assigned when you save a new package. A simple illustration of this is to open a package and then use Save As, giving the package a new name. If you where to replace the target or child
....Read More |
| Rating
|
|
|
|
XML for Analysis (XMLA) Specification
|
| Total Hit (972) |
Specifies a SOAP-based XML communication API that supports the exchange of analytical data between clients and servers on any platform and with any language.
|
| Rating
|
|
|
|
|
|
Backup and Recovery
|
| Total Hit (2630) |
You should back up your databases and transaction logs on a regular basis. In case of system problems, you can restore the backed up files and return to work more quickly than if you had neglected to back up your database. Additionally, every time Microsoft SQL Server starts, recovery is performed o
....Read More |
| Rating
|
|
|
|
Comparing Oracle 10g and SQL Server Yukon
|
| Total Hit (1221) |
The purpose of the following technical paper from WisdomForce is to provide a feature comparison between MSSQL 2005 (Yukon) and Oracle 10g.
The document compares VLDB/OLTP related features and discuss issues with performance, utilities and replication. It discusses several new features, which we
....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
|
|
|
|
Data Warehousing for Cavemen
|
| Total Hit (2017) |
This document is intended to make you buzzword-compliant with the MIS world. In terms simple enough even for an MIT computer science Ph.D. to understand, I'm going to explain OLTP, data warehousing, and OLAP. Kiss that ghetto post-doc goodbye and watch big companies line up to pay you $300/hour to r
....Read More |
| Rating
|
|
|
|
How Do I Develop a Backup and Restore Strategy?
|
| Total Hit (1036) |
One of the most critical aspects of administering SQL Server is the Backup and Restore or Disaster Recovery strategy. Frequent questions in this forum indicate a general lack of knowledge and planning for backup and restore operations.
|
| Rating
|
|
|
|
MDX in Analysis Services: Measuring Change over Time
|
| Total Hit (773) |
This is the fifth 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 multidimensional
....Read More |
| Rating
|
|
|
|
Using SQL Server Cursors
|
| Total Hit (937) |
In this article, I want to tell you how to create and use server side cursors and how you can optimize a cursor performance.
Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows in t
....Read More |
| Rating
|
|
|
|
The comparison of SQL Server 2000 with Oracle 9i
|
| Total Hit (930) |
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
|
|
|
|
XML, T-SQL, and the CLR Create a New World of Database Programming
|
| Total Hit (976) |
The next version of SQL Server, code-named "Yukon," includes quite a few enhancements and expanded language support. For example, Transact-SQL now conforms more closely to the ANSI-99 SQL specification and makes querying more flexible and expressive. Yukon can execute user-defined functions, stored
....Read More |
| Rating
|
|