.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

Are these in one filegroup or multiple filegroups?

I like Scott's approach but honestly, I'd avoid the LIKE. If this changes, it would likely be quicker to just update all rows inserted.

• This reply was modified 7 years, 1 months ago by Steve Jones - SSC Editor. Reason: wrong user mentioned

It's a strange setup for now. The forum software doesn't seem to align itself with users very well, so there should be some ticket in place to clean up times....

I believe what you're looking for is a 12 month counter, starting with the current month + 1 and moving backwards for 12 months. If I understand this, for any...

Definitely Freudian. I've done it a few times. Apparently, as much as I like Service Broker, I don't like Service Broker.

No, this is a simple form, not an interactive designer (yet).

We prefer to select answers so only one is correct, but we do support multiple correct answers. Be sure your...

Will do ,and apologies on the delay. Our migration expert has been on holiday and busy with non SSC stuff. The migration scripts seemed to run correctly this time, so...

OVER clause: https://docs.microsoft.com/en-us/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-2017

If you mean something like this, you can't do this:

declare @i int = 2;
select sum(a) over (partition by b
      ...