Featured Article(s)
Tips for using SQL Server 2005 Database Console Commands (Part 1)
In this article, Alexander Chigrik shows how you can optimize SQL Server 2005 performance by using database console commands.
Food For Thought…. Indexing, Full-Text Indexing
I’ve been seeing a somewhat odd trend of late as we’re looking over applications both internally and externally. As we look through the applications, especially the search-type functions, we’re look at re-doing indexes to support new uses of the system. Essentially, the users of the software have evolved in their use of the software – in some cases in directions we anticipated, in other cases, well, we were surprised.
No big amazement there – I’m sure if you’ve ever gone to look over the shoulder of a user as they work with your software after having it for a while, it’s pretty amazing how the software is used and applied to daily work.
So, the big surprise though is that we’re dropping some indexes and creating full-text indexes. This comes because users have evolved their expectations of how to find things on the system and they’re getting less structured in their approach. In addition, their expectations of the system’s ability to ferret out search clauses is vastly increased. In short, they’ve come to expect more from the search abilities.
Might be worth a look on your own applications – are there places you could add a full-text index and provide better search results fairly easily? Yes, I know there are some updates to code, but the reality is that the payoff could be substantial. It could be a very strong incremental gain in functionality and usability for your systems.
SelectViews Video Show
Community thoughts on SSD drives, moving jobs between servers, last update date tips. Also, indexed views, database hack recovery, foreign key pros and cons and more. Each show features the Accidental DBA Tip, the 60-second SQL Server Tip of the Day, Noise and News in the Industry and a lot more.
[Watch The Show Here]
Featured White Paper(s)
Ponemon Survey: Understanding Threats and Priorities in IT
In this extensive survey, conducted by the Ponemon Institute, C-level executives and DBAs reveal what challenges and opportun… (read more)
SQL Server Virtualization Management
Virtualization is becoming the popular practice in many environments, allowing organizations of all sizes to utilize resource… (read more)