Clarion Developer Blog
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
One man said in our mail list that we can easy manipulate with MS Excel using MS SQL Server.
EXEC sp_addlinkedserver EXCEL,
‘Jet 4.0′,
‘Microsoft.Jet.OLEDB.4.0′,
‘d:\MyWorkbook.xls’,
NULL,
‘Excel 5.0;’
GO
SELECT * FROM EXCEL…[Sheet1$]
GO
I have not check it but it looks pretty.
Tags: MS Excel, MS SQL Server, T-SQL | No Comments »
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: MS SQL Field Box | No Comments »
MS SQL Field Box 2.3 released. I added a popup menu. This items is usefull for me
Tags: MS SQL Field Box | No Comments »
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: MS SQL, T-SQL | No Comments »
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: backup, MS SQL Server | 7 Comments »
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: MS SQL Server | No Comments »
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: MS SQL Server | No Comments »
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: Firebird | No Comments »
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 [...]
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 [...]
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, [...]
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: MySQL 5.1 | No Comments »
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 [...]
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: sp_lock | No Comments »
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
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Jul | ||||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | |||