Hi there

Well, you are very wrong actually!  and im not sure what your on about to tell you the truth re my inability to manage the webserver?  sorry, you came...

Here's some radical thinking, lets drop the box!   seems to cludge up the logo a tad and doesnt really mean a lot in...

Hi Brian

Well its a start, very limited generally, but certainly a solid TOAD framework for expansion; I think we need a few version before I would skip over from even my standard...

Hi there

I believe the iSCSI bit is just noise, not saying though a cabling issue may be your problem.  I gather its a sql specific corruption identified by either the...

Hi there

Great to here, DTC issues can be a nightmare to resolve.  I only run a win2k cluster so thanks for the note re DTC, is this done on sql...

Hi

Did you run comclust ?  I cant remember if sql err's on setup if this hasent been run.. but worth looking into; also, what rights does your sql server instance...

Hi there

Good point actually, the questions page should include some graphical indicator of what has/has not been answered to make going back over missed questions easier..

Terry

Any results/action taken from these suggestions?? good to clear up this posting with the action plan you have taken for others in the future.

Cheers

Ck

Also, any adverse blocking for whatever reason??

Hi - good question

I dont know of a method off hand with standard date format commands during an alter, I would probably go...

Hi there

Well this is strange.  I would consider:

a) update db statistics for starters

b)  check default db options and auto create stats is enabled

c)  attempt a dbreindex and updateusage

Profile off selected...

Hi there

Well, this is a somewhat complex topic, I would take an initial view at:

http://www.sql-server-performance.com

then try and post specific examples that you need more info on as to why...

Hi there

restore database northwind_unc

from disk = '\\pc-124405\unctest\northwind.bak'

WITH MOVE 'Northwind' TO 'c:\testdb.mdf',

   MOVE 'Northwind_log' TO 'c:\testdb.ldf'

Processed 320 pages for database 'northwind_unc', file 'Northwind' on file 1.

Processed 1 pages for database 'northwind_unc',...

Hi there

You will typically see these when your apps are using server side cursors, have a closer look in profiler and you may also see sp_prepare, sp_prepareexec etc; take care...

Hi John

Strange indeed, I am a little concerned about your select statement, doesnt follow the typical standard for linked server queries, but your post might me a simple demo rather...