Viewing 15 posts - 1 through 15 (of 824 total)
If I understand your solution, yes I would expect to see performance problems. Far worse, you're going to have data integrity issues. Even if you contrive to load and manage...
/*****************
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 23, 2020 at 9:34 pm
Steve Jones - SSC Editor (1/27/2014)
/*****************
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
*****************/
January 27, 2014 at 1:55 pm
Saying "it's not the platform" is not at all the same thing as saying that a given application can be ported to a different platform without issues. Anyone who...
/*****************
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
*****************/
January 27, 2014 at 1:51 pm
Very true Steve. Part of SQL Server's problem is also its strength. By making SQL Server "easy" MS has ensured that there will be many "accidental DBA's" working...
/*****************
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 26, 2013 at 9:30 am
This is one of those knowledge from hard experience things...nice of you to share.
/*****************
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
*****************/
November 3, 2011 at 8:56 am
Frankie-464050 (6/16/2011)
/*****************
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 16, 2011 at 1:08 pm
I completely agree that VM should be seriously considered for development and QA environments.
In production environments one of the constant challenges I've faced is server sprawl. The...
/*****************
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 16, 2011 at 8:53 am
codebyo (5/31/2011)
Mad Myche (5/31/2011)
/*****************
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
*****************/
May 31, 2011 at 2:33 pm
Two points:
First off the author, and a number of posts have suggested that "other SQL DBMS systems" are optimized for cursors and that it's only SQL Server that is not....
/*****************
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
*****************/
May 27, 2011 at 12:20 pm
Thanks, and your're welcome. I'm glad to know that the article was useful.
/*****************
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 5, 2010 at 12:30 pm
Are the two tables in the same filegroup? Apart from the possibility that the two are on different disks (or arrays) and one is much slower or busier than...
/*****************
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 16, 2010 at 6:58 am
Thanks, I've been pretty busy at work and home (but aren't we all?) The truth be told, I guess I just blew it off so long that I got...
/*****************
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 29, 2010 at 10:52 am
I might agree with Marvin's sentiment IF there were an accepted nomenclature for the concept addressed in the article. Yes, at a high level, it's just normalization. But...
/*****************
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 4, 2010 at 10:48 am
True enough, I know quite a bit about database design, and next to nothing about you, but what I do know about you is more than enough.
There is no need...
/*****************
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 3, 2010 at 12:14 pm
Andrei Marculescu (3/3/2010)
/*****************
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 3, 2010 at 12:03 pm
Viewing 15 posts - 1 through 15 (of 824 total)