I may need to re-think the use of table variables
Table variables have been fixed in SQL 2019, so now I have to decide if I will use them again.
2024-07-26 (first published: 2018-12-11)
326 reads
Ben Kubicek
- Interests: Jesus, playing guitar singing, most sports, running, biking, triathlons
What do you do or think about on the way to work?
I recently changed jobs and my commute time doubled, I found myself with more time to think and I started asking questions.
2023-09-11 (first published: 2016-10-10)
223 reads
What motivates you to do your best?
In today's guest editorial: the motivation to do our best must come from within.
2023-04-07 (first published: 2017-02-17)
193 reads
What do you do to relax after work?
Is the stuff we do in our off hours truly relaxing or just taking up time?
2022-12-09 (first published: 2017-03-31)
201 reads
2022-09-26 (first published: 2018-03-16)
351 reads
Audit systems: a good idea or a mess to maintain?
Audit systems can be a good idea, but they can also be a mess to maintain.
2022-05-30 (first published: 2018-02-27)
300 reads
2022-05-16 (first published: 2018-01-15)
260 reads
To-do list: good, bad or indifferent?
Using a list to keep track of what you should work on is only as good as the plan or goal behind it.
2021-10-15 (first published: 2017-08-07)
219 reads
You know what we really need? Better interpersonal communication
Today we have a guest editorial as Steve is traveling. Ben Kubicek notes that sometimes it is hard for technical people to communicate well.
2021-03-03 (first published: 2016-09-08)
198 reads
2021-01-19 (first published: 2018-01-23)
333 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend....
Forums
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Tables with a SPARSE Column and Consumption
Comments posted to this topic are about the item Tables with a SPARSE Column...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers