This is actually fascinating. I need to test, but a rebuild should (with rebuild with drop existing) spread the index across all four files. Note that if you have space,...

Please repro this with a new db and provide the code. The EXECUTE AS USER maps to a user. What user is mapped in your database.

It seems like you want a table where the flags auto update based on that current date. I think you might better phrase what you're trying to do and show...

Let me give you a small overview. If you have a filegroup, SQL Server tries to write to all files in the filegroup. I assume you have 1 filegroup now...

Please send a note to the webmaster (webmaster@) to chase this down. Use your subscription email or make a note in the email.

Also network segmenting - https://www.sqlservercentral.com/editorials/segments-for-protection

Committees in most cases, perhaps an individual in some, but likely some group.

I think T-SQL, probably SQL as well, are horribly broken in their models. The whole "Create" "ALTER issue...

Glad I could help you learn something.

I'm very lucky with the job I have at the moment (which is not a support role), but I keep wondering what's next given all that I've just said....

I think I have some minor gift, in that the logical way a CPU processes things and the flow of information and data in most systems seem to make sense...

Usually these are just tables with two dimension columns for a many:many relationship. I suppose if you wanted to add some measure in here, like weight, you could.

It's not completely clear what you're describing here. I think you're making this confusing in some sense. Forget about VMs for a second and treat these as machines. The VM...

Note, this isn't likely to help you answer the questions if you don't do more research. I'm happy to help, but I'd like to see you make an effort to...

This sounds like a set of interview questions, but here goes:

1. I have code that needs two parameters used in the call (query, proc, etc.). I have a stored procedure...

Two places:

• Brent Ozar: https://www.brentozar.com/training/
• sqlSkills - https://www.sqlskills.com/sql-server-training/