The identity property, if that's what you are referring to, is optimized and will be faster than a routine you write.

That being said, this is a simple CLR routine...

If you lose the MDF, not sure you can take a tail log backup.

The MDF is the data, the LDF is the log records SINCE the last checkpoint. It's not...

If you lose an NDF, if it's in a separate filegroup and you have performed filegroup backups, you can restore just that one, potentially.

If you lose an NDF, likely you...

Chaniging the isolation level? Move that table to faster disks? Not sure what you can do here, Seth.

I'd argue that a large CRM/ERP application without FKs is just poorly designed. There are all sorts of support/administrative contracts in place to prevent you from working with the data...

I would think that it could delete the backups, but perhaps it's looking in msdb for something.

What I'd suggest is that you look for a script with Powershell or VBScript/FileSystemObject...

The CONVERT or a CAST as shown above is what you need in the query to change the data types so that you can group them.

you might want an ORDER BY at the end as well.

Grouping by multiple columns allows you to count unique values.

But I don't suspect SQL Server 😉

I guess it depends if you know what one is!

To be fair, that could easily be a typo. I know Word helps me with teh all the time.

I believe Paul and Jason are correct. I've been working with the product since v4.2, and while I don't remember it there, I believe from v6.0 on, it was always...

If you read the goals of the program, that's what it is. Make effective decisions around design and deployment and operations. Really an "it depends" type of cert.

Which is good,...

I haven't gone through Brent's Blog on it, but I doubt they have a lot of T-SQL taught. I think it's more details on the SQL Server core product, behaviors,...

Just a quick note to say I concur with Jeffrey. I think he's explained it well.

If you ran a bunch of large queries on that one instance, likely the...

If it's not version specific, then you'd need to note which version you passed on , and also have documentation of CE for future versions.