Azure Database Support Blog
Copied!
Home
Options
385
Jose_Manuel_Jurado on 01-16-2020 10:28 AM
321
Jose_Manuel_Jurado on 01-15-2020 12:18 PM
366
Jose_Manuel_Jurado on 01-13-2020 08:18 AM
769
Jose_Manuel_Jurado on 12-30-2019 04:25 AM
1,045
Jose_Manuel_Jurado on 12-20-2019 04:06 PM
898
Jose_Manuel_Jurado on 12-20-2019 03:48 PM
562
Jose_Manuel_Jurado on 12-02-2019 02:02 PM
779
FonsecaSergio on 11-27-2019 09:37 AM
474
Jose_Manuel_Jurado on 11-18-2019 12:04 PM
609
Jose_Manuel_Jurado on 11-17-2019 04:42 AM
463
Jose_Manuel_Jurado on 11-15-2019 10:12 AM
657
FonsecaSergio on 11-15-2019 09:45 AM
497
Ricardo_NS_Marques on 11-06-2019 09:44 AM
684
Yochanan_MSFT on 09-16-2019 01:17 AM
491
Jose_Manuel_Jurado on 09-10-2019 03:57 AM
563
Jose_Manuel_Jurado on 09-05-2019 08:57 AM
371
Jose_Manuel_Jurado on 09-05-2019 05:30 AM
780
fercobo on 08-27-2019 10:00 AM
690
FonsecaSergio on 08-08-2019 08:25 AM
771
FonsecaSergio on 08-08-2019 07:41 AM
965
FonsecaSergio on 08-08-2019 02:44 AM
531
Jose_Manuel_Jurado on 07-23-2019 06:28 AM
438
Jose_Manuel_Jurado on 07-22-2019 08:59 AM
664
Jose_Manuel_Jurado on 07-17-2019 12:45 AM
604
Jose_Manuel_Jurado on 07-11-2019 04:16 PM
Latest Comments
This was very helpful while working on a query performance case. Good share!!
0 Likes
All of the vCore databases that I've tried return null when I try SELECT DATABASEPROPERTYEX('MyDatabaseName', 'MaxSizeInBytes').
0 Likes
@woodsy1978 - I didnt include this as parameter as I would recommend to use FullScan to get better quality for the statistics. however, this is T-SQL code so you can modify it for your needs. HTH, Yochanan
0 Likes
@Yochanan_MSFT does the script take SAMPLE or FULLSCAN as parameters. I couldn't see in the code, but just double checking if this was intentional or just not amended as such yet ?Thanks, Chris
0 Likes