Madeira Data Solutions
  • Home

  • About Us

    • Our Team
    • Customers
    • Join Us
  • Managed Services

  • Professional Services

  • Training Services

  • Content Hub

    • Blog
    • Webinars
    • Podcast- SQL SERVER RADIO
  • More

    Use tab to navigate through the menu items.

    Contact Us

    • All Posts
    • SQL Server
    • Podcasts
    • PASS
    • SQL Server 2012
    • Big Data
    • Cloud
    • Scripts
    • Blog
    • DMV's
    • Learning
    • Performance
    • SQL Server 2012
    • Conferences
    • Cursors
    • Plan Cache
    • SQL Agent
    • SQL Azure
    • High Availability
    • Productivity
    • Downloads
    • SQL Server 2014
    • SQL Server 2016
    • Webcasts
    • Videos
    • Troubleshooting
    • SQL Server 2017
    • Tools
    • SQLServerPedia Syndication
    • Storage
    • TempDB
    Search
    Guy Glantser
    • Mar 9, 2018
    • 2 min

    Which One is Better? IN or BETWEEN?

    0
    Madeira Team
    • Mar 2, 2018
    • 2 min

    Use Filtered Statistics to Improve Performance on Very Large Tables

    0
    Eitan Blumin
    • Feb 27, 2018
    • 3 min

    Planning to Increase Cost Threshold for Parallelism – Like a Smart Person!

    0
    Madeira Team
    • Feb 15, 2018
    • 1 min

    Extremely easy tricks to list table columns’ names and replace SELECT *

    0
    Madeira Team
    • Jan 23, 2017
    • 2 min

    Datediff: We’ve Been Doing It Wrong

    0
    Madeira Team
    • Sep 29, 2016
    • 1 min

    Performance-Oriented T-SQL Development in Belgium

    0
    Madeira Team
    • Jan 19, 2016
    • 5 min

    How to Solve the Tail Insert Problem

    0
    Madeira Team
    • Jul 21, 2015
    • 1 min

    Speaking about Columnstore Indexes at PASS Performance Palooza

    The PASS Performance Virtual Chapter has a tradition of yearly “Palooza events”, in which there are a few back-to-back online performance sessions by great speakers from all around the world. I have the honor to speak in this year’s Performance Palooza, which will take place this Thursday, July 23. I will speak about Columnstore, a technology that fascinates me and is a true game changer. The session is called Columnstore Indexes – Questions and Answers (click here to registe

    0
    Madeira Team
    • Jun 25, 2015
    • 1 min

    24 Hours of PASS: The Data Loading Performance Presentation – Slide Deck and Scripts

    Thanks to everyone who attended my 24 Hours of PASS session, The Data Loading Performance Presentation. It was a lot of fun taking part in such a special event. The slide deck and scripts I used in the session can be downloaded here. #sessions #performance #community #PASS

    0
    Madeira Team
    • Jun 3, 2015
    • 3 min

    The #1 Enemy of Data Loading in SQL Server

    0
    Madeira Team
    • Feb 24, 2015
    • 1 min

    Speaking at SQLBits and SQLRally

    Next week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and fun. SQLRally On Wednesday, March 4, at 4:45PM, I’ll deliver my session “Query Progress Tracking in SQL Server” at SQLRally in Copenhagen. The session talks about a big pain in our job: How can we know when a certain process will finish its execution? It covers the ways SQL Server allows us to track the progress of processes and queries, and exposes some fun inter

    0
    Madeira Team
    • Jan 22, 2015
    • 1 min

    Index Usage Statistics

    0
    Madeira Team
    • Jan 21, 2015
    • 1 min

    The Data Loading Performance Presentation

    0
    Madeira Team
    • Mar 5, 2014
    • 2 min

    A Community Challenge

    0
    Madeira Team
    • Jan 28, 2014
    • 1 min

    Know When it’s Good Enough

    0
    Madeira Team
    • Dec 10, 2013
    • 3 min

    T-SQL Tuesday #49: Using CXPacket Waits to Detect Query Bottlenecks

    0
    Madeira Team
    • Jun 26, 2013
    • 1 min

    This Can Be the Best Thing in SQL Server 2014

    New versions have bombastic and catchy features. But a lot of times, the little, hidden features are the ones that matter the most. I already wrote in the past about the small changes that make a difference in SQL Server 2012, and yesterday about the maturity of SQL Server 2014. Here’s another classic example for a feature nobody talked about that can make a huge difference. sys.dm_exec_query_profiles is a new DMV in SQL Server 2014. According to the documentation, this DMV:

    0
    Madeira Team
    • Jun 11, 2013
    • 4 min

    Nested Loops, Parallelism and Confusion

    0
    Madeira Team
    • Mar 20, 2013
    • 4 min

    The Axis Of Evil

    Views, table variables and local variables are great in terms of programming principles. But In terms of performance, they can be a honey trap: They don’t scream “DANGER!” like cursors or user defined functions, but they can cause serious problems very easily. That’s why I call them “The Axis Of Evil”. I know – maybe it’s a little extreme, but let me explain. Why Views Are Evil The truth is they are not. It’s the way people sometimes use them that is evil. Views are great for

    0
    Madeira Team
    • Jan 31, 2013
    • 1 min

    Querying Execution Plan XML For Inaccurate Row Count Estimates

    I read this awesome post by Joe Sack, titled “Detecting Cardinality Estimate Issues with sys.dm_exec_query_stats”. I was amazed by the beauty of his detection query, ran it on my environment, and discovered some interesting things. Then I revised it a little to reveal more information and filter out more irrelevant data. You can find the revised query below. For queries where the difference between the estimated and actual rows is greater than 30,000, It returns the batch tex

    0
    1
    2

    keep in Touch!

    JOIN OUR MAILING LIST

    CONTACT US

    4 Itzhak Ben Zvi, Hod-Ha'sharon, Israel 4537302

     +972-9-7400101

    info@madeiradata.com

    About Us
    Solutions
    Data Architecture Review
    DBSMART
    Database Health Check
    SQL Server Upgrade
    Join Us

    Privacy Policy

    • Google+ - White Circle
    • Facebook - White Circle
    • Twitter - White Circle
    • LinkedIn - White Circle