No.

I don't want do change anything in the database. Just I want to change it in the report display. I have 2-3 columns like that which is showing empty. Just...

I have email column. That allows null. When I retrieve that column in the database it is showing 'null' but same query in the dataset and click on preview it...

Thanks,

Where I can set that property.

Mainly we need this for archiving purpose.

Yes GailShaw.

I need to do the partition. Do you think it will degrade the performance?

What is your suggestion?

Thanks,

Yes Kevin,

We don't have any auditing. So we created triggers for those tables for those tables and inserting that inserted and modified date into that columns.

Yes.

The problem is that tables have foreign key constraints. We don't have any proper partition key. So now we created two additional columns on those tables created date & Updated...

Thanks all,

Correct me if I am wrong,

If we have 15 databases in 2008 and we want to upgrade to 2012 with minimal downtime. First we have to run the upgrade...

Hi All,

Thanks for the replies.

I read that for migration we can schedule log backup or differential backup to reduce the downtime. Anyone did this? I need the downtime as less...

Hi Kevin,

Thanks for the reply.

For now we don't have any issues but just now data is growing. We are estimating it will grow very large in the future. We do...

Thanks for the replies.

One more doubt about the downtime

"Downtime is the time to take the backup and restore into the new server and changing the compatibility levels and fixing the...

Sorry here my opinion is I have to work mainly in Dev & Test box only. So I am taking the statement completed in the profiler.

Hi Kevin,

Mostly I work in the dev or testing box only. So it is ok to run the profiler

Hi Jack,

I am running in dev box only. So stats were not very up to date. Usually to test the changes do we need to run the stats before change...

I saw only records from one query result set and I thought it is giving all together 3 queries result set. Sorry for my mistake. It is giving same no...