Benjamin Nevarez

Benjamin Nevarez is a database professional based in Los Angeles, California. He has more than 15 years of experience with relational databases and has been working with SQL Server since version 6.5. Benjamin has been the technical editor of the two latest Kalen Delaney’s books including “SQL Server 2008 Internals”. He holds a Master’s Degree in Computer Science and has been a speaker at several technology conferences, including the PASS Community Summit. you can read Benjamin’s blog at www.benjaminnevarez.com.

SQLServerCentral Article

Inside the SQL Server Query Optimizer

This book will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.

4.67 (3)

You rated this post out of 5. Change rating

2017-02-06

27,135 reads

Blogs

AI Step 1

By

As this is an Artificial Intelligence (AI) World, things are changing. We can see that...

Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend

By

In a containerized app, React and Chakra UI provide a robust and accessible user...

A New Word: Nachlophobia

By

nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...

Read the latest Blogs

Forums

Lies You Should Believe - Anything is possible

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Lies You Should Believe -...

A Strange Query

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Strange Query

Primary and Secondary Filegroup

By nshete

Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...

Visit the forum

Question of the Day

A Strange Query

What does this return?

SELECT x=1 
WHERE (SELECT 1) IN ( 1, 2, 3)

See possible answers