Paul Randal has one on his blog...

Liking the SWITCH option... Used it many times.

Nice code!

@PaulRandal writes a excellent article..

http://msdn.microsoft.com/en-us/library/cc949109.aspx

Isolation Semantics

The isolation semantics are governed by database engine transaction isolation levels. When FILESTREAM data is accessed through the Win32 APIs, only the read-committed isolation level...

Have you enabled it in the "Features" section of Computer Management

Copy is a good option, I personally use Robocopy that offer some good features.

Includes purging old files..

http://technet.microsoft.com/en-us/library/cc733145%28WS.10%29.aspx

Gianluca Sartori (5/13/2010)

---

Heh, Mr. Coffee, virtual machines are horribly slower than physical machines.

There's a virtualization layer between your system and the physical resources: CPU, disks and memory must be...

Its a long shot but try installing SP3

Build list here

http://www.sqlservercentral.com/articles/Administration/2960/

Within the sql server configuration manager try setting the IP address to 127.0.0.1

You will need to restart the sql services for it to take effect.

What is the current version/SP/CU of your sql server?

Try installing the latest SP (test test test first) and /or CU

Are these VM machines?

As the other guys have already said it can be a large task...

If you are not a DBA or your company doesn't have one ,then either get one or hire...

You could try the following as I had a similar issue last year.

- Are your data/log/tempdb on seperate disk drives/arrays?

- Have you tried rebuilding the indexes that are been used...

Have you tried?

declare @servername nvarchar(30)

Set @servername = 'dev-server'

SELECT count(name) FROM OPENDATASOURCE('SQLNCLI',

...

This looks like an oracle error trying to resolve the TNS name.

Have you installed the Oracle tools/client? Its a long time since I have used/setup an oracle client, but if...

To be honest I expected most bloggers etc to write about April fools. I myself find it a good break in what is normally a manic day!

All the people with...