|
|
|
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
|
|
|
|
18. SQL Server and HTML
|
|
Often organizations have a need to generate "catalog" pages that contain information from a particular source (for example, list of products). The information in this page changes periodically and thus, the page will have to reflect these changes as and when they occur. There are many ways to generate such pages, but SQL Server gives a very cost effective solution using the sp_makewebtask procedure that allows the automation of these pages along with the ability to embed rich content. These pages can also be scheduled to be re-generated periodically and also when data changes. This article looks at how we can use this procedure.
|
|
Posted On : August 26, 2003
|
More...
|
Author : Srinivas Sampath
|
|
|
|
17. Scripting Traces for Performance Monitoring on SQL Server
|
|
This article explores the usages of the SQL Profiler to generate traces that can be customized by users and also provides various code snippets. These customized traces can then be embedded in procedures and run on demand.
|
|
Posted On : August 26, 2003
|
More...
|
Author : Database Journal
|
|
|
|
16. Examining SQL Server I/O Statistics
|
|
This article explores the various methods to understand SQL Servers I/O behavior and how to generate reports off the same. The article provides various code snippets that are very useful.
|
|
Posted On : August 26, 2003
|
More...
|
Author : Database Journal
|
|
|
|
15. SQL Server Reporting Services
|
|
SQL Server 2000 Reporting Services promises to fill the only real hole in the SQL Server product the lack of a built in reporting component. Once scheduled for release with the Yukon version of SQL Server, this new reporting functionality will now be available as a download by the end of the year. Here are Reporting Services seven most important features.
|
|
Posted On : August 05, 2003
|
More...
|
Author : SQL Server Magazine
|
|
|
|
|
|
13. DTS on the move
|
|
This article looks at how you can generate comma-seperated files using the BCP command.
|
|
Posted On : August 05, 2003
|
More...
|
Author : Shane Dovers (SQL Server Magazine)
|
|
|
|
|
|
|
|
|
|
9. Using Dynamic SQL - Performance data also
|
|
Interesting article that 90% of the time I see in Newsgroups when asked about D-SQL. It gives you the various ways to work with D-SQL. More than that it gives you some performance statistics also.
|
|
Posted On : July, 2003
|
More...
|
Author : Erland Sommarskog, SQL Server MVP
|
|
|
|
8. Passing data between SPs
|
|
How to share data between SPs. This is a great compilation by Sommar. One of my all time favourites.
|
|
Posted On : July, 2003
|
More...
|
Author : Erland Sommarskog, SQL Server MVP
|
|
|
|
7. Generating Insert scrits
|
|
This article can generate Insert statement scripts. Refer to the tools section where I ve also posted one such tool.
|
|
Posted On : July, 2003
|
More...
|
Author : SQL Performance site
|
|
|
|
|
|
5. Determine Proper SQL Server Configuration Settings
|
|
This article describes the following configuration settings and considerations for their use: Affinity Mask, Lightweight Pooling, Max Async IO, Max Worker Threads, Memory, Priority Boost, Set Working Set Size etc.
|
|
Posted On : July, 2003
|
More...
|
Author : Microsoft KB Article
|
|
|
|
|
|
3. How to Create a SQL Server 2000 Trace
|
|
This article describes how to create and use a stored procedure called trace_build that creates a trace from arguments in a text file. This stored procedure is an alternative to using SQL Profiler to create a script to create a trace
|
|
Posted On : July, 2003
|
More...
|
Author : Microsoft KB Article
|
|
|
|
|
|
1. SQL Blocking Due to [[COMPILE]] Locks
|
|
SQL Server parses, compiles and builds a execution plan tree. And in that process it takes Compile locks. In this article you would look at how we can understand the behaviour of SQL Server and avoid such overheads.
|
|
Posted On : July, 2003
|
More...
|
Author : Vinod Kumar
|
|
|