SQL Server Performance

Search Results

Search Again
  1. ruancra

    Adding Identity column to existing table

    Thread by: ruancra, Jan 20, 2009, 3 replies, in forum: SQL Server 2005 General DBA Questions
    Hi guys Is it possible to add a identity column to an existing table and to let it increment by 1when new transactions are inserted? Thank you
  2. ruancra

    Table Archiving and Partitioning

    Thread by: ruancra, Jan 13, 2009, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs
    Hi guys What is a general rowcount for a table before it needs to get archived or partitioned? If its a table that gets queried quite often? Thank...
  3. ruancra

    Change SQL instance name

    Thread by: ruancra, Jan 11, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions
    Hi guys We are using SQL 2005, our server name has changed, where can i update SQL to point to the new server name? If im not mistaken i have to...
  4. ruancra

    Max database size SQL 2005

    Thread by: ruancra, Jan 5, 2009, 4 replies, in forum: SQL Server 2005 General DBA Questions
    Hey guys, what is the max size for a database in SQL 2005?ThanksRuan
Showing results 1 to 4 of 4
Search Again