The future depends on us. It is up to us to the future of Clarion.
Will this programming language to live long and happy life or dies in oblivion depends on us. If you have to say, do it here in this blog. Welcome!

Read More

MS SQL Field Box 2.4 released

I’ve updated MS SQL Field Box. I’ve added the ability to view relationships between tables and ability to execute sp_spaceused procedure.

Tags: | No Comments »

Category: SQL, Utilites

MS SQL Field Box 2.3 released

MS SQL Field Box 2.3 released. I added a popup menu. This items is usefull for me

Tags: | No Comments »

Category: SQL, Utilites

MS SQL 2008: Indexed view

I have a two tables. The first table consists of one column. This is the date column. The second table contains a goods and a new sale price for that goods.
This is the history of price changing.

July, 1 July, 1
——- [...]

Tags: , | No Comments »

Category: SQL

Copying Data

I have a new task. I need to copy a data from remote office to main office. The data is the MS SQL database. What I need is just copy a database from one office to another.
And I can’t do it.
I can communicate between offices only by e-mail. This is the slow connection. I can [...]

Tags: , | 7 Comments »

Category: SQL

How To Shrink A Transaction Log In MS SQL 2008

I have a problem when using MS SQL 2008. The recovery model for my database is configured as a “Full“.
I do a full backup of the database every night. I do a transaction log backup every hour. The transaction log file for the two weeks of use has increased to 55Gb. The size of the [...]

Tags: | No Comments »

Category: SQL

How To Reorganize All Indexes On MS SQL 2008

To transfer data, I made a backup of the database and just restored it to the new server. The speed of execution of queries has become much lower than on the old server.
I decided that it was necessary to rebuild all indexes in the database. You can do this using Management Studio. In this case, [...]

Tags: | No Comments »

Category: SQL

Firebird 2.1.1 Release Candidate is now officially announced

The Firebird Team is pleased to make a release candidate available for field testing the first V.2.1.x patch release on Windows, Linux and MacOSX Intel platforms. Please test it hard and report any problems to the firebird-devel list.
Source

Tags: | No Comments »

Category: SQL

How do I… Identify and delete duplicates from SQL Server tables?

Duplicate records in a database are bad. You can’t tolerate them. At the very least, they’ll produce misleading analysis. At the worst, they’ll totally wreck everything. Your application will probably run, but everything it generates will be suspect. You have to find them and delete them or your client might just delete you!
Of course, the [...]

No Comments »

Category: SQL

How do I configure SQL mail in SQL Server 2000?

As a database administrator, I like automation. When it comes to my backups, I like to automate as much as possible. SQL Mail gives me the ability to know when my backups are successful and when they fail.
SQL Mail is a component of SQL Server that allows you to send mail. Some of its functions [...]

No Comments »

Category: SQL

Generate synchronization scripts in SQL Server with TableDiff

DBAs often have to find the differences between lookup tables in different database environments (i.e., development, quality-assurance, staging, and production). The data in these lookup tables are required to be the same across environments to ensure that your testing is accurate.
There are a variety of great tools on the market that will run these comparisons, [...]

No Comments »

Category: SQL

Sun Microsystems Announces MySQL 5.1

New Version of the World’s Most Popular Open Source Database Delivers up to 15 Percent Higher Performance for Large-Scale Enterprise Applications.
Read more

Tags: | No Comments »

Category: General, SQL

Simplify SQL Server 2005 queries with a Dates table

What is a Dates table?
A Dates table stores a range of dates. Dates tables are very common in a DateWarehouse as a dimension table. You can also use Dates tables in OLTP databases for lookups. When programmers use Dates tables, they don’t have to worry about using or designing functions for handling or formatting dates [...]

No Comments »

Category: SQL

Diagnose SQL Server performance issues using sp_lock

A common misconception among IT pros is that “locks are bad,” and you must do everything possible to ensure database locking doesn’t prevent processes from running. In order to ensure a consistent database environment, the database engine must use a mechanism to acquire exclusive use of a resource when that resource is being modified.
SQL Server [...]

Tags: | No Comments »

Category: SQL

How do I use BCP in SQL Server?

The Bulk Copy Program (BCP) is a command-line utility that ships with Microsoft SQL Server. With BCP, you can import and export large amounts of data in and out of SQL Server databases quickly and easily. Any DBA who has utilized this functionality will agree that BCP is an essential tool.
Read more

No Comments »

Category: SQL

Bulk importing data into SQL Server

If you work with databases, at some point, you’ll deal with inserting data into SQL Server from outside data files. This tutorial shows how to import data using the BULK INSERT command and explains how changing some of its options can make it easier and more efficient to insert data.
Read more

No Comments »

Category: SQL
Pages: 1 2 3 Next
Pages: 1 2 3 Next