|
|
 |
Updating a table from another table
|
| Total Hit (1560) |
As the article title suggests, an UPDATE statement is able to reference data in other tables. This is done using a FROM clause.
Let's use the Northwind database as our example here. A usual update statment to update a product's list price might look something like this.
«Code LangId=6»
UPDATE P
....Read More |
Rating
 |
|
|
|
Handling database file growth
|
| Total Hit (2744) |
Scripts to automatically get notified if a database grew due to the autogrowth option being turned on.
|
| Rating
|
|
|
|
|
|
|
|
How to use ORDER BY clause in the definition of a view?
|
| Total Hit (2513) |
SQL Server excludes an ORDER BY clause from a view to comply with the ANSI SQL-92 standard. Because analyzing the rationale for this standard requires a discussion of the underlying structure of the structured query language (SQL) and the mathematics upon which it is based, we can't fully explain th
....Read More |
Rating
 |
|
|
|
|
|
Copy text or image into or out of SQL Server
|
| Total Hit (7354) |
In this article, I want to show, how you can copy a single text or image value into or out of SQL Server by using the textcopy.exe utility. You can find this utility in the directory containing the standard SQL Server EXE files (C:\Mssql\Binn for SQL Server 6.5, by default and C:\Mssql7\Binn for SQL
....Read More |
Rating
 |
|
|
|
Counting ocurrences of a pattern in text data
|
| Total Hit (1436) |
A sample script to count the number of occurrences of a particular string pattern in a text column. This demonstrates how to use PATINDEX with simple SELECT statements.
|
| Rating
|
|
|
|
Quickly Shrinking the Transaction Log
|
| Total Hit (2777) |
In this article I would like to discuss about the following two things:
1) About shrinking the transaction log.
2) Different ways of taking the database offline.
1) Shrinking the log:
The following is a trick for quickly shrinking the size of the transaction log which you think has beco
....Read More |
| Rating
|
|
|
|
How to configure E-Mail Subscription with SQL Reporting Services.
|
| Total Hit (4923) |
When you install reporting services it will ask you for SMTP settings. If you skip those settings then probabbly when you create new subscription you will only see "file share" option.
In order to enable "Email Subscription" you need to do couple of steps.
1. open the RSReportServer.config fil
....Read More |
| Rating
|
|
|
|
OLAP and Data Warehousing - Data in Jail
|
| Total Hit (1621) |
Please find below the follow-up to the first part in my OLAP and Data Warehousing (The Problem and Solution) series, a series dedicated to the discussion of OLAP and Data Warehousing technologies.
A lack of world economic stabilization over the last few years has resulted in a growth of competit
....Read More |
| Rating
|
|
|
|
Setting Up Snapshot Replication: A Step-by-step Guide
|
| Total Hit (743) |
In this article, I want to tell you about some general Microsoft SQL Server replication topics: replication topologies, replication types, and replication agents. I will also discuss Snapshot replication: how to check necessary conditions for this type of replication and how to backup and restore th
....Read More |
| Rating
|
|
|
|
|
|
Nightly Failed Jobs Report
|
| Total Hit (922) |
Do you get tired of reviewing each SQL Agent notification nightly to determine which SQL Agent jobs failed? Are there a significant number of SQL Agent job notifications that it takes a while to review each? Here is an alternative that allows you to have a single email report of all job failures.
....Read More |
| Rating
|
|
|
|
Microsoft TerraServer
|
| Total Hit (746) |
The Microsoft® TerraServer stores aerial and satellite images of the earth in a Microsoft SQL Server™ database served to the public through the Internet. It is the world's largest atlas, combining five terabytes of image data from the United States Geodetic Survey, SOVINFORMSPUTNIK, and Encarta®
....Read More |
| Rating
|
|
|
|
Migrating a Maintenance Plan from One SQL Server to Another
|
| Total Hit (901) |
Have you ever had to migrate all of the SQL Server objects from one machine to another SQL Server box? If you have, you probably have found that Microsoft has not provided a method to build a migration script for a maintenance plan. Since there is no easy way to migrate a maintenance plan, most DBAs
....Read More |
| Rating
|
|
|
|
Create an Access Database
|
| Total Hit (975) |
When exporting data to a text file, if the file does not exist it will be created, or if it does exist it will be overwritten. In contrast, when exporting to an Access database the file and table must exist already. This article will show you how to create an empty Access database ready to receive y
....Read More |
| Rating
|
|
|
|
Using Forms Authentication in Reporting Services
|
| Total Hit (1012) |
Learn about Reporting Services security extensions with a primary focus on Forms Authentication. In addition, download and deploy a sample Forms Authentication extension for Reporting Services. (23 printed pages)
|
| Rating
|
|
|
|
|
|
Statistics Used by the Query Optimizer in Microsoft SQL Server 2000
|
| Total Hit (701) |
Describes what data is collected, where it is stored, and which commands create, update, and delete statistics about indexes and column data stored in the Microsoft SQL Server 2000 database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving
....Read More |
| Rating
|
|
|
|
Synchronizing Production Data with a Test Database on SQL Server
|
| Total Hit (712) |
Every corporation has a unique infrastructure environment. Let us consider a simple production, testing, and a development environment. The SQL scripts application, developed in a development environment will be tested in a QA environment and then moved to production on a production date. Usually th
....Read More |
| Rating
|
|
|
|
Log Shipping
|
| Total Hit (704) |
It is 2 PM on a record business day. The Microsoft® SQL Server™ 2000 server housing your mission-critical customer database experiences a disk failure. What do you do? When was the last known good backup? Is there another server available to restore the backup onto? Is SQL Server even on that server
....Read More |
| Rating
|
|
|
|
|
|
Sequential Numbering/Counting of Records with SQL Server
|
| Total Hit (671) |
Microsoft SQL server does not support a method of identifying the row numbers for records stored on disk, although there are a number of different techniques to associate a sequential number with a row. You might want to display a set of records where each record is listed with a generated number th
....Read More |
| Rating
|
|
|
|
MDX at First Glance: Introduction to SQL Server MDX Essentials
|
| Total Hit (1378) |
To get the most out of the MDX Essentials series, we need to have installed at least the Analysis Services component of MSSQL Server 2000. While the full installation of SQL Server 2000 allows for virtually any exercise we might undertake, the majority of our sessions center on Analysis Services, th
....Read More |
| Rating
|
|
|
|
How can I dynamically set the Access System Database
|
| Total Hit (670) |
You can easily change the filename for an Access database connection using the Dynamic Properties Task in SQL Server 2000. Unfortunately the property selection dialog does not allow access to the system database property (Jet OLEDB:System database) which you need to specify correctly when accessing
....Read More |
| Rating
|
|
|
|
Reporting Options for Analysis Services Cubes: MS FrontPage 2002
|
| Total Hit (1659) |
This is the eleventh article of the series, Introduction to MSSQL Server 2000 Analysis Services. As I stated in the first article, Creating Our First Cube, the primary focus of this series is an introduction to the practical creation and manipulation of multidimensional OLAP cubes. The series is des
....Read More |
| Rating
|
|
|
|
Tutorial : Sample Custom Task Project
|
| Total Hit (627) |
The ability to write your own custom tasks is often overlooked when designing a solution and yet it can offer so much flexibility. This is a sample Visual Basic project of a relatively simple custom task. It doesn't do very much, but it does have a user interface and several properties. The UI allow
....Read More |
| Rating
|
|
|
|
A better Soundex code
|
| Total Hit (1043) |
Terms that are often misspelled can be a problem for database designers. Names, for example, are variable length, can have strange spellings, and they are not unique. American names have a diversity of ethnic origins, which give us names pronounced the same way but spelled differently and vice versa
....Read More |
| Rating
|
|