Temporary tables are used by every DB developer, but they're not likely to be too adventurous with their use, or exploit all their advantages. They can improve your code's performance and maintainability, but can be the source of grief to both developer and DBA if things go wrong and a process grinds away inexorably slowly. We asked Phil Factor for advice, thinking that it would be a simple explanation.
Jeff Moden has been elected as the Exceptional DBA of 2011. Here, Jeff talks to Bob Cramblitt about the life of an exeptional DBA.
As we look to take more data from customers and clients and embed it in our applications, data quality becomes a bigger issue
This editorial was originally published on Feb 7, 2006. Today Steve Jones looks at the problems of plagiarism and the avoidance of work by many people these days.
Author Craig Outcalt takes a deep dive into the SQL Server memory allocation and how it competes with OS memory.
There are situations when you may need to remove HTML tags from your character string data. PowerShell will let you "clean" the string data and export the result to a .csv file in a single step.
This article presents a handy way to retrieve deadlock information in an ordered way from the error log.
This week Steve Jones dreams about the changes he would like to see in the next version of Windows, unveiled this past week at the Microsoft Build Conference.
This editorial was originally published on August 22, 2006. Steve Jones looks at the pace of change in companies and notes it ought to be dictated by the business, not IT.
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
phone/Wa, Cs. 0817844112 Jl. Sam Ratulangi No.17-19, Wenang Utara, Kec. Wenang, Kota Manado, Sulawesi...
phone/Wa, Cs. 0817844112 Jl. Andi Makkasau No.34, Kp. Pisang, Kec. Soreang, Kota Parepare, Sulawesi...
phone/Wa, Cs. 0817844112 Jl. Jenderal M.t. Haryono No.95, Bende, Kec. Kadia, Kota Kendari, Sulawesi...
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers