|
|
|
52. Microsoft SQL Server 2000 Resource Kit: Chapter 2 - New Features in SQL Server 2000
|
|
Microsoft SQL Server 2000 extends the performance, reliability, quality, and ease-of-use of Microsoft SQL Server version 7.0. Microsoft SQL Server 2000 includes several new features that make it an excellent database platform for large-scale online transactional processing (OLTP), data warehousing, and e-commerce applications.
|
|
Posted On : November 23, 2004
|
More...
|
Author : Microsoft
|
|
|
|
51. LockwoodTech Software Offers SQLDiff to Compare and Synchronize SQL Server Databases
|
|
If you are in anyway involved in database development, you will invariably run into instances where you need to compare two similar databases and find out how they are different (both database objects or data stored in tables). This is especially the case if you don't use change management software and there are two or more developers writing and modifying database design, code, or test data. Along this same line, if you do find differences between two databases' objects, sometimes you have the need to synchronize the two databases so that they are the same.
|
|
Posted On : November 23, 2004
|
More...
|
Author : Brad M. McGehee
|
|
|
|
|
|
49. Reinstalling SQL Server on a Failed Node
|
|
SQL Server 2000 Enterprise Edition installs SQL Server executables and program files on both of my clustered servers simultaneously. If one of my servers goes down, how can I rebuild the server and reinstall SQL Server on that node?
|
|
Posted On : November 23, 2004
|
More...
|
Author : Microsoft
|
|
|
|
48. BLOB Access Technologies
|
|
By Michael Otey - Microsoft provides several tools for working with BLOB objects. Here are seven of the most important BLOB access technologies.
|
|
Posted On : November 23, 2004
|
More...
|
Author : Michael Otey
|
|
|
|
47. All About Nothing
|
|
By Russ Whitney - OLAP cubes are notorious for having lots of empty (or null) cells. Including these empty cells in your result sets can bog down your analysis applications. But you can use these tricks to eliminate empties.
|
|
Posted On : November 23, 2004
|
More...
|
Author : Russ Whitney
|
|
|
|
46. Reinstalling SQL Server on a Failed Node
|
|
SQL Server 2000 Enterprise Edition installs SQL Server executables and program files on both of my clustered servers simultaneously. If one of my servers goes down, how can I rebuild the server and reinstall SQL Server on that node?
|
|
Posted On : May 8, 2004
|
More...
|
Author : Microsoft
|
|
|
|
|
|
|
|
43. LockwoodTech Software Offers SQLDiff to Compare and Synchronize SQL Server Databases
|
|
If you are in anyway involved in database development, you will invariably run into instances where you need to compare two similar databases and find out how they are different (both database objects or data stored in tables). This is especially the case if you dont use change management software and there are two or more developers writing and modifying database design, code, or test data. Along this same line, if you do find differences between two databases objects, sometimes you have the need to synchronize the two databases so that they are the same.
|
|
Posted On : May 8, 2004
|
More...
|
Author : Brad M. McGehee
|
|
|
|
42. Reducing SQL Server Index Fragmentation
|
|
When you perform any data modification operations (INSERT, UPDATE, or DELETE statements) table fragmentation can occur. When changes are made to the data that affect the index, index fragmentation can occur and the information in the index can get scattered in the database. Fragmented data can cause SQL Server to perform unnecessary data reads, so a queries performance against a heavy fragmented table can be very poor. If you want to determine the level of fragmentation, you can use the DBCC SHOWCONTIG statement.
|
|
Posted On : May 8, 2004
|
More...
|
Author : Unknown
|
|
|
|
41. SQL Server Notification Services Developer Overview
|
|
Webcast Summary: SQL Server Notification Services is a new powerful notification application platform. The platform helps developers build centralized publish-subscribe (pub-sub) applications and deploy them on a large scale. These applications are often used to send notification messages to end-users, hence the names - notification application and Notification Services.
|
|
Posted On : Jan 03, 2004
|
More...
|
Author : Unknown
|
|
|
|
40. How to Buy SQL Server 2000
|
|
This link can help you select and purchase the right SQL Server edition for your business. Pricing and licensing information is also available.
|
|
Posted On : Jan 03, 2004
|
More...
|
Author : Microsoft Support
|
|
|
|
39. INF: How to Write a Variance Query in SQL Server
|
|
When you need to make a comparison between a value and the average for that value in the same category, you can execute a variance query. For example, you may want to use a variance query when you want to compare the salary of an employee against the salary of other employees who hold the same title, or when you want a comparison between the price of a book and the price of all the other books of the same category.
|
|
Posted On : Jan 03, 2004
|
More...
|
Author : Microsoft Support
|
|
|
|
|
|
|
|
|
|
35. HOW TO: Manually Remove a MSDE 2000 Instance
|
|
This step-by-step article describes how you manually remove a Microsoft SQL Server 2000 Desktop Engine (also known as MSDE 2000) instance. If you experience a problem when you try to remove an MSDE 2000 instance by using Add/Remove Programs in Control Panel, you can manually remove the instance instead. To manually remove MSDE 2000, follow the steps in the "More Information" section of this article
|
|
Posted On : October 30 2003
|
More...
|
Author : Microsoft Support
|
|
|
|
34. Microsoft SQL Server 7.0 Performance Tuning Guide
|
|
Provides database administrators and developers with valuable information on Microsoft SQL Server 7.0 index selection, disk I/O subsystem tuning, and SQL Server 7.0 performance tuning tools
|
|
Posted On : October 30 2003
|
More...
|
Author : Henry Lau, Microsoft
|
|
|
|
|
|
|
|
31. TOP N Clause vs. SET ROWCOUNT N
|
|
This tips and tricks section on Microsoft SQL Server site explains, Is using the TOP N clause faster than using SET ROWCOUNT N to return a specific number of rows from a query.
|
|
Posted On : October 18, 2003
|
More...
|
Author : Microsoft
|
|
|
|
30. SQL Server CE Relay
|
|
This white paper contains the instructions for setting up connectivity between Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) and SQL Server by using SQL Server CE Relay. SQL Server CE Relay is used to share data with mobile Windows CE based devices when there is no integrated network capability. SQL Server CE Relay functionality does not require a network card in the Windows CE based device because it uses a desktop computer s network connection.
|
|
Posted On : October 18, 2003
|
More...
|
Author : Microsoft Support
|
|
|
|
29. SQLISAPI and XML Client-Side Processing
|
|
XML and SQL series with a look at client-side XML processing with SQLXML 2.0 (and later). Interesting writeup. This is the Part 10 of the complete series.
|
|
Posted On : September 27, 2003
|
More...
|
Author : Marcin Policht
|
|
|
|
28. INF: SQL Server and Striped Backups
|
|
With striping, you can back up a database to different disks either to increase backup throughput or to distribute space usage across different disks. However, the files may or may not be evenly distributed.
|
|
Posted On : September 27, 2003
|
More...
|
Author : Microsoft Support
|
|
|
|
27. Migrating from Sybase to SQL Server
|
|
This article shows Sybase database administrators (DBAs) and managers the steps that should be followed to migrate from a Sybase database to an MS SQL Server 2000 database.
|
|
Posted On : September 19, 2003
|
More...
|
Author : Sayed Geneidy
|
|
|
|
|
|
25. New Features in SP3a
|
|
What are the features of the new SQL Server service pack SP3a. Read this article to find out about why this service pack is useful.
|
|
Posted On : August 26, 2003
|
More...
|
Author : SQL Server Magazine
|
|
|
|
24. Basics of Data Transformation Services (DTS)
|
|
Many organizations have various islands of data that would need to be integrated. DTS provides a set of tools that allow the consolidation and transformation of data from various sources (governed by DTS connectivity) into single or multiple destinations. This article explores the basic features of DTS and also looks a couple of sample programs.
|
|
Posted On : August 26, 2003
|
More...
|
Author : Srinivas Sampath
|
|
|
|
|
|
22. Understanding and Using SQLNS
|
|
SQL-NS is a great extension tool from Microsoft that allows applications to tap into SQL Server 2000 Enterprise Manager user interfaces. Bundled along with SQL Server 2000, SQL-NS can be used to display dialog boxes, wizards and property sheets of SQL Server Enterprise Manager through custom applications (for example, the database creation dialog box). This can provide a great deal of flexibility to applications and to users. This article looks at the basic building blocks of SQL-NS and also explores a set of samples that exemplify the features of SQL-NS.
|
|
Posted On : August 26, 2003
|
More...
|
Author : Srinivas Sampath
|
|
|
|
21. Using SQL Server Application Roles
|
|
Often applications that connect to SQL Server authenticate users by using a user-name and password. It is also an often practise that these users are created in SQL Server as logins and have varying degree of permissions on the database and its objects. Other than this default access mechanism, it might be sometimes required by your application to uniformly provide security to a set of objects for the application to all users, irrespective of the security that they inherit by virtue of logging into the application. This article looks at the usage of application roles along with some samples.
|
|
Posted On : August 26, 2003
|
More...
|
Author : Srinivas Sampath
|
|
|
|
20. DTS on the move
|
|
This article is very useful for people writing DTS packages and want to make them portable across servers. The article discusses 7 best-practices for DTS package programming.
|
|
Posted On : August 26, 2003
|
More...
|
Author : SQL Server Magazine
|
|
|
|
19. SQL Server Extended Properties
|
|
Introduced in SQL Server 2000, extended properties allow a database architect to attach information to schema objects like tables, views etc. that be used by all applications. For example, you can use extended properties to attach descriptions about tables and their columns, which can then be used to construct a data dictionary. Alternatively, you can also store display information about columns as extended properties, so that all applications using the column can display it in the same manner. This article explores how extended properties can be used and shows a small sample application too.
|
|
Posted On : August 26, 2003
|
More...
|
Author : Srinivas Sampath
|
|
|
| < > |