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.
-
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
-
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.
-
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.
-
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
-
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.
-
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.
-
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
-