Viewing 15 posts - 1,966 through 1,980 (of 3,711 total)
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
November 19, 2010 at 7:02 am
I wrote up my thoughts on MPP appliances earlier this year http://www.sqlservercentral.com/articles/MPP/70845/.
They are not a marketing hype thing. Green plum has been bought by EMC, Neteeza has been bought...
November 19, 2010 at 4:57 am
Viewing 15 posts - 1,966 through 1,980 (of 3,711 total)