Additional files can be added to to a database to increase the storage. When more data is added to the files, Extended Events shows how SQL Server spreads data across multiple files.
2017-11-03 (first published: 2016-07-25)
4,637 reads
2013-12-03
1,924 reads
As databases grow, it often becomes necessary to add new I/O paths to accommodate the growing space. Even without growth that requires this scale, it can still be useful to utilize multiple I/O devices to spread out the load. One way that you can make optimal use of new drives is to add a filegroup to the database and move certain objects (say, all of your indexed views) to the new filegroup.
2013-02-11
3,176 reads
This script copies all tables found in a specific filegroup to another specific filegroup.
2009-08-19
78 reads
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...
By Steve Jones
It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m...
By Brian Kelley
I mentioned this in my talk on Quantum Computing at the PASS Data Community...
Comments posted to this topic are about the item The Ending Substring
Comments posted to this topic are about the item Done is Better than Good,...
Comments posted to this topic are about the item Configuring the On-Premises Data Gateway:...
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers