 |
Reducing SQL Server Index Fragmentation
|
| Total Hit (2678) |
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
....Read More |
Rating
 |
|
|
|
MDX in Analysis Services: Measuring Change over Time
|
| Total Hit (770) |
This is the fifth tutorial article of the series, MDX in Analysis Services. The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis Services ("Analysis Services,"); our primary focus is the manipulation of multidimensional
....Read More |
| Rating
|
|
|
|
Build a Web Site Traffic Analysis Cube: Part I
|
| Total Hit (2176) |
This is the thirteenth 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 d
....Read More |
| Rating
|
|
|
|
Dealing with MS SQL Tables that contain Duplicate Rows
|
| Total Hit (704) |
Every so often, you might have to deal with tables that contain duplicate rows. In one case, you might only need to identify the duplicate rows. In other cases, you might need to remove the duplicate rows. This article will show you some different techniques for dealing with duplicate rows.
....Read More |
| Rating
|
|
|
|
Backing Up and Restoring SQL Server Databases and Transaction Logs
|
| Total Hit (1130) |
The backing up and restoring of databases and transaction logs is a way that SQL Server provides to protect from data loss. The backup operation creates a copy of a database. This copy can be used to restore the database if media failure occurs or if the database is somehow damaged (for example, fro
....Read More |
| Rating
|
|
|
|
|
|
XML and SQL 2000 (Part 6)
|
| Total Hit (1200) |
In the previous article, I explained the meaning of the "Allow posted updategrams" and "Allow template queries" options on the Settings tab of the Virtual Directory Properties dialog box in IIS Virtual Directory Management for SQL Server tool. I also presented examples of taking advantage of these o
....Read More |
| Rating
|
|
|
|
Migrating Logins from One SQL Server to Another
|
| Total Hit (1087) |
As part of the normal work, a Database Administrator (DBA) will be required to migrate databases between servers. One of the reasons for a migration might be that you are moving an application from a quality assurance (QA) environment to a production environment. Another reason might be your current
....Read More |
| Rating
|
|
|
|
MDX in Analysis Services: Calculated Members: Introduction
|
| Total Hit (767) |
This is the seventh tutorial article of the series, MDX in Analysis Services. The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis Services ("Analysis Services,"); our primary focus is the manipulation of multidimension
....Read More |
| Rating
|
|
|
|
Examples of how to Calculate Different SQL Server Dates
|
| Total Hit (591) |
Every now and then, you need to take the current date and calculate some other date. For instance, you might have an application that needs to determine what date is the first day of the month, or need to know the last day of the month. Now most of you probably already know how to separate the date
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
Using SQL Server's CHARINDEX and PATINDEX
|
| Total Hit (1186) |
If you have written many applications then you probably have run across situations where you need to identify if a specific character or set of characters appears in a string. In this article I will discuss using the CHARINDEX and PATINDEX functions to search text columns and character strings. I wi
....Read More |
| Rating
|
|
|
|
Creating a SQL Server User Interface with InfoPath
|
| Total Hit (660) |
When Office 2003 is released about a month from now, some of the versions will contain two new applications OneNote and InfoPath. OneNote is a note taking application that may be interesting to those of you with tablet PCs. InfoPath is an XML based forms creation and entry application that looks ver
....Read More |
| Rating
|
|
|
|
SQL Server Stored Procedures Administration
|
| Total Hit (604) |
A stored procedure is a precompiled collection of Transact-SQL statements stored under a name and processed as a unit that you can call from within another Transact-SQL statement or from the client applications.
|
| Rating
|
|
|
|
|
|
Using DiffGrams for XML data modifications (XML and SQL part 9)
|
| Total Hit (1018) |
In a previous article of this series, I described using bulk loading of XML data with scripting interfaces included in the SQLXML version 2.0 and later. Now, we are going to explore another feature introduced in SQLXML version 2.0 (and enhanced in the version 3.0) called Diffgrams.
....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
|
|
|
|
Compressed Backup of SQL Server 6.5, 7.0 and 2000 on Windows 2000
|
| Total Hit (1223) |
DBAs are always running out of hard disk space when handling large databases such as data-warehouse databases and other VLDB. Backing up such databases to disk occupies more disk space, since Microsoft SQL Server does not have compression built into the backup process. SQL Server customers usually g
....Read More |
| Rating
|
|
|
|
Using Sets in MDX Queries
|
| Total Hit (1434) |
This is the sixth tutorial article of the series, MDX in Analysis Services. The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis Services ("Analysis Services,"); our primary focus is the manipulation of multidimensional
....Read More |
| Rating
|
|
|
|
Managing Users Permissions on SQL Server
|
| Total Hit (1298) |
Permissions are the rights to access the database objects. Permissions can be granted to a user or role to allow that user or role to perform operations such as selection, insertion or modification of data rows.
|
| Rating
|
|
|
|
XML and SQL 2000 (Part 8)
|
| Total Hit (1058) |
So far, this series has concentrated on configuration options available via the graphical interface of IIS Virtual Directory Management for SQL Server. However, newer versions of SQLXML, in addition to the features we have already covered, provide another type of functionality, accessible through sc
....Read More |
| Rating
|
|
|
|
|
|
Sequential Numbering/Counting of Records with SQL Server
|
| Total Hit (669) |
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
|
|
|
|
Examining SQL Server's I/O Statistics
|
| Total Hit (820) |
Reading and writing to the disk is the heart of what any database management system does, SQL Server included. Input/Output (I/O) performance can make or break an application. This article discusses the diagnostic tools that can be used to examine SQL Server's I/O statistics so that you can make fac
....Read More |
| Rating
|
|
|
|
Enhanced SQL Server Security Auditing
|
| Total Hit (1372) |
Security audit in SQL server captures only successful and failed logins. It does not capture the application that uses the login. Login used by an application may have full read and write access on all of the tables and procedures but the application restricts the users by providing a front-end whic
....Read More |
| Rating
|
|
|
|
Scripting Traces for Performance Monitoring on SQL Server
|
| Total Hit (985) |
The SQL Profiler is a great tool for monitoring and analyzing SQL Server Performance. I use it all the time to watch the detailed actions of a stored procedure, trigger or user-defined function (UDF) that I am developing. It can also be used to monitor aggregate performance of an entire SQL Server i
....Read More |
| Rating
|
|
|
|
XML and SQL 2000 (Part 7)
|
| Total Hit (1060) |
We are ready to conclude the discussion on various methods of extracting relational data from SQL Server 2000 in XML format via HTTP. All methods described in previous articles are available through SQL ISAPI extensions to Internet Information Server, implemented as IIS Virtual Directory Management
....Read More |
| Rating
|
|
|
|
How to Create ODBC DSN on multiple SQL server machines
|
| Total Hit (2084) |
In a typical Client - Server environment it is often necessary to create ODBC DSN on many client machines or servers for front-end applications such as VB, or MS-Access, which uses ODBC DSN for linked tables. Even for creating linked servers to heterogeneous systems like Oracle, Sybase and mainframe
....Read More |
| Rating
|
|