Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Articles & Samples > SQL Server > Migration to SQL Server 2000


Search:
What's New - What's Hot
Pagination and Sorting in MS SQL Server 2000  Version: 0.00     Price: $0.00  
Total Hits: 38  |  Today: 0Author: Dima Kostikov      Rating:  
Read Reviews | Write Review |  Your Rating: 

Sometimes while building an application (especially web-application) we need to have an opportunity to paginate through the data and to sort it. But we want the database to do all this stuff and we want to have one sproc that would return a part of data we need for the selected page and also this data should be sorted. I was trying to find related articles in the internet but most of them offered using dynamic queries. So I have built my own stored procedure....

Creating a linked Postgres Server on SQL Server 2008     
Total Hits: 43  |  Today: 0Author: Jayaram Krishnaswamy      Rating:  
Read Reviews | Write Review |  Your Rating: 

In situations where you need access to remote servers or, run queries on servers which are distributed linking servers provides a good solution. This article explains how to set up a Postgres linked server on SQL Server 2008. Querying a table on the linked server is also described. Configuring the linked server to support remote procedural calls that enables executing queries on the linked server is also described with an example....

Comparing Multiple SQL Server Datasets with the INTERSECT and EXCEPT operators     
Total Hits: 171  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

When joining multiple datasets you have always had the ability to use the UNION and UNION ALL operator to allow you to pull a distinct result set (union) or a complete result set (union all). These are very helpful commands when you need to pull data from different tables and show the results as one unified distinct result set. On the opposite side of this it would be helpful to only show a result set where both sets of data match or only where data exists in one of the tables and not the othe...

Transaction Isolation Level     
Total Hits: 58  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, I want to tell you about Transaction Isolation Level in SQL Server 6.5 and SQL Server 7.0, what kinds of Transaction Isolation Level exist, and how you can set the appropriate Transaction Isolation Level.

There are four isolation levels:

# READ UNCOMMITTED
# READ COMMITTED
# REPEATABLE READ
# SERIALIZABLE...

The ExecuteSQL Task     
Total Hits: 119  |  Today: 0Author: Konesans Ltd      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article we are going to take you through the ExecuteSQL task in SQL Server Integration Services for SQL Server 2005. We will be covering all the essentials that you will need to know to effectively use this task and make it as flexible as possible. The things we will be looking at are as follows:

* A tour of the Task.

* The properties of the Task....

Migrating From MS Access To MySQL     
Total Hits: 48  |  Today: 0Author: Christopher Keene      Rating:  
Read Reviews | Write Review |  Your Rating: 

According to recent survey, over 20% of MySQL users plan to migrate a Microsoft Access applications to MySQL over the next 12 months. However there are few documents available that describe best practices for performing such a migration.
This document summarizes discussion from the “MS Access Migration” session at the 2007 MySQL User Group meeting in California. That session brought together a number of MySQL users with a goal of identifying key success factors for moving MS Access applicatio...

Working with SQL Server     
Total Hits: 179  |  Today: 0Author: Ben Forta      Rating:  
Read Reviews | Write Review |  Your Rating: 

Now that you have a SQL Server DBMS and client software to use with it, it would be worthwhile to briefly discuss connecting to the database.
SQL Server, like all client/server DBMSs, requires that you log into the DBMS before being able to issue commands. SQL Server can authenticate users and logins using its own user list, or using the Windows user list (the logins used to start using Windows). As such, depending on how SQL Server is configured, it may log you in automatically using whateve...

How to Search for Date and Time Values Using SQL Server 2000     
Total Hits: 211  |  Today: 0Author: Bryan Syverson      Rating:  
Read Reviews | Write Review |  Your Rating: 

Before you can effectively query date/time (or temporal) data, you have to know something about how date/time values are stored. In this article, Bryan demonstrates the various ways in which to query an SQL Server to successfully retrieve the records you may be seeking....

Moving a Database from SQL Server 7.0 to SQL Server 2000     
Total Hits: 406  |  Today: 0Author: 15Seconds      Rating:  
Read Reviews | Write Review |  Your Rating: 

Moving or copying a SQL Server database from one machine to another requires a lot of preparation in order to ensure a smooth transfer. When moving from SQL Server 7.0 to SQL Server 2000....

