ST

 

Excellence in SQL Server

  • HOME

  • EXPERTISE

  • CONTACT US

  • Blog

  • More

    • All Posts
    • AlwaysOn Availability Groups
    • Alerts
    • Trace Flags
    • Performance
    • Best Practice
    • Maintenance
    • Security
    • Configuration
    • Problems and Issues
    • SQL Server 2016
    • Tips and Tricks
    Search
    Adam Thurgar
    • Dec 6, 2019
    • 1 min

    Cardinality estimator

    Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a...
    4 views0 comments
    Adam Thurgar
    • Nov 27, 2019
    • 1 min

    Index fragmentation

    A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response...
    2 views0 comments
    Adam Thurgar
    • Nov 20, 2019
    • 1 min

    Deleting large amounts of data

    I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete...
    4 views0 comments
    Adam Thurgar
    • Nov 11, 2019
    • 1 min

    Statistics sampling

    DBA's and developers know the importance of having up to date statistics to ensure that query performance is optimal. Most of the time...
    6 views0 comments
    Adam Thurgar
    • Nov 4, 2019
    • 1 min

    Enable deadlock alerting

    One of the difficulties in dealing with deadlocks is actually knowing that they occurred and then getting information. Even if you have...
    4 views0 comments
    Adam Thurgar
    • Oct 24, 2019
    • 1 min

    Schedulers offline

    Whilst working with a number of SQL Server Standard edition installations I noticed that some schedulers were offline. This can be a...
    7 views0 comments
    Adam Thurgar
    • Oct 16, 2019
    • 1 min

    Power options and your SQL Server

    Although not part of your SQL Server install or configuration, the windows power setting can have an impact on the performance of your...
    3 views0 comments
    Adam Thurgar
    • Sep 25, 2019
    • 1 min

    Querying deadlock information XE

    One of the problems with dealing with deadlocks is first of all you have to be able to capture them and have the right trace flags turned...
    6 views0 comments
    Adam Thurgar
    • Sep 18, 2019
    • 1 min

    Default query in SSMS window

    I have a query that I run against a number of servers when doing weekly checks. Now I could run a single query against the local group I...
    4 views0 comments
    Adam Thurgar
    • Sep 9, 2019
    • 1 min

    Database Mail and Outlook 365

    Whilst setting up a server, we had to configure database mail. Usually a straight forward exercise but it ended up being a lot more...
    6 views0 comments
    Adam Thurgar
    • Aug 30, 2019
    • 1 min

    Windows 2016 server problem

    I was RDP'ing to a Windows 2016 server and when I got onto the server, the start menu and search windows didn't work. Supposedly a known...
    5 views0 comments
    Adam Thurgar
    • Aug 19, 2019
    • 2 min

    Multiple instances

    A hosting company called me to investigate an issue with their SQL Servers instances, one client was having issues with the application...
    15 views0 comments
    Adam Thurgar
    • Aug 6, 2019
    • 1 min

    Datto snapshots

    I was asked to look at a SQL Server by a business software solution company. Performance issues. I did a current system state assessment...
    6 views0 comments
    Adam Thurgar
    • Jul 31, 2019
    • 1 min

    Severity 016

    I got an alert recently from a Severity 016 error on a production system that I monitor. The error message was: "The query processor ran...
    53 views0 comments
    Adam Thurgar
    • Jul 23, 2019
    • 1 min

    Query store

    Whilst investigating performance issues on a SQL Server 2017 instance, I had made some recommendations to hopefully alleviate the issue....
    8 views0 comments
    Adam Thurgar
    • Jul 16, 2019
    • 1 min

    Whoisactive - logging table and schedule

    I have blogged previously about what a great tool sp_whoisactive is from Adam Machanic. Sometimes you may need it to be run regularly to...
    3 views0 comments
    Adam Thurgar
    • Jul 2, 2019
    • 1 min

    Shrinking tempdb

    I was asked to assist in changing the tempdb configuration on a SQL Server to use multiple files and to shrink the size down from a...
    6 views0 comments
    Adam Thurgar
    • Jun 21, 2019
    • 1 min

    No backups

    Whilst doing a current system state assessment for a client of their SQL Server fleet, I found a number of production SQL Servers without...
    6 views0 comments
    Adam Thurgar
    • Jun 10, 2019
    • 1 min

    Cold Data

    With a lot of databases being moved to the cloud, you need to think about the cost of storage. With differing tiers being available with...
    1 view0 comments
    Adam Thurgar
    • May 25, 2019
    • 1 min

    SQL Server Agent Tokens

    One of the good things about working with SQL Server is that you are constantly learning. It wasn't until very recently that I learnt...
    21 views0 comments
    {"items":["5deef2edd7fbe4001763f11b","5deef2ed8b49fe001895755e","5deef2ed652945001747a53b","5deef2eded13e00017ca28ee","5deef2ed37f4560017f537b1","5deef2ed37f4560017f537b2","5deef2edfa3b1f001807e6d8","5deef2ed60b38300175f4964","5deef2eded13e00017ca28ed","5deef2ed652945001747a53a","5deef2edf4b6e2001731fbc8","5deef2edb8ec9800172faf14","5deef2ed37f4560017f537af","5deef2eda16531001742cfc2","5deef2ed652945001747a539","5deef2ed60b38300175f4965","5deef2edfa3b1f001807e6d5","5deef2edaad2700017f22bed","5deef2edf4b6e2001731fbc7","5deef2edd7fbe4001763f11a"],"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":true,"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":940,"allowTitle":true,"allowContextMenu":true,"textsHorizontalPadding":-30,"itemBorderColor":{"value":"#C5C3C3"},"showVideoPlayButton":true,"galleryLayout":2,"targetItemSize":940,"selectedLayout":"2|bottom|1|fill|true|0|true","layoutsVersion":2,"selectedLayoutV2":2,"isSlideshowFont":false,"externalInfoHeight":0,"externalInfoWidth":0.5},"container":{"width":940,"galleryWidth":972,"galleryHeight":0,"scrollBase":0,"height":null}}
    1
    2345