Database Fundamentals #33: Check Constraints from the GUI
The other types of constraints are referred to as check constraints. They limit the data by defining a logical operation that checks the state of the data prior to...
2022-09-05
27 reads
The other types of constraints are referred to as check constraints. They limit the data by defining a logical operation that checks the state of the data prior to...
2022-09-05
27 reads
The single most important part of backups are not backups. The single most important part of backups are restores. It doesn’t matter a lick if you have 100, flawless...
2022-08-29
22 reads
One of the things I love the most about Platform as a Service when it comes to data is the fact that you get RDS backups, built in. Go...
2022-08-22
26 reads
I hear this one all the time: How do I find out who implemented object changes? I also get: Can I see the query that caused object changes? Let’s...
2022-08-22 (first published: 2022-08-08)
324 reads
Ah, Tim Ford. I remember the time we were sitting at Ruth Kriss Steakhouse trying to figure out which of the two of us was the dumbest person in...
2022-08-12 (first published: 2022-07-26)
254 reads
Grant takes a few lessons for database DR from a nuclear accident in the US.
2022-08-06
111 reads
I remember going into Andy Leonard’s session at PASS Summit in Denver. I’m not going to lie, it was kind of sparsely attended, so I got to sit up...
2022-08-02
15 reads
In the last Database Fundamentals post, I explained what a unique constraint was and how you can create them using the GUI. Using TSQL to create a constraint is...
2022-07-25
100 reads
Today Grant wonders why we spend so much time trying to learn about query tuning.
2022-07-23
326 reads
I honestly don’t know when or how I met Wendy Pastrick, but I’m so happy I did. Wendy and I have been friends for a very long time. Thank...
2022-07-19
25 reads
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
I am excited to host T-SQL Tuesday for the first time. I want to...
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Comments posted to this topic are about the item Measuring Productivity
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers