In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you provide some cursor examples?
2008-10-21
5,907 reads
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
2008-10-20
71 reads
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
2008-10-20
75 reads
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
2008-10-20
62 reads
Kalen Delaney has a series on internals and performance taking place in Hertfordshire soon. If you register today, you can still save 20%
2008-10-20
1,121 reads
Solve your SQL Server error, problem or installation failure with this advice. Learn how to fix SQL performance errors and suspect data recovery problems.
2008-10-20
3,381 reads
Learn how executing frequent backups and maintaining healthy transaction logs in SQL Server leads to quick recovery. Failing to do so can mean having to re-enter a lot of data.
2008-10-20
3,238 reads
The loss of data is getting ridiculous. Steve Jones wants companies and government to do something about it.
2008-10-18
509 reads
With all the concern over the economy lately, Steve Jones talks about about finances and tries to bring perspective to those of us in the real world.
2008-10-18
66 reads
With all the concern over the economy lately, Steve Jones talks about about finances and tries to bring perspective to those of us in the real world.
2008-10-18
76 reads
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Comments posted to this topic are about the item Checking the Error Log II
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers