if that's a huge table and you would keep using it constantly, i would suggest you set up a trans/snapshot replication between the two databases. so you would be able...

Thanks a lot for the pointers!

The overall server status is pretty good. CPU usage is well under 10%.

Buffer cache hit ratio is almost 100%.

There is no developer...

Yes, you are right. I am looking at a 'performance' problem. The application side was complaining that it is slow to pull out of data from Database. and I went...

There were posts about this error on this website:

http://www.sqlservercentral.com/Forums/Topic644009-6-2.aspx

Will this work for you?

UPDATE YOURTABLE

SET COLUMN_NAME_for_3302=3302,

COLUMN_NAME_ for_DENIM ='DENIM'

WHERE COLUMN_NAME_for_6P

IN ('8P','10P','12P','16P','18P')

*Assuming the values in...

Thank you very much all the above VALUABLE suggestions and warnings.

I think I got the idea about how the Virtual servers/Instances/Groups/Disks/Nodes fun stuffs linked together to make it work.

This is...

When you connect to database engine, you connect to the instance name, not the file: c:\program files.....put your instance name there. if it is default instance, it should be Phil-PC.

I find the backup history tables are valuable too in terms of size trending, and data-retrieving for occasions that some ancient data need to be retrieved, which may only exist...

Are you using the same security/credentials when you create the linked server in the two environments?

If you are, then try to run a select query on your dev server to...

It (Keepass) looks like a very good tool. Thanks a lot for the pointer.

This query can give you an idea what cached plans you have on the server:

SELECT a.*, text

FROM sys.dm_exec_cached_plans a

CROSS APPLY sys.dm_exec_sql_text(plan_handle)

ORDER BY a.usecounts DESC;

GO

This one gives you...

Yes, as Perry said, to make the secondary database online, it is a manual process. It is not an automatic one like the failover cluster.

And after the restore WITH...

it sounds like you are pre-populating the rules(the possible conditions) into a table by a CROSS-JOIN like method. This could go huge if the base tables (your data tables and...

so there is no way to restore master to a point in time? only be able to to restore to the last good backup?

I think I missed something in the above steps.

Here are the Modifications:

In step 2-a-ii, and 3-c; when updating the Assigned value, we should update the Assigned value of all...