684 reputation
916
bio website
location Europe & Asia
age
visits member for 3 years, 4 months
seen 2 hours ago

Oct
15
comment Quickly edit MS_Description in SSMS
Well when you are using SSDT, you have the information in the source code as well. Sadly I feel that extended properties is another halve baked feature from MSFT, as many others. (right click on a table, select reports...., hint hint...)
Sep
26
awarded  Notable Question
Sep
17
accepted Best Practice in storage allocation for compressed and partitioned tables
Sep
17
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