A DBA horror story in database file extensions.
4September 30, 2021 by Kenneth Fisher
CREATE DATABASE [Story]
ON PRIMARY
( NAME = N'Story', FILENAME = N'C:\Data\Story.mdf', SIZE = 101MB),
FILEGROUP [Line1]
( NAME = N'File1', FILENAME = N'C:\Data\_.It', SIZE = 102MB),
( NAME = N'File2', FILENAME = N'C:\Data\_.was', SIZE = 103MB),
( NAME = N'File3', FILENAME = N'C:\Data\_.actually', SIZE = 104MB),
( NAME = N'File4', FILENAME = N'C:\Data\_.the', SIZE = 105MB),
( NAME = N'File5', FILENAME = N'C:\Data\_.databases', SIZE = 106MB),
( NAME = N'File6', FILENAME = N'C:\Data\_.fault', SIZE = 107MB),
( NAME = N'File7', FILENAME = N'C:\Data\_.!', SIZE = 108MB),
FILEGROUP [Line2]
( NAME = N'File8', FILENAME = N'C:\Data\__.The', SIZE = 109MB),
( NAME = N'File9', FILENAME = N'C:\Data\__.End', SIZE = 110MB)
LOG ON
( NAME = N'Story_log', FILENAME = N'C:\Data\Story_log.ldf', SIZE = 111MB);
GO

🙂 Agree. It is always databases’ fault! Thanks for the joke!
🤣
People who liked this might also like “Revenge: The SQL!” 🙂
https://sqlbits.com/Sessions/Event12/Revenge_The_SQL
Oh yes, Revenge the SQL is awesome.