-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLEspresso

Monica lives in Virginia and is a Microsoft MVP for Data Platform. She has over 15 years of experience working with a wide variety of database platforms with a focus on SQL Server. She is a frequent speaker at IT industry conferences on topics including performance tuning and configuration management. She is the Leader of the Hampton Roads SQL Server User Group and a Mid‐Atlantic PASS Regional Mentor. She is passionate about SQL Server and the SQL Server community, doing anything she can to give back. Monica can always be found on Twitter (@sqlespresso) handing out helpful tips.

Archives: October 2018

How Much Will Compression Really Gain Me?

Did you know compression can gain you more than just space on a disk, it can allow you to fit more data into the buffer pool? That means queries have faster and more efficient reads which can help reduce I/O. It is a performance tool I highly recommend you consider… Read more

1 comments, 2,230 reads

Posted in SQLEspresso on 31 October 2018

Keeping Large Table Statistics Current -TF2371

Statistics are the magic ingredient that helps the query optimizer create its best guess for generating an execution plan. Keeping statistics as accurate as possible will give the optimizer the information it uses to calculate estimated costs and cardinality, which enables it to properly allocate resources such as memory grants.… Read more

1 comments, 2,478 reads

Posted in SQLEspresso on 24 October 2018

How to Start Speaking

At the last few events I attended, I’ve gotten into conversations on how to begin as a speaker. So I thought I’d share some of my advice that I provided to them.

First and foremost, get your first talk scheduled. Reach out to your local user group and ask to… Read more

1 comments, 196 reads

Posted in SQLEspresso on 17 October 2018

SQL Server Data Collection and Management Data Warehouse

We all have the need to collect system and performance information regarding our SQL Servers. Some of us use third-party tools, SQL Trace, or a homegrown solution.  Did you know Microsoft has a built-in tool to help you accomplish this? It’s called Data Collection and the data it collects (collection… Read more

4 comments, 2,306 reads

Posted in SQLEspresso on 3 October 2018