New Search

If you are not happy with the results below please do another search

42 search results for: performance tuning

31

Contact Us

You are one step away from getting the help you deserve. We are all passionate about the Microsoft Data Platform, SQL Server, Azure. We love to solve problems, architect solutions, and share our knowledge with your team. Go ahead and fill out the contact form below and we will get in touch with you shortly.

1464 East Whitestone Blvd.
Suite 1902
Cedar Park, TX 78613, USA.

+1 512 872 5320
Mon-Fri, 9am until 5pm

info@procuresql.com
We always reply within 24 hours

34

Best Hidden Feature in SQL Server 2019

With Microsoft’s Ignite conference this week a lot of new features are being advertised all over the internet.  Most likely if you are following along you have heard of Big Data Clusters, Spark, Performance Tuning, and security features.  I am really excited about this new feature and hope you are as excited about it too. […]

37

SQL Saturday Chicago

Last weekend I had a blast speaking at the SQL Saturday in Chicago. It was awesome to share my knowledge and also catch up with some good friends.  My talk was on Automating the Pain Away with Query Store and Automated Tuning.  I hope this session helped people understand Query Store and Automated Tuning as […]

38

Does Automation Kill the DBA “Store”?

  In my opinion, automation will enhance DBAs.  It will allow DBAs to provide more value to the business.  Good DBAs will be fine.   If you are a DBA with ten years of DBA experience who just repeats year one ten times, this might be a different story for a different blog post.  Therefore, automation enhances […]

39

Query Store 101

Today I heard a great analogy, and it inspired this post. Execution plans are like flight plans, there are multiple flight paths that can be taken to get from where you are to your ultimate destination. Some plans are more efficient than others, and we want to use those whenever possible. How can I make […]

The post Query Store 101 appeared first on dbWonderKid.

40

Clustered Index vs Heap

What is a heap? Heap was actually named pretty accurately. It is a “pile” of unsorted/unorganized data. A heap will exist on any table that lacks a clustered index. Heaps can exist even if you have a non clustered indexes. The main advantage to a heap is the speed at which you can insert data […]