What about:

/*

-- Turn on XP_CMDSHELL if required

--

--allow advanced options to be changed.

EXEC sp_configure 'show advanced options', 1

GO

--Update the currently configured value for advanced options.

RECONFIGURE

GO

--Enable XP_CMDSHELL

EXEC sp_configure 'xp_cmdshell', 1

GO

--Update the currently...

Hi Nadrek,

thank you so much for all that information.

You would be quite disappointed as the databases I put this on are quite small (but it's a small organisation too, so...

There we go - I have now setup the following schedule:

Index optimize to take place every Sunday at 20:00:00

DatabaseIntegrityCheck - SYSTEM_DATABASES: every weekday and Sunday at 22:00:00

DatabaseIntegrityCheck - USER_DATABASES: ...

Hi Richard,

thank you very much for your answer.

I do indeed have a couple of DBs with FULL recovery model, so thanks for pointing out that important omission! :Whistling:

I wasn't sure...

Hi,

I ended up setting up the following schedule:

Index optimize to take place every Sunday at 20:00:00

DatabaseIntegrityCheck - SYSTEM_DATABASES: every weekday and Sunday at 22:00:00

DatabaseIntegrityCheck - USER_DATABASES: every weekday excluding...

Ok then - ticket closed 😛

Thanks for the reply, much appreciated,

B

Thanks a lot for that Grant! Very clear explanation and it took away my doubts about doing the right thing, so I will proceed with moving the files at my...

Thanks for your answer,

Very true, which is why I wanted to move them in the first place but what prompted my questions was the difference in speed between the drives.

Are...

:hehe: - you're right, image is (almost) everything.

Some of the FS companies I have worked for do have a bunch of SQL Server used for some purpose or another...

Thanks for that, good to have these in my back pocket 🙂 ... if anybody else has some interesting (Financial Services) references, it would be great to hear about them...

Hi,

I think that the AdventureWorks DB should really do the trick for you.

It comes with an installer, just run it, choose the DBs you want and 1 or 2 minutes...

GSquared (12/17/2012)

---

I could be misreading, but I don't think they intentionally ended up where they are. More of a "I followed the directions, but I'm nowhere near your house"...

As GSquared said:

It is still beyond me why...

so? ... did the suggestion work?

B

Why don't you take the initial select statement out of the transaction all together? ... just keep the update statements in the transaction if you need it.

HTH,

B