database performance

SQLServerCentral Article

GENERATE_SERIES() Breaks Minimal Logging

  • Article

tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very early in my database career, I taught myself how to make lot’s of rows of Random Constrained Data in a comparatively short time. With the help of a few good folks over time, the method has been […]

5 (9)

You rated this post out of 5. Change rating

2023-09-18

3,774 reads

Blogs

A New Word: Tangency

By

tangency– n.  a fleeting glimpse of what might have been. I tend to live...

Join me at the Microsoft Fabric Community Conference with a discount code

By

I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...

Is Your Business Truly Ready for AI?

By

The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...

Read the latest Blogs

Forums

Sync SQL Server and Kafka in real time

By Adelia

Hello, Let say, my .NET API has been inserted successfully into SQL Server Database....

Several Questions: Relationships and SSMS and Data Diagrams

By Ahr Aitch

I'm struggling setting relationships among tables.  I understand the one-to-many, many-to-one, many-to-many, and self-referential...

Query Help to show record in single row

By sqldba20

Hi All, need help with an SQL query. We have an existing table that's...

Visit the forum

Question of the Day

Counting Bits III

What is the output of this code in SQL Server 2022?

select bit_count(0xEF)

See possible answers