Home > Articles > Data > SQL Server

SQL Server

RSS Feed Subscribe to this topic  RSS details

179 Items

Sort by Date | Title

Creating a User Interface for a Custom DTS Task
By M. Santos
Oct 5, 2001
Marcelino Santos shows you how to add a user interface when creating a custom DTS task.
Creating an Index on Our Person Table to Increase Query Performance
By Rob Hawthorne
Oct 5, 2001
In this excerpt from SQL Server 2000 Database Development From Scratch, author Rob Hawthorne tells you how to create an index on a Person table and how to use SQL Server 2000's execution plan.
Creating and Optimizing Views in SQL Server
By Andy Baron, Mary Chipman
Dec 13, 2000
In this chapter from Microsoft® Access Developer's Guide to SQL Server, learn how to define, create, and modify views, and how to perform index analysis and optimize performance in SQL Server.
Creating Custom Functions in SQL Server 2000
By Matt Shepker
May 11, 2001
In previous versions of SQL Server, functions were defined by system developers and couldn't be modified. Now in SQL Server 2000, developers can create custom functions that return any type of value. Learn here how to create and use these functions.
Date, Math and Text Functions in SQL Server 2000
By Baya Dewald
Apr 4, 2003
In this third article in his series on functions, Baya Pavliashvili continues to explore various types of built-in functions, including the most frequently used math, text, date, and time functions.
Deploying Merge Replication Subscribers in SQL Server
By Hilary Cotter
Sep 10, 2009
Hilary Cotter shows how to decouple your SQL Server snapshot generation from your snapshot application process for the best possible performance - all while letting you keep your sanity.
Dimensional Databases: Building A Data Warehouse
By Baya Dewald
Sep 17, 2004
Building a data warehouse involves several complicated steps and can take time if the population routines aren't designed carefully. But the effort is worth it. Baya Pavliashvili addresses some of the challenges involved in building and maintaining dimensional databases that serve as the foundation of a data warehouse.
DTS and the Flow of Data Through the Enterprise
By Timothy Peterson
Dec 12, 2000
This chapter from Microsoft® SQL Server™ 2000 Data Transformation Services examines the flow of data through an organization, and presents DTS as a powerful and flexible tool for meeting such data transformation needs.
DTS Tips and Tricks
By Baya Dewald, Dan Lampkin
Mar 8, 2002
In this third article of their three-part DTS series, Baya Pavliashvili and Dan Lampkin share the DTS tips that one can learn only through a hands-on experience with DTS packages and components.
Effective Database Design: Choosing The Right Process
By Rebecca M. Riordan
Mar 4, 2005
This chapter examines the process of project design, and discusses the various models of project life-cycle, with the intention of helping you to choose the right one for your database design project.
Enhanced Connectivity from SQL to SharePoint to Office
By J. Peter Bruzzese
Jul 12, 2010
Flexible dynamic data access is an impressive improvement to SharePoint 2010 that provides both read and write capabilities back to an external data source, like SQL, so that you can adjust data between Office, SharePoint and SQL. In this article we will show you how!
Enhancing DTS Package Performance
By Jim Samuelson, Brian Sullivan
Oct 5, 2001
Jim Samuelson and Brian Sullivan show you how to improve the performance of your DTS Packages.
Enhancing SQL Server Functionality with Functions
By Baya Dewald
Feb 21, 2003
In this first article in a series on functions, Baya Pavliashvili introduces you to the various flavors of built-in functions available in SQL Server 2000, with a focus on aggregate functions.
Enterprise Data Management in SQL Server 2005
By Eric L. Brown
Apr 7, 2006
This chapter covers what’s new in enterprise database administration. It doesn’t just look at the product from a feature list, but groups the features according to some tasks common to database administration.
Examples of SQL Server Implementations
By Alex T. Silverstein, Paul Bertucci, Chris Gallelli, Ray Rankins
Sep 22, 2010
This chapter provides examples of real-life database applications running in production environments at major organizations around the world.
Filtering, Sorting, and Summarizing Data in Crystal Reports
By Neil FitzGerald, Bob Coates, James Edkins, Naisan Geula, Ryan Marples, Michael Voloshko
Sep 10, 2004
The beauty of Crystal Reports is its ability to translate data from your database into useful information, but getting it to do that can take some work. This chapter will help you get started.
Generating Atom Feed from SQL Data
By Ivan Pepelnjak
Mar 31, 2008
Ivan Pepelnjak describes how you can create an Atom feed directly on the SQL Server with Transact SQL commands.
Getting and Displaying Images from SQL Server with C#
By Jesse Smith
Jul 29, 2005
Now that Jesse Smith has taught you how to store those system-taxing images in your SQL Server database, you need to know how to get them back out again when the user accesses a page. C# comes to the rescue with easy scripts for grab-and-display.
Getting Started with MSDE and VB .NET
By Rod Stephens
May 17, 2002
How can you build small multiuser applications inexpensively while preparing to scale up if your database needs increased performance? This article shows you how to use MSDE for these tasks.
Identifying Bottlenecks and Performance-Tuning SQL Server
By Jesse Smith
Jun 3, 2005
Using built-in performance counters, you can find out whether your SQL server is under stress or performing exceptionally.

< Prev Page 1 2 3 4 5 Next >