MS SQL Field Box 2.4 released
Posted October 5th, 2009 by Andrew PopoffI’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
Posted September 29th, 2009 by Andrew PopoffMS SQL Field Box 2.3 released. I added a popup menu. This items is usefull for me
Tags: MS SQL Field Box | No Comments »
MS SQL 2008: Indexed view
Posted September 3rd, 2009 by Andrew PopoffI 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 »
Category: SQL
Copying Data
Posted August 20th, 2009 by Andrew PopoffI 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 »
Category: SQL
How To Shrink A Transaction Log In MS SQL 2008
Posted June 4th, 2009 by Andrew PopoffI 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 »
Category: SQL
How To Reorganize All Indexes On MS SQL 2008
Posted May 6th, 2009 by Andrew PopoffTo 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 »
Category: SQL
Firebird 2.1.1 Release Candidate is now officially announced
Posted June 19th, 2008 by Andrew PopoffThe 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 »
Category: SQL
How do I… Identify and delete duplicates from SQL Server tables?
Posted June 4th, 2008 by Andrew PopoffDuplicate 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 [...]
Category: SQL
How do I configure SQL mail in SQL Server 2000?
Posted May 22nd, 2008 by Andrew PopoffAs 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 [...]
Category: SQL
Generate synchronization scripts in SQL Server with TableDiff
Posted April 23rd, 2008 by Andrew PopoffDBAs 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, [...]
Category: SQL
Sun Microsystems Announces MySQL 5.1
Posted April 16th, 2008 by Andrew PopoffNew 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 »
Simplify SQL Server 2005 queries with a Dates table
Posted April 15th, 2008 by Andrew PopoffWhat 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 [...]
Category: SQL
Diagnose SQL Server performance issues using sp_lock
Posted April 1st, 2008 by Andrew PopoffA 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 »
Category: SQL
How do I use BCP in SQL Server?
Posted March 31st, 2008 by Andrew PopoffThe 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
Category: SQL
Bulk importing data into SQL Server
Posted March 25th, 2008 by Andrew PopoffIf 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
Category: SQL