Do you mean expand the list in SSMS? No, the schema DMV is likely locked, and SSMS times out. You can create the table first, or you can try to...

Stop thinking NDF v MDF. This is filegroups that you're considering. The files in a filegroup all need to be the same size. The filegroups do not need to be...

I think they make plenty of money. Not sure how things work out, but the last time I see the SE/EE breakdown, it was 3:1 or 4:1. Since EE costs...

That's not correct. Moving Sally to a new role brings with it the need to maintain the access permissions in two places. If we add TableX, then we need to...

I've gone back and forth. I think you need to decide if you're training or presenting. The more you are trying to actually teach a concept someone can use, the...

I'm torn on Express. I've seen no shortage of people trying to use this for production loads, cramming in data where they can or using it for short term holding...

While I can't run Standard Edition due to requirements to use TDE, I think MS might be wise to consider setting the hardware limits the same across all the...

To what? The storage limit exceeds any known database, AFAIK

.NDF files are explicitly created. Nothing to do with fragmentation. Usually you create multiple files to split the load for the filegroup to multiple spindles, or because you want to...

In one filegroup, you want to have the files the same size. Otherwise you have different data being written at different rates according to the proportional file fill.

https://www.sqlskills.com/blogs/paul/investigating-the-proportional-fill-algorithm/

If these are...

Please don't continue to ask different questions in the same thread. Add a new thread for different questions. If this is on space, please title that way.

You can grow your...

Would love to go to ATL, but was in LA this week, Austin next week, so can't take more days away from home. No real desire to either.

My schedule for...

I think it's to not *have* to go to a...

I'm a moron. Was responding to Sue H in another thread and that was on my mind when I read Scott's post. I try to avoid triggers, but if users...

You should read books online and ask specific questions if you have them. This isn't the place for someone to provide you with a project plan: https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/upgrade-a-sql-server-failover-cluster-instance?view=sql-server-2016