Some Useful Undocumented SQL Server 2000 Trace Flags  Version: 0.00     Price: $0.00  
Total Hits: 9  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, I want to tell you what should you know about some undocumented SQL Server 2000 trace flags, and how you can use them for administration and monitoring of SQL Server 2000....

Tuning SQL Server 2005 Integration Services for EBCDIC Data Conversion  Version: 0.00     Price: $0.00  
Total Hits: 10  |  Today: 0Author: Jeff Singleton      Rating:  
Read Reviews | Write Review |  Your Rating: 

When searching the Web for solutions to use SQL Server 2005’s Integration Services to convert and load EBCDIC (IBM Mainframe) data, many will hit a massive roadblock. Through exhaustive searches you may be able to return a minimal amount of information, none of which will likely pertain to performance tuning once a conversion solution is in place....

Building Integrated SQL Server Business Intelligence (BI) Solutions with Microsoft Office 2007     
Total Hits: 147  |  Today: 0Author: Ray Barley      Rating:  
Read Reviews | Write Review |  Your Rating: 

I am trying to understand the BI capabilities built in to the various components of Microsoft Office 2007 and figure out how to leverage them to create BI solutions for our business users. Can you provide an overview of the capabilities? As a starting point let's assume that you have a data warehouse built on SQL Server 2005 or SQL Server 2008 including some SQL Server Analysis Services (SSAS) cubes. We'll frame our discussion of the BI capabilities in Microsoft Office 2007 with the following ...

Web Development with Visual Web Developer 2005 Express Edition and SQL Server 2005 Express Edition, Part 1     
Total Hits: 90  |  Today: 0Author: Dan Burman      Rating:  
Read Reviews | Write Review |  Your Rating: 

Part 1 of a three-part series on creating Web applications with Visual Web Developer 2005 Express Edition and SQL Server Express covers setting up a project and creating a SQL Server Express database, and explores the use of the ASP.NET Web Site Administration tool to set up roles, users, and providers. It also covers utilizing security controls such as Login, LoginStatus, LoginView, CreateUserWizard, PasswordRecovery, and ChangePassword....

Threat Profiling Microsoft SQL Server (A Guide to Security Auditing)     
Total Hits: 114  |  Today: 0Author: David Litchfield      Rating:  
Read Reviews | Write Review |  Your Rating: 


This paper is written from the perspective of an attacker and shows typical "cursi incursi" for Microsoft SQL Server....

Where To Find Integration Services Packages in SQL Server     
Total Hits: 115  |  Today: 0Author: Konesans Ltd      Rating:  
Read Reviews | Write Review |  Your Rating: 

We see this coming up quite a bit on newsgroups and even have people eMailing about it so we though we would put up an article explaining where to find packages when saved to SQL Server.

If you want to view them visually in SQL Server Management Studio then you will need to connect to the Integration Services Service for the Server on which you have stored the packages....

SQL Server 2000 vs Oracle 9i     
Total Hits: 78  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

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....

SQL Server 2000 vs Sybase ASE 12.5     
Total Hits: 65  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

Often people in newsgroups ask about some comparison of Microsoft SQL Server and Sybase Adaptive Server. In this article, I compare SQL Server 2000 with Sybase Adaptive Server Enterprise 12.5 (Sybase ASE 12.5) regarding price, performance, platforms supported, SQL dialects and products limits....

SQL Server 2000 vs Access 2000     
Total Hits: 78  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

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....

SQL Server 2000: Some useful trace flags     
Total Hits: 64  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, I want to tell you, what should you know about trace flags, and how you can use some useful trace flags in SQL Server 2000 for administering and monitoring.

Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. You can set trace flags by using DBCC TRACEON command or by using the -T option with the sqlservr command- line executable. After activated, trace flag will be in effect until you restart server, or until yo...

Microsoft SQL Server Nested-Loop Joins     
Total Hits: 60  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server 7.0/2000 supports three types of join operations:

# Nested-Loop joins
# Merge joins
# Hash joins


In this article, I want to tell you about Nested-Loop joins, what kinds of Nested-Loop joins exist, and when SQL Server uses this kind of join operation.

If you join two tables, and SQL Server optimizer choose Nested-Loop join, then one table will be selected as outer table and the other as inner table. SQL Server will scan the outer table row by ro...


1  2  3  4  5  Next >> 


Disclaimer - Privacy
© 2002-2017 DevASP.net