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
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
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
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
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 can be a good idea, but they can also be a mess to maintain.
2022-05-30 (first published: 2018-02-27)
298 reads
2022-05-16 (first published: 2018-01-15)
260 reads
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
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
By gbargsley
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs...
By Chris Yates
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital...
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
Hi everyone, I’m fairly new to working with SSIS in SQL Server 2005, and...
I’m working on a jewelry e-commerce project and need advice on designing an efficient...
Comments posted to this topic are about the item The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers