I do not worry about the drive letter, but I do go ahead at the time of creation to split filegroups so that if there is a shift in performance...

It seems to me that the Cloud Computing concept is geared toward and good for small to midsize groups that are starting up or that do not want to deal...

If we are talking about SQL Server doing what the virtual machines are doing underneath the covers, and there needs to be improvement there for true large volume scalabity, then...

We really have all of this available now. With virtual servers, we have multiple servers that host up to a virtual server that is seen by sql server. ...

I am ready for quantum computing on the cloud. Everytime I think about it my mind goes into time warp and I see multiple answers all at one time....

I think Steve has hit it on the head. It is not going to be for all apps or all forms of business. The risk, just like the...

Sql does tend to hold onto memory until it senses some other resouce needs it. Some of the other folks might have a good explanation of how sql uses...

No, nothing special ended up needing to happen. However, there was a bug that caused the standard 64 to overclock the memory sql server was using and then caused...

No sooner had I posted the baby blurb that I posted that I then read Steve Jones response.

Having a place to hang your hat, when being asked to...

I believe that a DBA set of guidelines could be useful. It would need to be handled by a vendor neutral group. SOX, HIPPA touch on data access...

You need to be sure to have a good realationship with your sys admins. With virtual stuff, at the database level, you do not necessarily see all of the...

If you had an exception, like a really unsuallly large load or update etc, that caused the log file to grow then perform the t-log backup and you can follow...

Thank-you:)

Should have added restore or reattach user databases.

Mark

You are welcome. My issue ended up being a typo

I should have had SQL_Latin1_General_CP1_CS_AS for the collation not GeneralCP1

Now how to script out the maintenance plans. 🙂

Mark