Dallas DBAs

Blog Post

SQL Server Migration and Upgrade

(This post written by Jon Biggs (t), one of our Senior DBAs) We are currently performing migrations with upgrade of multiple-instance SQL Servers to new servers. The migrations are...

2022-03-22

27 reads

Blog Post

Group By Starting Characters

I was chatting with Jeff (b|t) on my team yesterday and the context escapes me but I had this thought: “Can you Group By the beginning characters, or a...

2021-10-29 (first published: )

475 reads

Blog Post

Do Full Backups Break Log Shipping?

TLDR: Nope. Keep on doing your full backups. Make sure that any databases you Log Ship are NOT also doing log backups in your SQL Maintenance Plans, Ola Jobs,...

2021-10-22 (first published: )

290 reads

Blog Post

How old are those stats?

SQL Server maintains a variety of stats about all sort of performance items. Index usage (or missing indexes) Query performance Corrupt pages Disk IO performance Way more than I...

2021-10-11 (first published: )

278 reads

Blogs

VMware & SQL Server 823-824 alerts

By

We’ve been tracking a weird state with SQL Server virtual machines on VMware and...

Daily Coping 18 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Storage Field Day 23 – SIOS

By

I am thrilled to have been a part of this year’s Storage Field Day...

Read the latest Blogs

Forums

need some help in tweaking a query

By bobrooney.81

Hi All, I am looking for some tsql help. I am from Oracle background....

SQL Server 2017 AlwaysON Secondary Replica use case

By vsamantha35

Hi All, I need some advice on Always on secondary replica usage. We are...

DENSE_RANK different sequences

By vilaca

Hi all, I have this data: Code               ...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers