Alright, as you have stats showing that there is latency from the disk system I would try and prove it.

You're right when you initially said that figures showing latency are...

OK, what's your disk system, DAS or SAN?

Andrew

Have you used performance monitor on the server?

Specifically Physical Disk AVG SEC/READ & SEC/WRITE. Any values over 20ms indicate a problem with disk IO.

Andrew

Hi, did uninstalling SQL and then re-installing work?

Andrew

Hi,

The default isolation level of a SQL Server instance is READ COMMITTED, which means that tranactions cannot read data that has been modified by other transactions but not committed. However...

Hi,

Developer has all the functionality of Enterprise Edition, it just cannot be used for live production environments.

Andrew

Would setting up an SSIS package to extract the data for her work? You could schedule it to run before your colleague came into work so that her data was...

Hello,

Have a look here:-

http://msdn.microsoft.com/en-us/library/aa174499(v=sql.80).aspx

It should let you know whether or not you need to have the MSDTC service running.

Andrew

Have a look at this link (using C#):-

http://stackoverflow.com/questions/4276138/how-to-check-if-a-registry-value-exists-using-c

Registry values would be:-

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion

Hello,

Have a look at the services (Start>Run>Services.msc) running on the PC. It will show you if SQL is installed and is running or not.

Andrew

Hi,

What will you need to do with the back end SQL databases behind Sharepoint? In my experience, Sharepoint creates its own databases, just make sure the default data and log...

Any luck with this?

Andrew

Sorry been on holiday!

How have you been getting on with this?

Did using the configuration manager allow you to start the service under [NETWORK SERVICE] or did you get the same...

Hello,

Do you need the service to run under NETWORK SERVICE?

I would create an AD account for the service and use that. You can then assign the required access rights.

Andrew

If the table has a clustered index on it you could rebuild the table, moving the clustered index to the new filegroup. That will move your data.

I would not think...