The reason I added this, and a few other questions, is that you may run into this and should understand how it works. Knowledge might be helpful and the discussion...

The question asks how many rows are returned from sys.objects. There is only 1. This is accurate and correct.

As to why or where you would use this, I'm...

In that case, what do you think this means for normalization? If I remove the department groups, what effect does that have on:

a) no repeating groups and...

Thanks for answering your own question and glad you figured it out.

I would agree with Sue. Somewhere in the code used to call the procedure, it's incorrect.

I think you have this right. Only one billing address wanted, and only available once the employer has been set and the bank account exists. Essentially you have a vertical...

You've changed the query. In your first note, you want the difference between max(totalspace) and min(). In the  last one, you've added max(usedspace). If you want this, you need to...

Sounds like some sort of test question for you. I think there is an answer for both 1 and 2, but what do you know or what have you done?...

I'd add the new rows before deleting the old ones. You can use SET IDENTITY_INSERT for this. I'd do an insert..select from the old row, replacing the identity with the...

Good links, but short answers:

HA is about ensuring availability of a resource, this often uses multiple nodes to ensure we can access a resource if one node...

I was speculating, and certainly understand the strange circumstances. I like saving scripts of what I've done, and glad you used Notepad. Heplful to reproduce things.

The only use I've seen is two servers that would move data to each other and each used 2, with one generating odd numbers and one even. It was a...

I'd be concerned that someone mucked with storage coincidentally.

I'd also make sure if you're doing this, you use a script and save it, just to be sure you...

Do you mean the data from msdb.dbo.backupset? Are you attempting to use this to make a restore easier?