You are hereSQL Server

SQL Server


Moving large table to another file group

I have a large errorlog table in my database, with 2M records and 1GB data. I'd like to create a standalone file group for the error log. I tried to use management studio to modify the table, but it's timeout. So I have to do it manually. I'm sure there's better way to do this, but here's my note which works:

SQL Server 2005 using more than 2GB memory

You can configure SQL Server to use more than 2GB by enabling the "Use AWE to allocate memory" option

sqlserver_memory

Install PDO, PDO_SQLITE, PDO_DBLIB, PDO_MYSQL

Recently I'm using PRADO framework for some web application development. It comes to deploy to the server side.
The server is running Debian 3.1r3

  • apt-get install php5-dev php5-mysql php5-sybase php5-sqlite libmysqlclient-dev freetds-dev
  • apt-get install make
  • pecl install PDO
  • pecl install PDO_SQLITE
  • pecl install PDO_MYSQL
  • pecl install PDO_DBLIB
At the last step, it report:
pear/PDO_DBLIB requires PHP extension "pdo" (version >= 1.0)
No valid packages found
install failed