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...

Last night I spent 45 minutes composing a complicated question here. When I finished I started the review, and then Chrome, crashed. Thanks, Chrome. This isn't the only time...

...

I've sat in management meetings where people have expressed frustration that people don't auto-magically know stuff and that surely something is common sense.  The people outside of the...

I've into the questions posed here many times.  That's why I'm so careful at interviewing my future employers. 😀 😀 😀

To Steve's point, you should eventually get well-practiced enough to...

1. How many Megabytes does your current 50 million row table have for the Clustered Index?
2. How many rows per batch will typically be inserted into the table?

Is your friend using THROW along with a check on the number of transactions to force a ROLLBACK.  Also, is your friend using SET XACT_ABORT ON as a setup step...

First (trying to save your career here), if this column isn't encrypted with a lengthy salt, someone will beat on you soon.  Hopefully it will be an auditor and...

Hi Mr. Brian,

Thanks for your reply.

Since this is a non-production/non-critical database, it's in a development sandbox, I been running CHECKDB once a monthly or as needed.  Would you recommend...

Haven't tried it but looks great... Welcome aboard!

Did you ever think that Moses was the first person to download data to a tablet from the cloud?  And he got all the commands we'll ever need to...