Viewing 15 posts - 1,981 through 1,995 (of 3,728 total)
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
Paul White NZ (11/22/2010)
Since this is in the SQL Server 2008 forum, you could also use bulk-logged INSERT...SELECT then ALTER TABLE...SWITCH.
I thought SWITCH only worked in Enterprise Edition?
If you have...
November 23, 2010 at 2:11 am
In the rare cases when I've felt the need for RBAR I've found that in some cases cursors are faster than WHILE loops but only when I don't have to...
November 19, 2010 at 3:44 pm
Viewing 15 posts - 1,981 through 1,995 (of 3,728 total)