BLOG | pigeonsql

Dec 10, 2019
3 min

Downgrade SQL Server edition by In-Place method!

As SQL Server Administrator you will probably sometimes solve downgrade edition of SQL Server, for example from Enterprise/Standard...

37 views0 comments

How to find out estimated saving space for Data Compression for all tables in the database?

Filip Holub

Mar 7, 2019
1 min

How to find out estimated saving space for Data Compression for all tables in the database?

As I wrote, I need to find out for all user tables estimates size for the both types compression, ROW and PAGE. Therefore, I wrote this pret

34 views0 comments

Resumable Online Index Create in SQL Server 2019

Filip Holub

Jan 13, 2019
2 min

Resumable Online Index Create in SQL Server 2019

The Microsoft introduced with SQL Server 2019 CTP 2.0 new option in regards to Index Maintenance - Resumable Online Index Create. It allows

83 views0 comments

Filip Holub

Jan 10, 2019
1 min

SQL Server 2019: New features!

The latest SQL Server 2019 version is SQL Server 2019 (CTP) 2.2 which Microsoft announce at 10.12.2018. What is actually new in SQL Server 2

131 views0 comments

Filip Holub

Jan 8, 2019
1 min

How to configure Dynamic Data Masking?

DDM doesn't support following: Always Encrypted columns Filestream data Computed columns You cannot FULLTEXT index where DDM is implemen

67 views0 comments

Filip Holub

Jan 6, 2019
2 min

How to implement Always Encrypted?

Deterministic - This type always generates the same ciphertext for any plaintext value. This method supports grouping, indexing, joins point

87 views0 comments

How to identify memory bottlenecks in SQL Server with DMV?

Filip Holub

Dec 19, 2018
2 min

How to identify memory bottlenecks in SQL Server with DMV?

Page Life Expectancy(PLE) - This is number of seconds a when pages will stay in the buffer pool without references. In general, the minimal

473 views0 comments

How to increase data and log files by 25% of their total size for all databases?

Filip Holub

Dec 17, 2018
1 min

How to increase data and log files by 25% of their total size for all databases?

So, I wrote little script which based on table sys.database_files where we can find out a couple of informations for example size and name o

70 views0 comments

Problem after migration from compatibility level 100 to 120.

Filip Holub

Dec 14, 2018
1 min

Problem after migration from compatibility level 100 to 120.

QUERYTRACEON 9481 - This hint is used with compatibility level 120 and above for forcing cardinality estimator version 70, which means from

62 views0 comments

{"items":["5f6b975a093a1c00175dcf2b","5f6b975a093a1c00175dcf2c","5f6b975a093a1c00175dcf2d","5f6b975a093a1c00175dcf2e","5f6b975a093a1c00175dcf2f","5f6b975a093a1c00175dcf30","5f6b975a093a1c00175dcf31","5f6b975a093a1c00175dcf32","5f6b975a093a1c00175dcf33"],"styles":{"galleryType":"Columns","groupSize":1,"showArrows":true,"cubeImages":true,"cubeType":"fill","cubeRatio":1.3333333333333333,"isVertical":true,"gallerySize":30,"collageAmount":0,"collageDensity":0,"groupTypes":"1","oneRow":false,"imageMargin":32,"galleryMargin":0,"scatter":0,"rotatingScatter":"","chooseBestGroup":true,"smartCrop":false,"hasThumbnails":false,"enableScroll":true,"isGrid":true,"isSlider":false,"isColumns":false,"isSlideshow":false,"cropOnlyFill":false,"fixedColumns":1,"enableInfiniteScroll":true,"isRTL":false,"minItemSize":50,"rotatingGroupTypes":"","rotatingCropRatios":"","columnWidths":"","gallerySliderImageRatio":1.7777777777777777,"numberOfImagesPerRow":1,"numberOfImagesPerCol":1,"groupsPerStrip":0,"borderRadius":0,"boxShadow":0,"gridStyle":1,"mobilePanorama":false,"placeGroupsLtr":false,"viewMode":"preview","thumbnailSpacings":4,"galleryThumbnailsAlignment":"bottom","isMasonry":false,"isAutoSlideshow":false,"slideshowLoop":false,"autoSlideshowInterval":4,"bottomInfoHeight":0,"titlePlacement":"SHOW_ON_THE_RIGHT","galleryTextAlign":"center","scrollSnap":false,"itemClick":"nothing","fullscreen":true,"videoPlay":"hover","scrollAnimation":"NO_EFFECT","slideAnimation":"SCROLL","scrollDirection":0,"scrollDuration":400,"overlayAnimation":"FADE_IN","arrowsPosition":0,"arrowsSize":23,"watermarkOpacity":40,"watermarkSize":40,"useWatermark":true,"watermarkDock":{"top":"auto","left":"auto","right":0,"bottom":0,"transform":"translate3d(0,0,0)"},"loadMoreAmount":"all","defaultShowInfoExpand":1,"allowLinkExpand":true,"expandInfoPosition":0,"allowFullscreenExpand":true,"fullscreenLoop":false,"galleryAlignExpand":"left","addToCartBorderWidth":1,"addToCartButtonText":"","slideshowInfoSize":200,"playButtonForAutoSlideShow":false,"allowSlideshowCounter":false,"hoveringBehaviour":"NEVER_SHOW","thumbnailSize":120,"magicLayoutSeed":1,"imageHoverAnimation":"NO_EFFECT","imagePlacementAnimation":"NO_EFFECT","calculateTextBoxWidthMode":"PERCENT","textBoxHeight":0,"textBoxWidth":200,"textBoxWidthPercent":50,"textImageSpace":10,"textBoxBorderRadius":0,"textBoxBorderWidth":0,"loadMoreButtonText":"","loadMoreButtonBorderWidth":1,"loadMoreButtonBorderRadius":0,"imageInfoType":"ATTACHED_BACKGROUND","itemBorderWidth":1,"itemBorderRadius":0,"itemEnableShadow":false,"itemShadowBlur":20,"itemShadowDirection":135,"itemShadowSize":10,"imageLoadingMode":"BLUR","expandAnimation":"NO_EFFECT","imageQuality":90,"usmToggle":false,"usm_a":0,"usm_r":0,"usm_t":0,"videoSound":false,"videoSpeed":"1","videoLoop":true,"jsonStyleParams":"","gallerySizeType":"px","gallerySizePx":881,"allowTitle":true,"allowContextMenu":true,"textsHorizontalPadding":-30,"itemBorderColor":{"themeName":"color_12","value":"rgba(246,246,246,0.75)"},"showVideoPlayButton":true,"galleryLayout":2,"targetItemSize":881,"selectedLayout":"2|bottom|1|fill|true|0|true","layoutsVersion":2,"selectedLayoutV2":2,"isSlideshowFont":false,"externalInfoHeight":0,"externalInfoWidth":0.5},"container":{"width":881,"galleryWidth":913,"galleryHeight":0,"scrollBase":0,"height":null}}

2 3 4 5