Speaking of "stuck"... rumor has it that the good folks at SSC are going to start working on problems like the one I'm getting ready to experience when I hit...

Bummer.  And, yeah... them not "getting it" after all the issues is...

To this day I don't understand how come no one in IT saw the pattern that adding only a little more disk space and having that consumed within a...

The code probably worked perfectly on the OPs machine. ...

My apologies.  Apparently,...

If you would post the code you're using, perhaps we could solve all of your problems with a bit of a magic temporal formula that doesn't rely on any settings...

I think you may have a larger issue on your hands... It's a really bad idea to store temporal data as strings.

You'll probably need to look at Task Manager or Resource Monitor to figure out exactly what software is being executed there.  Do you have an infrastructure team that might know?

Thanks. I learned this at Redgate, where we had like 5 web frameworks at one point and realized that it took weeks...

I think it is a typo, they probably meant to type '-- = inv.tblSoftware'

Which would mean that inv.tblSoftware is just a comment for clarity, describing something about the insert...

First, I hope that you're taking a final full backup followed by a "Tail Log" backup to properly shut down a database prior to drop it.

As for determining if the...

I don't understand what you need to do. I presume that you don't want to union all query 1 with query 2. Do you need to left outer join...

We have a third part software and looking at some of their SQL we found this

INSERT INTO tblSoftware ( Inventory , Software, [Name] , Manufacturer , [Language] , [...

To be clear, do you mean the forum is on this SQLServerCentral site?  If so, could you provide a...

Ditto that.  In memory...