SQL Server Articles

Address information is one of the most common attributes of data stored in a  business data repository. Examples of such data can be addresses of employees, store locations of retail chains, sales of a product etc. You may  wonder about the last example and how sales of a product can be linked with an address. [...]

xxxx

Introduction SQL Server 2008 Full-Text Search feature can be used by application developers to execute full-text search queries against character based data residing in  a SQL Server table. To use full text search the developer must create a full-text index for the table against which they want to run full-text search queries. For a particular [...]

xxx

Introduction SQL Server 2008 introduces Extended Events for performance monitoring. SQL Server Extended Events is a general event-handling system for server systems. So  why another event handling system? We already have activity monitor, Perfmon, SQL Profiler, DMVs,. However, Extended Events have several major advantages: 1. Light Weight. This is the primary advantage of  Extended Events. [...]

Retrieving data from an audit table. Retrieving information from a history table for a given point in time is a common data task. For example, using a table that contains all historical prices, what where the prices of all products as they were 30 days ago? There are a number of ways to different methods [...]

Error Log vs. Alert Log SQL Server maintains a running log of its operations. This log includes information about the start-up and recovery events, user actions, backups, configuration changes, invalid login attempts, errors, warnings etc. Every time the SQL service starts up, a new log file is created. This log file is known as the [...]

Start-up and Configuration Parameters When SQL Server is installed, a number of Windows registry keys are also created. These registry keys specify various parameters values required by the instance. For example, one registry key would specify the location of the error log file; another would contain the location of the default backup folder and so [...]

xxx

Database Instance Architecture When an Oracle instance is created, it is nothing but a collection of some structured areas in the server’s memory and some background processes spawned to interact with it. Oracle literature quite extensively describes these memory structures and processes. The area occupied in the memory by a running Oracle instance is called [...]