Monica Rathbun

The FAST number_rows Query Hint

Query hints are always about tradeoffs—typically you are giving up something, such as flexibility, to achieve more consistency, or very specific performance characteristic. One example of this migt when...

2019-10-29 (first published: )

945 reads

New Event Calendar

Speaking Engagements Check out my new Event Calendar, to see my upcoming and past speaking engagements. You can catch me at various events throughout the year. If you are...


4 reads

Quick SSMS Tip

It is widely known that I am a horrible speller and hate to type code. I tend to use a lot of code snippets and reuse code to avoid...

2019-09-20 (first published: )

1,227 reads

Are My SQL Server Indexes Being Used?

Indexes can be incredibly beneficial to your database performance; however, they do come with a cost—indexes both consume storage space and affect insert performance. Therefore, it is important as...

2019-09-11 (first published: )

2,275 reads


Who needs data access? Not You!


With a little planning and care, we can find various ways to fulfill user...

Azure Synapse Analytics & Power BI performance


With two new relational database features (Result-set caching and Materialized Views) just GA’d in...

Session Evaluations from “SQL Server Security from the Ground Up”


I was recently given the opportunity to speak at Pass Summit. As always (this...

Read the latest Blogs


Moving a Default Schema

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Moving a Default Schema

Using the Lightweight Tools

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Using the Lightweight Tools, which...

Data drive

By Admingod

Data drive is full not the log space. If it is ldf then yes,...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers