The Bit Bucket

Recently, I was working at a client’s site where SQL Server 2000 was still in use. They wanted to upgrade to SQL Server 2005. The only reason they were looking at the Enterprise Edition was for data-driven subscriptions in Reporting Services. The CEO certainly wasn’t interested in paying the sort of dollars required for that, just to be able to automatically email out a set of monthly reports to about 30 or so folk within the company.

2008-08-13

While I was prepping my full-text search session for TechEd Australia today, I decided to modify the thesaurus. I found the discussion in books online a bit confusing regarding the locations of the files involved.

What threw me was it said the default location of the thesaurus files was:

SQL_Server_install_path\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\FTDATA\

I went there and couldn’t find anything. I worked out that for ENU language, my file should be called tsENU.xml. I searched for that and found it in:

2008-08-13

The title pretty much says it all but for more information, check out Steve Lasker’s post.

2008-08-07

Well it was great news this morning that SQL Server 2008 RTM has hit the download sites. Also keep an eye out for Visual Studio 2008 SP1 which has been listed as coming August 11th.

2008-08-07

I’ve been doing another performance tuning job today and it highlighted to me once again that problem that a lack of indexes on foreign key columns can bring.

By adding indexes on the foreign keys on three tables, we saw a reduction of 87% in total I/O load on the server. There are other aspects of the system that I’m now working on but it really struck me that having SQL Server do this by default would avoid a lot of apparent performance problems. It would have to be one of the most common indexing issues that I see in my work.

2008-07-28

In the latest podcasts at www.sqldownunder.com , we’re giving away a Visual Studio MSDN Premium Online license for a year, courtesy of our friends at Microsoft. It’s a simple:

* you need to visit Quest’s site for info on Litespeed via the simple link http://shrinkster.com/10fn,

* read the article covering 10 things DBAs often don’t know about Litespeed

* email a description of two of them to questATsqldownunder.com (replacing AT with @) before August 17th 2008

2008-07-28

I’ve also been looking around for a new phone. It became much more urgent last week after I dropped my iMate.

After trying lots of phones, I ended up opting for an iPhone 3G. And after using it for a few days, couldn’t be happier with it. Well, not quite true, if it worked as a NextG modem as well, it would be even better as the data plans are quite costly here in Australia.

2008-07-22

I saw an interesting videopod from Steve Jones the other day where he noted that upcoming processors would have many more cores than now and hoping that DBAs won’t have to learn to write multiprocessor-style code. What was also interesting was the way he described that he learned some of this style of coding but later when he came back to it, he realised how much he thought he knew but didn’t.

2008-07-21

Hi Folks,

SQL Down Under show 38 with guest SQL Server MVP Andy Leonard discussing database testing is now available for download from www.sqldownunder.com .

The show also includes a competition.

Enjoy !

Regards,

Greg

2008-07-19

I caught up with James Luetkehoelter at the PASS Summit in Germany a few months back. He sent me a copy of his new book from APress: Pro SQL Server Disaster Recovery.

I managed to finish reading it while heading back from CodeCampSA in Adelaide today (which was a good solid event again - excellent work Peter Griffiths!). I quite enjoyed the book and I like James’ writing style. It’s quite conversational and I could hear him talking to me as I read it.

2008-07-13