T-SQL

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,748 reads

SQLServerCentral Article

Performance Tuning with SQLFacts Tools

  • Article

The need for performance tuning your SQL Server workloads has never been more critical. As workloads are moved into cloud services, their efficiency has a direct impact on the recurring bills. A workload that consumes more resources than necessary costs more to host in the cloud and affects the bottom line for your organization.

5 (3)

You rated this post out of 5. Change rating

2023-04-07

10,772 reads

Blogs

Another AI Faux Pax

By

I was experimenting with a local model (article) and as a part of this,...

Monday Monitor Tips: Using the PowerShell API

By

Redgate Monitor has grown tremendously from its early days and I find many customers...

Data Governance: The Invisible AI Accelerator

By

The post Data Governance: The Invisible AI Accelerator appeared first on Joyful Craftsmen.

Read the latest Blogs

Forums

Problem with the dll (version 1.2) of an Extended Stored Procedure with SQL Serv

By SKEITA

SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849 Our Extended Stored Procedure...

PK violation in replication but only one subscriber

By cphite

We have a publication with three subscribers; it's basically a part list with around...

Recovery Takes 10-20 mins with ADR enabled

By VastSQL

Hi Experts, I have database about 300GB in size with ADR enabled but after...

Visit the forum

Question of the Day

Data API Builder Operations

What types of database operations does the Data API Builder support?

See possible answers