654 reputation
816
bio website
location Europe & Asia
age
visits member for 3 years, 2 months
seen 13 hours ago

13h
accepted Best Practice in storage allocation for compressed and partitioned tables
13h
accepted Check progress of alter index reorganize / rebuild
Sep
12
comment Check progress of alter index reorganize / rebuild
Thanks for the nice script, I had to adjust the where clause to 'DBCC' but then I got some information back, saying that percent complete is 6.42 and the ETA Min are around 707 (which is for one partition). I will keep an eye on it on how far of this will be. Will check the post as well.
Sep
12
asked Check progress of alter index reorganize / rebuild
Sep
12
asked sys.dm_db_index_physical_stats is extremly slow
Sep
10
awarded  Nice Question
Sep
10
awarded  Notable Question
Aug
26
awarded  Notable Question
Aug
22
awarded  Popular Question
Jul
28
comment Page compression not working?
Based on your information I had a look and things look like this: Partition 45 Size with current compression settings 54642000 KB Size with requested compression settings 29561320 KB page_count 6792353 compressed_page_count 6354979 So I would expect SQL Server 2012 to compress these pages, but for some reasons it doesn't do it. This behaviour will cost me around 10-15 TB disk space wasted (since the db runs in an Avalability Group with 3 nodes). :(
Jul
25
asked Page compression not working?
Jul
2
awarded  Inquisitive
Jul
2
awarded  Curious
Jul
1
awarded  Yearling
Jun
25
answered Cube processing either takes too long or fails
Jun
23
asked Best Practice in storage allocation for compressed and partitioned tables
Jun
19
awarded  Popular Question
Jun
3
awarded  Popular Question
May
28
comment How to get usage based optimization working on SSAS?
I created the table under dbo, however the SSAS is still logging to the table under service account schema, and the wizard is telling me the table in the dbo schema is obviously empty.
May
27
asked How to get usage based optimization working on SSAS?