Interesting Snippets from 2014-05-08

• sql - What are the Options for Storing Hierarchical Data in a Relational Database? - Stack Overflow

  Generally speaking you're making a decision between fast read times (e.g. nested set) or fast write times (adjacency list). Usually you end up with a combination of the options below that best fit your needs. The following provides some in depth reading

• 4 Lightweight Ways to Tell if a Database is Used | Brent Ozar UnlimitedBrent Ozar Unlimited

  You could run some sort of trace, but you’d probably drag down performance on your SQL Server. What you need is a quicker way to find out if the database is in use.

• Searching for Strings in SQL Server Databases

  Sometimes, you just want to do a search in a SQL Server database as if you were using a search engine like Google. Besides the obvious Full-Text search, there are plenty of techniques for finding that pesky data that resists the normal SELECT blandishments. Phil Factor describes some alternative techniques.

[/snippets] permanent link