Viewing 15 posts - 91 through 105 (of 824 total)
Matthew Ross (2/12/2007)
Lee,
... as far as using a DB for this, who cares? A DB is a data repository key word being data just as the file system (e.g....
/*****************
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, 2007 at 2:50 pm
I'm late to the discussion, but here's my cynical two cents anyway...
It will never happen, because if ANYONE ever actually delivered a relational language and platform, why would we...
/*****************
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 25, 2007 at 11:14 am
Jeff, I can't and won't try to say that you are wrong on any particular point because I do agree with you that performance is critical.
The one thing that...
/*****************
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
*****************/
August 1, 2007 at 8:12 am
That's a really excellent question, I might steal it! It sets up a situation that lets you distinguish those who have practical experience from those who don't. My answer 5-6...
/*****************
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
*****************/
July 31, 2007 at 9:13 am
Jeff, your point about cursors is taken, but there are situations where they are, in reality, the best solution to the problem at hand. Like almost everything else in 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
*****************/
July 31, 2007 at 8:39 am
My position has both hardened and softened somewhat over the past few years.
I still think that XML is “a stupid answer to all the wrong questions”, and that 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
*****************/
July 10, 2007 at 8:26 am
It has to do with the narrower scope of variables vs. temp tables. Temp tables are available for all batches in a connection, variables are scoped to the batch. Therefore...
/*****************
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 4, 2007 at 10:17 am
"All else being equal" is the key phrase here, and while numbers may not lie, those who put them together certainly do. Sowell's argument is not that women aren't compensated...
/*****************
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
*****************/
April 9, 2007 at 5:59 pm
The whole "women get paid less for doing the same work" is such a tired old lie that I just can't let this pass.
No credible study has ever been able...
/*****************
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
*****************/
April 6, 2007 at 11:39 am
It makes perfect sense to have a single set of data available across the enterprise and things like Color, or EmployeeStatus etc... are very likely candidates for this, but in...
/*****************
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, 2007 at 9:42 am
I have yet to hear a truly useful definition for Domain\Lookup\DataDictionary\etc... tables. Why is it deemed necessary to treat them differently than any other tables? And by extension, why is...
/*****************
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, 2007 at 8:39 am
Jeff is correct, but doing this carries the same risks as using nolock.
If you are using SQL 2005 then Read Committed Snapshot isolation level might be an appropriate choice.
/*****************
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 9, 2007 at 9:43 pm
I believe it applies only to RPC and will return the objectId of the stored procedure that was called.
/*****************
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
*****************/
February 23, 2007 at 8:32 am
2,147,483,647 bytes, basically 2 Gigabytes
/*****************
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
*****************/
February 22, 2007 at 3:29 pm
Object_id is not applicable to SQL:stmtStarting or ending. You can accomplish this by putting a filter on the TextData column. So something like "SELECT%FROM%TableName%" would probably do the trick. Minus...
/*****************
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
*****************/
February 21, 2007 at 4:56 pm
Viewing 15 posts - 91 through 105 (of 824 total)