Filling in Data Potholes Redux: Tally Tables vs CTEs
In A Previous Installment
Re-Ducks
… our heroine (that’s me) rediscovered CTEs, specifically in the recursive style. That was in my post...
2011-01-04
1,110 reads
In A Previous Installment
Re-Ducks
… our heroine (that’s me) rediscovered CTEs, specifically in the recursive style. That was in my post...
2011-01-04
1,110 reads
This is not the HOP you are looking for.
I’ve been thinking about the upcoming 24HOP event planned for March 15...
2010-12-27
949 reads
Data: it can break your foot.
Imagine that you are writing a script that looks at data grouped by the minute....
2010-12-23
1,130 reads
The 12 days of SQL
Brent Ozar (blog | twitter) had an idea: a group of people should blog about writing which...
2010-12-21
700 reads
This week a question on the Twitter #sqlhelp hash tag reminded me of a detail of SQL Server that I...
2010-12-16
1,120 reads
This past Saturday I presented my shiny new Introduction to SQL Server Partitioning session at SQL Saturday 61.
There were two...
2010-12-07
690 reads
Note: Updated 10/28 based on conversation in the comments, and 12/10 with Denali info.
TSQL Tuesday #11: Misconceptions in SQL Server
This...
2010-10-12
990 reads
Yeah, you heard me.
Do you like to read?
“But Kendra, why would we want to grant developers read permissions? And why...
2010-08-16
914 reads
This month’s T-SQL Tuesday topic is hosted by Robert Davis and the topic is “How do you learn? How do you teach?...
2010-07-13
1,333 reads
Data Collection, Puppy Style
Update: Based on Bill Ramos’ comment below and a note on Twitter (thanks!!) I have added some...
2010-06-26
1,718 reads
I posted on Terraform and Azure SQL last year but wanted to see what...
A couple of days ago I was doing some cleaning on some Azure SQL...
I loaded some built-in sample data from Wide World Importers into a Fabric warehouse....
Not sure if this is the place to ask, but will give it a...
Is there a specific platform or website where I can verify the compatibility between...
Comments posted to this topic are about the item Truncate tables where Referential Integrity...
I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?
See possible answers