| // Use Gists to store code you would like to remember later on | |
| console.log(window); // log the "window" object to the console |
| SELECT | |
| fg.data_space_id, fg.name, | |
| ObjectName = OBJECT_NAME(p.object_id), p.index_id | |
| ,df.name, df.physical_name, [Size] = df.size*8/1024 | |
| FROM sys.filegroups fg | |
| LEFT JOIN sys.database_files df | |
| ON fg.data_space_id = df.data_space_id | |
| LEFT JOIN sys.partitions p | |
| ON fg.data_space_id = p.partition_number | |
| WHERE (p.object_id>4096 or p.object_id IS NULL) |
People
 :bowtie: |
😄 :smile: |
😆 :laughing: |
|---|---|---|
😊 :blush: |
😃 :smiley: |
:relaxed: |
😏 :smirk: |
😍 :heart_eyes: |
😘 :kissing_heart: |
😚 :kissing_closed_eyes: |
😳 :flushed: |
😌 :relieved: |
😆 :satisfied: |
😁 :grin: |
😉 :wink: |
😜 :stuck_out_tongue_winking_eye: |
😝 :stuck_out_tongue_closed_eyes: |
😀 :grinning: |
😗 :kissing: |
😙 :kissing_smiling_eyes: |
😛 :stuck_out_tongue: |