December 2006 - Posts

Full text as an oledb service has long been a pain. If you need to combine full text and a relational filter your performance could be really bad. 2005 improved this somewhat but not as much as I would have liked.

Well I submitted a suggestion and the repsonse is really positive.

"...in our next release where the query processing and optimizer will be fully aware of the relational side of the query and be able to push fo the FTIndex the rowid that satisfy the relational condition.
This is prio one for us right now."

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=208636

Whilst I might have previously have taken this with a pinch of salt, the new engineering practice that was very heavily discussed at PASS suggests that if something is being worked on now it should be in the product (as long as it is complete).

If you weren't at PASS the summary is that, no longer will 10 things be worked on only to realise they can only finish 5 fully , 2 will partially i.e, no UI (Service Broker), documents, high amount of bugs (Analysis Servicess), and the other 3 will have to be pulled i.e. Intellisense, date time datatypes, parallel flows in SSIS.

This will should mean that the product can ship at any time as the product will only contain finished items, not have baked ones. 



-
Posted by simonsabin | with no comments

Thanks to Paul the December CTP is now available.

The first notable change is that custom reports now use the .rdl extension and not the .rdlc extension. This means that you can easily develop reports in BI studio and use them in Management Studio.



-

We've been having a discussion at work around a few commonly used words. My reporting analyst's pet hate is ad-hoc being referred to as one work and written without the -. He does need to get out more.

We then got on to performant. I've been using it for ages and have been aware that Word doesn't like it and so obviously can't be a valid word. So I did a google and came up with many discussions on the topic, including

http://boulter.com/blog/2004/08/19/performant-is-not-a-word/

http://www.wordwebonline.com/en/PERFORMANT

Even Microsoft like the word



-
Posted by simonsabin | 2 comment(s)

I was recently trying to develop a test for DBAs. The scenario of the test was that you have taken over responsibility of a server what needs to be done to make it production ready. The server is really badly configured and the aim is for the tester to find them and make suggestions of what needs to be done.

One of the tests I wanted to setup was a database with a full transaction log. So I create a database, put a table in it and then insert lots of data, I have a 1Mb log file so expect it to blow quite quickly. Eventually it blows and I get an error saying the log is full. However I then run DBCC SQLPERF(LOGSPACE) only to find the log is 30% full.

I'm confused, because I then try and do more inserts and they work.

Well thanks to Hillary Cotter and Kalen Delaney for pointing out the error of my ways.

A database is in auto-truncate mode if one of the following is true:

  • The db is in SIMPLE recovery mode
  • The db has never been backed up
  • The log has been truncated since the last full db backup

Which makes sense. So even in full recovery if you haven't done a full backup then you can't use a transaction log backup so why keep the transaction log.



-
Posted by simonsabin | with no comments
Filed under:

One thing that always bugged me was that reminders set on emails didn't appear with the tasks I had set up.

Well in Outlook 2007 they have not got a To-Do list which incorporates all the tasks and emails with reminders in one view.

As I've previously mentioned I also really like the third side bar which includes the to-do list not just the task list. What I would like to do is for that to be a filtered list. Because I sync with my phone I don't want my personal tasks appearing in the list, I only want my work tasks.



-
Posted by simonsabin | with no comments
Filed under:

Jetbrains have announced that Omea is going open source. This is going to involve a steps before it will be available including releasing 2.2, moving to VS2005, changing the source control and moving the build to TeamCity.

More importantly they have now made the Pro version free.

You can download it here http://www.jetbrains.com/omea/download/download.html



-
Posted by simonsabin | with no comments
Filed under:

I've finally taken the plunge and installed Office 2007 and thought I would blog my first thoughts (I still have Office 2003 just in case)

As always with a new version there are some things that you think "thats neat". An example is the 3 column view in Outlook that provides task and calendar summary whilst in the mail section. I know something similar was in outlook today but that was useless as I never went to Outlook Today.

"Where the hell is the File menu?". As has been said many times before the Ribbon experience takes a little getting used to. But I do believe the hype that after a few days of floundering productivity should resume. I can see real benefit in the ribbon when designing/formatting documents in Word, Excel and Powerpoint. What previously would require a number of clicks through different menus and dialogs can now be donw very easily and generally with auto preview.

Thats all for now.



-
Posted by simonsabin | with no comments
Filed under:

I've just come across this when trying to install Office 2007. The Office 2007 readme says this is a known issue due to having Office Web Components (OWC) installed. I have scoured by system for installs of OWC and removed all of them and still I get the problem.

I did a google when I got back home and found a blog entry by Scott Hansleman http://www.hanselman.com/blog/Office2007WontUpgradeFromAPrereleaseVersionOfThe2007OfficeSystemOffice2007SetupSpelunking.aspx

He got round it by using MyUnInst from Nirsoft but the later mentioned Expression Beta.

Well I had Expression Beta installed and went for that and Office is now happily installing.



-
Posted by simonsabin | with no comments
Filed under:

The demo files associated with are now available.

Make sure you read the description first as it includes how to deploy the demo.

http://sqlblogcasts.com/files/folders/servicebrokerdemos/entry1472.aspx

 



-

My presentation from Developer Day 4 is now available here http://sqlblogcasts.com/files/folders/servicebrokerpresentations/default.aspx

Please remember to fill in the feedback on Developer Day 4 at http://www.developerday.co.uk/ddd/feedback.asp



-