2011-09-22 (first published: 2009-10-21)
10,943 reads
Articles
Prepare for Disaster Recovery - Webinar #13
The SQLServerCentral webinar series continues with Steve Jones talking about the ways you can recover from disasters with a little preparation.
2011-09-22
1,990 reads
Temporary Tables in SQL Server
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.
2011-09-22
6,511 reads
An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper
Jeff Moden has been elected as the Exceptional DBA of 2011. Here, Jeff talks to Bob Cramblitt about the life of an exeptional DBA.
2011-09-21
2,062 reads
2011-09-20 (first published: 2009-10-14)
10,013 reads
SQL Server Memory Management Explained
Author Craig Outcalt takes a deep dive into the SQL Server memory allocation and how it competes with OS memory.
2011-09-20
15,443 reads
Removing HTML tags from text data using PowerShell
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.
2011-09-20
2,143 reads
Catching Deadlock Information in SQL Logs
This article presents a handy way to retrieve deadlock information in an ordered way from the error log.
2011-09-19
24,271 reads
TSQL Challenge 65 - Solving the Running Total Problem
This challenge invites you to solve one of the most common calculation challenges seen in applications that deal with financial -transactions.
2011-09-19
1,647 reads
Come to the Charleston PASS SQL Server User Group
The Charleston, SC PASS chapter is looking for speakers and new members. Read more and come to the Sept 20 meeting if you are near the area.
2011-09-19
1,647 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries
The Service Name
Comments posted to this topic are about the item The Service Name