PosgtreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language. Though originally designed to run on UNIX platforms, Postgres is able to run on various platforms, such as macOS, Solaris, Windows, Unix, and Linux. PostgreSQL databases provide enterprise-class database solutions and are used by a wide […]
2020-05-11
5,742 reads
2019-02-19
5,335 reads
Do you use PostgreSQL in your organization? Are you thinking about using it? Take our short survey and tell us about what you think about it.
2014-09-02
8,411 reads
This is a cool date format function I found a while back. See header comments for credits.../* ////////////////////////////////////////////////////////////////////////////////// Author: Rusty Hansen 8-21-2001 Description: Formats a date to a specific format. Parameters: @dDate = A value or field of datatype datetime or a value or field that can be explicitly converted to a datetime […]
2005-05-20
Yes, that helps. You have a total of 48GB of transaction log, 653.85MB currently in use according to task pad. You shrank the log a few hundred mbs, so that confirms that you are indeed working with a log on the current db. Now, a transaction log is made up of many "virtual logs". As […]
2005-01-28
I don't know anyway to definite identify the Application lock. But, I normally select from sysprocesses table and pay special attention to 'waittype' column. When the value in this column is not 0x000, it seems have some kind of locking occurred on the APP level.
2004-05-11
Thanks Salim. Our needs are much simpler than what the DBPropagator seems to offer. Also, if I can't do this cheap I can't do it at all. Basically, Transactional data is processed on the mainframe and a file(table?) is built/updated. The data then needs to be exported to sQL, which will then continue with the […]
2003-12-08
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers