Friday, July 24, 2009

A Google-like Full Text Search - SQLServerCentral

 

You can tap into the self-education that comes from countless hours spent at home trying to locate information on the Web and turn it to your advantage in your own SQL Server-based search applications. With just a little bit of code you can help reduce your training costs and give your users an easy to use interface that will make them want to use your search applications. In this article I'll explain how to convert Google-style queries to SQL Server's full-text search CONTAINS predicate syntax

A Google-like Full Text Search - SQLServerCentral

Monday, July 20, 2009

Chris Webb's BI Blog's Blog - Windows Live

Some of the new features in Excel 2010 specific to Analysis Services

But anyway, now I’ve been given the go-ahead to blog I thought I’d list all of the new features I’ve found that are relevant to Analysis Services users. This does not include anything to do with Gemini, because Gemini isn’t part of the Technical Preview and I don’t have it yet unfortunately. I’m also not going to comment on bugs or things that don’t work in the way I’d want because, after all, this is not released software and things can and hopefully will change before RTM.

Chris Webb's BI Blog's Blog - Windows Live

Tuesday, July 07, 2009

Kevin Kline : Old Performance Tuning Recommendations Die Hard

  • Multiple data files for tempdb = yes, 1 of equal size per cpu (or cpu core)
  • Multiple log files = no
However, the recommendation fails when you get to the log portion of the equation. Why? It’s because data file IO is written using the proportional file algorithm where each data file has data written to it in round-robin style.  On the other hand, log files are written using the active file algorithm where LogFile1 is written first until full, then LogFile2 is written next until full, and so on… Long story made short (too late, I know) – you get no performance gain from having multiple files in the log because all writes occur on only one file. You can only get a performance gain from multiple files on the data portion of a database.

Kevin Kline : Old Performance Tuning Recommendations Die Hard

Monday, July 06, 2009

DbOctopus - powerful data editing for SQL Server

 

Your database knows how tables are relationally connected. DbOctopus takes advantage of that data wherever it can. Do you need to quickly see related rows from other table, without manual searching? Or to see descriptive names from FK table instead of numeric IDs? It's just a tip of iceberg of what DbOctopus can do to help you be more productive, while making everything easier.

DbOctopus - powerful data editing for SQL Server