While it's not likely that many of you need to find prime numbers using T-SQL, it is an interesting programming exercise. SQL Server guru Kathi Kellenburger brings us one solution after taking a break over the holidays and reading some popular fiction.
2008-01-01 (first published: 2007-01-29)
7,397 reads
Rumor has it that Concatenation functions have gotten the nasty reputation of being "performance hogs". Here's why that's not true.
2008-01-01
22,441 reads
Greg Larsen discusses the different options available within SQL Server 2005 for managing security.
2008-01-01
2,853 reads
Buck Woody discusses the hard-earned knowledge and experience that you'll need to gain in order to stand out as a and professional and exceptional DBA.
2007-12-31
8,085 reads
When loading a data warehouse, handling the ETL process of working with files can be problematic. Longtime DBA Janet Wong brings us an interesting solution that is flexible and efficient for quickly loading a number of files into a warehouse using DTS.
2007-12-31 (first published: 2007-01-23)
9,958 reads
Interviewing, Google as a monopoly, Cumulative Update 5 and more.
2007-12-31
119 reads
Get a high-level overview of the benefits of the extensibility framework in SQL Server 2005 Analysis Services that allows independent software developers to easily integrate new data mining algorithms into the product.
2007-12-31
1,647 reads
We've got a new contest running for the next week just for your production DBAs. Win a prize just for telling us a story.
2007-12-28
2,640 reads
If you are a SQL Server DBA, you realize that the performance of cursors is not great and they should be avoided where possible. One place it is difficult to avoid cursors is individual row processing within a trigger. Amin Sobati brings us a new article that shows just how you can avoid this.
2007-12-28 (first published: 2006-12-07)
47,989 reads
In working on an existing database, DBAs often look to normalize tables and correct obvious flaws in design. Recently Andy Warren was working on a consulting project and realized that defaults would prevent many issues.
2007-12-28 (first published: 2007-01-04)
7,193 reads
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item SQL Server Still Wins
Comments posted to this topic are about the item DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers