Viewing 15 posts - 1,921 through 1,935 (of 3,670 total)
I had a look at Pragmatic works BI documenter. It's pretty good.
I think Microsoft's next big step in the BI world should be a centrally managed meta data repository...
May 2, 2011 at 3:38 pm
Thomas Keller (4/11/2011)
Rather than changing the server default collation just to avoid the issue on the next database creation, how about changing the collation in the model database?
Nice thought, but...
April 13, 2011 at 2:57 am
The intent of Version 0 is to show what can be achieved. A taster with a promise of jam tomorrow. My worry is that executive thinking is "if...
April 11, 2011 at 3:27 pm
There are a couple of ways of fixing it. The one that springs to mind is as mentioned in Todd's blog. Change the mapping file in nHibernate...
April 11, 2011 at 3:19 pm
In addition to the "right tool in the right hands" comment I should like to add that you should make sure that you are using the right tool for the...
April 11, 2011 at 1:20 pm
If your field is an NVARCHAR and you use VARCHAR parameters you will get a seek because SQL is happier to turn a VARCHAR into an NVARCHAR than the other...
April 11, 2011 at 9:36 am
Nice to know I'm not the only one who bothers with this stuff.
The key points I was hoping to address were
Make it...
February 17, 2011 at 3:59 pm
I don't think it is worth compressing small lookup tables. In fact I noticed that a database containing nothing but small (<100 record) lookup tables actually grew.
Does the concept...
January 13, 2011 at 2:53 am
Wish I had a few more databases of sub-billion row tables:-P
The thing that has made MPP so attractive in the BI world is the explosion in data volumes. Not...
January 4, 2011 at 12:00 pm
Raw space is cheap but IO and concurrency isn't.
One point to watch out for is how well the records fit on a page of data. The first example I...
December 31, 2010 at 1:51 pm
I think the whole "can be done cheaper in a low cost country" is a case of perception vs reality. The problem comes when it is the perception of...
December 29, 2010 at 4:27 pm
Solomon Rutzky (12/29/2010)
December 29, 2010 at 3:22 pm
If I work from home I eliminate a 2 hour round trip commute. This means I can either start earlier or have a lie in. When I finish...
December 29, 2010 at 4:50 am
On the subject of the expensive sort in the execution plan I had a note back from Bob Beauchamp saying that there is an internal stream aggregator operation that causes...
December 29, 2010 at 4:37 am
One point I forgot to mention was a data warehouse appliance is a self contained unit so you won't be cannibalizing your existing storage and IO. There is obviously...
December 21, 2010 at 10:44 am
Viewing 15 posts - 1,921 through 1,935 (of 3,670 total)