no.

Virtual Address Space is divided in User mode and kernel mode. Each and every process gets its own User mode address space, while kernel mode space is shared across...

have you checked if applying SP2 + Cumulative update solves this ?

also, did it ever worked on your box ?

This is an informational message only. It indicates the last time when the checkdb was run and came out clean.

I have seen this message when the database is going...

823 error means that the page is corrupt. If the backup was taken after the corruption, that would be present in restored database as well.

run dbcc checktable on all tables,...

if the operating system itself is not reponding than Issue is at windows end. consider engaging Microsoft windows team for their help. may be they can help in isolating issues...

try this, change ##temp tables to #temp or tempdb..temp and then bcp.

also, have you tried to take a count(*) before and after bcp on those tables? just to ensure that...

"In the logs, there is a bunch of "DELETE" commands in the system tables (sysobjects, syscolumns, ...) but no "DROP TABLE" for the corresponding objects"

looks like you were running SQL...

http://blogs.msdn.com/sqlcat/archive/2006/06/23/Tom-Davidson-SQLCAT-Best-Practices.aspx

HTH

Use SQL 2005 Database tuning advisor.

I would suggest usiing the option in DTA that says "Ignore existing data stuctures" i.e. index/stats/partitioned views.

that would tell you an initial view from SQL...

cosider relog.exe for converting from one perfmon format to another such as database.

I am not sure if it is going to make data retrival easy ;-)`

1. Check if there is a blocking

2. Check if you are seeing any major waits for your applications's SPID in SQL Server.

3. Use profiler and find if the all...

Are you looking to see an command prompt window on SQL Serve or on the Remote box ??? not possible.

Are you looking to just initiate a batch file from a...

"you only enable AWE when you wish SQL Server to see beyond 4GB RAM?"

no, you enable AWE when you wish SQL to see beyond your process's user mode virtual address...

The means that all threads within SQL process that were running on Node 0 (Thats a New term, inherited due to SQL support for numa architecture) are waiting for resource...

My 2 cents on this

http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/RelDWPerf.doc

{

Hardware decisions often are made prematurely, before any significant knowledge of the system is known. This is particularly tricky when choosing hardware for a...