Hi,

it is possible to recover your data if the database is in full revovery model. You have to perform

1. a transaction log backup

2. restore the most recent full backup with...

Hi,

First of all how frequently do you backup the transaction log? It is not clear defined.

Secondly, what do you mean when you say "the system crashed"? The server is down,...

You should never shrink a data file for performance reasons.

The only way to control the size of a database is to setup an archive job which wiil run frequently enough...

Hi,

when AWE is enabled you can observe memory utilisation only from SQL Server performance counters.

Regards,

PSA

You have the following two options:

- in-place upgrade

- side-by-side upgrade

Check the complete documentation in http://www.microsoft.com/downloads/details.aspx?familyid=3D5E96D9-0074-46C4-BD4F-C3EB2ABF4B66&displaylang=en

PSA

Hi,

CREATE TABLE #temp(

rec_idint IDENTITY (1, 1),

table_namevarchar(128),

nbr_of_rowsint,

data_spacedecimal(15,2),

index_spacedecimal(15,2),

total_sizedecimal(15,2),

percent_of_dbdecimal(15,12),

db_sizedecimal(15,2))

-- Get all tables, names, and sizes

EXEC sp_msforeachtable @command1="insert into #temp(nbr_of_rows, data_space, index_space) exec sp_mstablespace '?'",

@command2="update #temp set table_name = '?' where rec_id = (select...

Hi,

Is there a firewall between the client and the database server?

Are you connecting to the correct machine and instance?

PSA

Hi,

check the following:

- are both databases the same size?

- check the two query plans. Are they the same?

- are other queries running in development machine?

Good luck

PSA

Hi,

the reply to your first question:

SQL Server writes data to database file proportionally. No action is required.

The biggest advantage of 64-bit is the ability to directly deal with larger amounts of memory.

Another big advantages is the ability to consolidate 32-bit database servers in a bigger...

Check the following links:

http://msdn.microsoft.com/en-us/library/ms189858.aspx

http://msdn.microsoft.com/en-us/library/ms188917.aspx which contains a very useful script at the end for reindexing

PSA

James,

reindexing procedure does update statistics so you have to omit step 3 in your schedule.

Regards,

PSA

Hi,

you could make a primary key consisting of both fields.

Try to avoid nvarchar type in primary keys and indexes if possible.

PSA

Ian is right.

You have to export data from columns defined as character fields, change column collation and then import those data.

Change of collation at column level takes place only for...

Hello,

Microsoft suggests to create datafiles equal to the number of CPU's.

For a quad core system, you have to create 4 datafiles for a critical database. This rule is also valid...