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)
340 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)
227 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)
203 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)
208 reads
2022-09-26 (first published: 2018-03-16)
361 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)
306 reads
2022-05-16 (first published: 2018-01-15)
290 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)
233 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)
204 reads
2021-01-19 (first published: 2018-01-23)
344 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers