Monica Rathbun

What’s a Key Lookup?

One of the easiest things to fix when performance tuning queries are Key Lookups or RID Lookups. The key lookup operator occurs when the query optimizer performs an index...

2019-04-17 (first published: )

612 reads

Dealing with Ugly Babies

One thing I learned while working as a database administrator over 17 years is the importance of teamwork across departments. Many times, we have to rely on network and SAN administrator to make changes to their environments in order to make SQL Server run more efficiently. There are times where the storage and network create […]

2019-02-25

48 reads

Blogs

Information Measurement with SQL Server Part 4.5: The Squared L2 Family of Distances

By

By Steve Bolton …………In the last two installments of this series of amateur self-tutorials...

Security Learning Pathway at PASS Summit.

By

This year PASS is trying something new at PASS Summit. There are going to...

Pathways to Progress

By

One of the most significant and hardest challenges we face as data professionals (or...

Read the latest Blogs

Forums

Help with a stored procedure

By sridharkannan7

I have a table "Mytable" containing a list of IDs. There is a web...

Shop New Adidas Yeezy 700 V2 Vanta on Cadysneakers

By stevenrowe98

Adidas Yeezy 700 V2 Vanta[/URL] rumors will be released until the end of this...

Need to perform leaf level aggregation

By morbius82000

So I have a DW with  a table with some pre-aggregated scores (not my...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers