Viewing 15 posts - 31 through 45 (of 92 total)
hennie7863 (4/14/2010)
April 14, 2010 at 7:49 am
Has anyone here tried SQL Server on something like the ram drives from Texas Memory Systems? They aren't persistent when the machine is off like SSD's but they're...
April 8, 2010 at 9:50 am
We don't need no stinkin' changing dimension widgets... Took me a while with the article-submitting editor, but I got my treatise on using MD5 submitted. We'll see how...
February 25, 2010 at 11:02 pm
No, I've never had a problem with using md5. I'm inspired to write my own article on how to use md5 in an update/insert strategy for loading data warehouses...
February 25, 2010 at 12:16 pm
The final refinement of the SK lookup table method comes when you add an MD5 checksum column and leave them permanently populated. Use these tables to quickly determine update/insert...
February 24, 2010 at 12:51 pm
Microsoft already puts out "storage server" and "web server" editions so I think Steve's idea of "Sql Server server" is quite realistic in that light. It's a matter of...
August 26, 2009 at 8:54 pm
I gave this article a good score - I don't know why it is getting bashed in the ratings (only an average of 2 when I voted). The English...
May 19, 2009 at 7:05 am
dave.farmer (5/18/2009)there's a fair bit of learining and trial and error involved before I get it right.
In lousy economic times its even more critical than ever for IT people to...
May 18, 2009 at 9:50 am
This kind of thing is really easy to whip up with ssis so the question you seem to be asking is what method you are most comfortable with for this...
May 11, 2009 at 5:49 pm
I never deal with anything mission critical so I'll take your word for it; my own experience is 100% data warehouses where even if there is a lot of data,...
April 19, 2009 at 12:40 am
Look. the straight copy all from the script doesn't have any kind of sorting or anything to make a lot of overhead - do you really have production servers that...
April 18, 2009 at 4:31 am
People make external drives FAT32 for a variety of legitimate reasons - switching it to NTFS as the only solution isn't much help and is a pretty well known and...
April 17, 2009 at 7:35 am
henrik staun poulsen (1/8/2009)
How do you tell the difference between mediocre and great Admin?We have two people working with the SANs, but are they any good???
The mediocre SAN admin...
January 8, 2009 at 6:51 pm
I think you might get much better performance if you make that concatenated PK a non-clustered index and change the clustered to just those 2 columns in your query's WHERE...
December 22, 2008 at 6:11 am
A truly horrific problem to deal with; you have my sympathies. Good job finding a working fix under what must be a lot of stress. You do know...
December 9, 2008 at 1:46 am
Viewing 15 posts - 31 through 45 (of 92 total)