Database Weekly

SQLServerCentral Editorial

How SQL Server Can Just Go Faster

  • Editorial

It’s rare to get a call from a customer telling you that the application is fast today and thanks for taking such good care of the database. Instead, you are more likely to hear complaints when things go wrong like slow running queries and timeouts. There is a lot to consider when trying to figure […]

(1)

You rated this post out of 5. Change rating

2019-11-30

593 reads

SQLServerCentral Editorial

A Faster tempdb

  • Editorial

I like to call tempdb the “workhorse” of SQL Server. I’ve heard some other people call it other terms that were not so flattering, but since I like to keep things positive, I’ll stick with workhorse. SQL Server uses tempdb for many things. The obvious uses are temp tables and table variables, but tempdb is […]

(3)

You rated this post out of 5. Change rating

2019-11-02

1,153 reads

SQLServerCentral Editorial

Which Service in Azure Should You Use for SQL?

  • Editorial

I remember when Azure SQL Database was first released in 2010. Microsoft has tweaked the name a couple of times over the years, and back then it was called SQL Azure. The largest database you could create was just 50 GB, and there were quite a few restrictions, such as heaps not being supported. Since […]

You rated this post out of 5. Change rating

2019-10-05

461 reads

Blogs

Creating a Pulsing Conducting Baton - Part 1

By

Train Wreck The last time I watched a high school band nearly fall apart mid-performance...

ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)

By

If you are considering any of the ISACA AI certs like the Advanced Artificial...

A Fabric solution can be very cost effective

By

Are you currently using Microsoft Fabric or considering migrating to it? If so, there...

Read the latest Blogs

Forums

Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit

By Sanket Parmar

Comments posted to this topic are about the item Why Your Index Isn't Being...

Distance Metric Algorithms

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Distance Metric Algorithms

What Can AI Really Do?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What Can AI Really Do?

Visit the forum

Question of the Day

Distance Metric Algorithms

What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?

See possible answers