Wednesday, December 31, 2008

Index Properties window does not show the Fill Factor set

›
This was another issue we came across. See the below images, They show the same index property of AdventureWorks database in 2005 instance. ...

Happy New Year!

›
Hi everybody, wish you all very happy, lovely, peaceful new year!
1 comment:
Tuesday, December 30, 2008

Unable to process the objects in Analysis Services but deploy

›
This ate few minutes from my allocated time :). I was able to successfully deploy the Analysis Services 2008 project to another server that ...
4 comments:
Monday, December 29, 2008

How sys.dm_db_index_physical_stats - LIMITED shows the leaf level fragmentation?

›
This question of raised by one of my students in my new batch, excellent question. We all know that when we use LIMITED mode, it scans only ...

Silly mistake I had made :)

›
I had written code filtering some records out and had assumed that it would produce the result I want. After few minutes I realized that how...
Sunday, December 28, 2008

Are practice exams worth to purchase?

›
I was thinking of doing 70-448 (MS SQL Server 2008 Business Intelligence Development and Maintenance) exam and thought to take a practice ex...
1 comment:
Sunday, December 14, 2008

Char column contains a lot of NULLs. Should change to varchar?

›
Most of the time, the decision of the usage of data types, char or varchar is depending on, whether the values are fixed-length or variable-...

New batch for course 2779B

›
Another batch for course 2779B that is for exam:70-431 was started on last Saturday at NetAssist. Fourteen students have been registered but...
Wednesday, December 3, 2008

Why Kilpfolio-Uninstall open so many browsers?

›
I had installed Klipfoloio for testing purposes, and then I decided to uninstall it today. Un-installation started smoothly, once the “done...
2 comments:
Monday, December 1, 2008

MSSQLSERVER 2005 update 3073 == 3282 ???

›
I was facing some issues with my SSIS packages and thought to install hotfixes that have been released after SP2. I had a cumulative hot fi...
Thursday, November 27, 2008

Third-party controls for Office PerformancePoint 2007

›
Are you using? I have been looking for some nice, elegant chart controls for Office PerformancePoint 2007 but still the search is not succes...
3 comments:

Next version of SQL Server - Kilimanjaro

›
Few months back, Microsoft had announced the next version of SQL Server ~ Kilimanjaro ~ that is due on 2010. Two major things related to the...

My Previous blog posts

›
If anyone look for my previous blog posts, please visit  http://dineshpriyankara.spaces.live.com . I still use live.com blog but not for tec...