poker tournaments
delivereddatoskeep versionsBlackjack online real moneymotormindmotorfeedburnerdelivereddelivered feedburner

Archive for November 30th, 2011

Procedimientos Almacenados lentos en SQL Server

Si trabajas con SQL Server es muy posible que te haya ocurrido que un Procedimiento Almacenado te tarda muchísimo, pero si ejecutas la misma consulta, y en las mismas condiciones de estado en el servidor de base de datos, en el Analizador tarda sólo segundos. ¿Por qué?. La respuesta es el Parameter Sniffing, que ocurre con los Procedimientos Almacenados que tienen Parámetros y que utilizan dichos Parámetros en sus consultas.

30/11/2011 | By | Reply More

Upgrading PostgreSQL to a new major version

Upgrading PostgreSQL need not be hard. The creators have provided all facilities you need to upgrade nearly painlessly, and depending on the extent of your use, nearly seamlessly.
These notes were made when I was upgrading from PostgreSQL 8.2.6 to 8.3.0, but the information should apply equally to other versions. Keep in mind the version number are specific to these releases, and to substitute your own accordingly.

30/11/2011 | By | Reply More

Working with the hstore data type in PostgreSQL 9.0

In these examples, we assume you have a table named “hstore_test” with a single column named “data” which is of the data type “hstore”.

30/11/2011 | By | Reply More