As a SQL DBA, what do you do when a vendor application has performance problems that are code related? Server settings don’t generally seem to be an issue. Queries...
2024-05-20 (first published: 2024-05-02)
189 reads
In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles of writing SQL code to manipulate data. These styles have implications for performance, readability, and...
2023-12-18 (first published: 2023-12-01)
598 reads
What are you most concerned about in your database platforms? Please pick from the list below, and expand on your choice in the comments if you like: Thanks...
2023-11-08 (first published: 2023-10-25)
216 reads
Please continue doing your backups! Backups are Disaster Recovery, yes…but not HA. Some will argue with this (in the comments most likely), but I broadly define “High Availability” as...
2023-11-01 (first published: 2023-10-17)
327 reads
Problem: My PocketDBA® client called in with a non-responsive SQL Server. Application errors, timeout, alerts firing. SQL Server box is up, and the services are running. Background: This is...
2023-09-06
32 reads
Lets compare them anyway, just for fun. Both have an engine Both have a monitoring device (Dashboard/Activity Monitor) Both need power (Gas/Electricity) Both need to be told what do...
2023-09-05
30 reads
Every now and then we like to have someone do a guest post, with a topic of their own choosing. This time, we picked Kevin Miller (LI). Kevin is...
2023-08-21 (first published: 2023-08-01)
170 reads
Pain Point: Something bad happened and you need to restore a SQL Server database. Pain Point you didn’t know you had: The backup files are all corrupt due a...
2023-07-25
294 reads
(for your reading pleasure, written by Jules. –ed) We have all had that sinking feeling of defeat: you’ve just finished explaining a very important and highly technical thing to...
2023-07-05 (first published: 2023-06-20)
406 reads
“Work Smarter, not Harder” We’ve all heard it before, pretty much any job, anywhere. In our DBA slice of the IT world, this is very relevant to how we...
2023-05-08 (first published: 2023-04-28)
509 reads
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
By Steve Jones
dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...
By alevyinroc
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...
Signal:(@Remedy.73)Gbl wheel cleaner Israel Local supplier Telegram:(@Wheel202)Gbl wheel cleaner Israel domestic supplier Wire-ID:(@Math888) GBL...
Comments posted to this topic are about the item Getting the Schema for Tables
Comments posted to this topic are about the item An Unexciting Exciting Release
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; GOSee possible answers