Thanks for being so gracious!

I think BOL's just plain wrong. The SQL Server 2005 article says:

Is the style of the date format used to convert datetime or smalldatetime data to...

drew.allen (9/21/2011)

---

HowardW (9/21/2011)

---

You might want to recheck your facts. BOL says differently:

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

---

Input when you convert to...

Mike John (9/21/2011)

---

The "Style" 101 you have used in the convert is US dateformat so your conversion is working as MM/DD/YYYY

You could use style 103 if you want the...

The key point here is you're misinterpreting the optional Style parameter of convert. It is not for converting a character value input into a datetime using a specific style, it's...

Not sure that answers the specific question...

I've never seen this to be greater than the Max memory setting. What exactly does this output?

sp_configure 'max server memory (MB)'

There are a lot of prerequisites to minimally logged inserts (even with trace flag 610 turned on).

There's a good explanation here:

http://msdn.microsoft.com/en-us/library/dd425070%28v=sql.100%29.aspx

Are your inserts in clustered index order, or can they...

Thanks Grant - I think I have a reasonable idea about how virtual database works as it needs a SQL engine to function, but Object Level Restore Native allows you...

Yes, it looks a mess and can certainly be optimised, but I don't think anyone here's going to spend the hours required to pick through it all and refactor it...

I think he's suggesting to backup to somewhere off the server. You do take regular backups...right?

Yes, whatever you do to clear space in the data files, you'll need to run...

The theory does actually work, it would just be useful if 5 seconds of care was taken before posting to make sure it was formatted correctly. If you just remove...

If you're using this for commercial purposes, I'd recommend using a professional address cleansing service as the increased accuracy should pay for itself.

Many have API's that you can send data...

Just divide the two aggregate functions. e.g. :

CASE WHEN MAX(CASE WHEN type = 'D' THEN backup_size

...

How's that:

WITH latest_backup_CTE

AS ( SELECT database_name ,

...

I don't understand why you need FOR XML PATH in the assignment of q. Q isn't an XML variable and it doesn't appear you need an XML output, therefore the...

I strongly, strongly recommend that you do not back everything up to the same backup file - put in a timestamp as part of your backup name and have a...