There are 3rd party tools that will do the job for SQL Server, things like GRIDScale, although they have been bought out. Basically you can scale the reads, but not...

Try COALESCE(column, '')

otherwise can you post the CREATE VIEW statement

On an upgrade, you should be rebuilding the indexes... I am pretty sure this is MS recommended or in BOL

Personally, I prefer not to run critical apps on virtuals. Past experience, shared resources, etc. I also prefer SQL Server instances to running a mass of virtual SQL servers.

One...

I have never been a fan of splitting the OS and SQL, especially on dedicated SQL Servers, seems silly. But until my dream of a SQL OS comes true, here...

I have had issues with the NT modified date in the past, which is why we always put the SQL date into the filename. 3rd backup tool/provider is not going...

got offered a position at SwiftCover, but tried driving the route from Redhill, hahahaa what a joke, so came to Switzerland instead 😀

Im the same, except Im Welsh...

What are the file names?

GilaMonster (10/8/2010)

---

That's still of no use. That number is not a SQL error number (which are between 1 and 50000). You haven't said what you're doing exactly? A maint plan?...

I would go for 2008. Loads of cool features to help...

auditing, filestream, extended events, policies, sparse columns, improved RS, improved mirroring, additional datatypes, etc, etc the list goes on. You...

Have a look in BOL at the PIVOT function, might do the trick for you.

SwiftCover by any chance??

Under SQL Server Agent, when you create a job step, you can specify the "Type" which can be Operating system (CmdExec). Might be worth a try... however, I am not...

Yeah, that looks like memory pressure... You release that the PLE counter will grow until the...