Data cleansing is something that constantly occurs in all RDBMSes, not just SQL Server. However it's easier on some platforms than others. New Author Sureshkumar Ramakrishnan has written a script that shows how you can easily remove duplicate rows in SQL Server. Read about his technique and see if it might come in handy in your environment..
The SQL Server tools are top notch and often other platforms attempt to duplicate their handiness. Enterprise Manager is one that every DBA uses and it can perform a myriad of functions to configure your server. Read this new article by Dale Elizabeth Corey that looks that the wide range of items in the Configuration Properties of this tool.
When transferring a database to a new server, you are bound to experience a user problem. In this article by Neil Boyle, he shows you how to transfer passwords and accounts seamlessly to a new server.
Another article from our own Chris Hedgate! This one looks at the different types of fragmentation that can exist inside your SQL Server and some ways you can go about minimizing them.
We crossed the 500,000 member mark last week and we're looking to give away some prizes!
New Author! And long time reader - Jeffrey was site member #712, almost 3 years and 130,000 members ago! This article describes the skills needed to progress from junior to intermediate to senior DBA.
Robert is our expert on dynamic sql. This week he offers some good hints for planning the contruction of a proc that will use dynamic sql. He also adds some suggestions on how to format the code so that when you return to it later, you can figure out what you were doing!
Index Creation Guidelines for SQL Server can be pretty sparse. Usually there are a couple, clustered index for ranges, nonclustered, etc. Leo Peysakhovich has taken some time to write down his guidelines based on his experience for creating indexes and the rational for doing so. He's also taken a few minutes to look at which indexes NOT to create, something that might be worth knowing..
Mail processing in SQL Server 2005 has changed substantially, including a new name, DBMail! Corey Bunch birngs is an introduction to this new subsystem, including HTML formatting.
This article by Andy warren shows you how to get started with DMO using either VB or VBScript. The article includes sample code that will backup all databases on a server and will update the statistics on all databases as well.
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item Optimism Without Illusion or Why...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers