Viewing 13 posts - 811 through 824 (of 824 total)
quote:
I also find it somewhat amusing that people still believe relational databases are inheriently better than hierarchal. There's no one solution...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
October 7, 2003 at 1:11 pm
quote:
It is very nice to see a viewpoint that is different from what all the pundits are touting. This is a very...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
October 7, 2003 at 8:12 am
quote:
quote:
I assure you a clustered index does reorganize them physically.
From BOL: In a...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
October 6, 2003 at 3:25 pm
quote:
You mentioned that this table has 26+ million records in it, and that is receives alot of activity. If you are getting...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
September 29, 2003 at 12:54 pm
First off, to amplify a bit on what Andy said, I would NEVER place a database file on NAS. If you are looking for SQL Server storage definately look...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 26, 2003 at 12:55 pm
I too have tended to use the included tools for most things. As I have evaluated many third party tools, with the exception of Log Explorer (which I use),...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 20, 2003 at 11:01 am
Jabba,
I should have added that what you were describing in your last post isn't "clustering" but "log shipping". It isn't hard to setup assuming you will be using SQL...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
December 31, 2002 at 1:31 pm
quote:
How difficult would it be to cluster two SQL Servers in an active/passive mode without a separate storage device? For example,...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
December 31, 2002 at 1:24 pm
quote:
I've never been a fan of clustering...you still have a single point of failure-the SAN/disk arrays. You can achieve a similar level...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
December 31, 2002 at 1:19 pm
Just be aware that MS recommends NOT using NAS for data files for performance reasons. SAN's might be prohibitively priced, but NAS has some pretty serious limitations.
I am a...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
December 30, 2002 at 4:28 pm
In addition to the things mentioned by the others. There are a number of technical points that differentiate the two.
Oracle has a more robust indexing architecture (bitmap...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 13, 2002 at 10:19 am
I am currently working as both an Oracle and SQL Server DBA. I started my path to an MCSE over 5 years ago. This was when I was...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 13, 2002 at 7:12 am
When asked what it is you do, friends and relatives always ask: So, you do data entry?
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 22, 2002 at 3:22 pm
Viewing 13 posts - 811 through 824 (of 824 total)