Viewing 15 posts - 106 through 120 (of 824 total)
Oops, I didn't notice that you did specify SQL 2000... Still, look under the extended stored procs.
/*****************
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:37 pm
Look in Programability\Extended Stored Procedures\System Extended Stored Procedures.
/*****************
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:35 pm
The most straightforward answer to your question is that XML is so popular because of ignorance.
At the risk of self promotion, I wrote an article on the subject several years...
/*****************
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 20, 2007 at 10:34 am
"And I could represent the same data in a second hierarchy"
Thank you for making my point. In order to represent data stored in a hierarchical structure, in a different hierarchy,...
/*****************
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 19, 2007 at 4:49 pm
Now there you go...
Alarms should go off when you say something like "not all data is best represented relationally." Semi structured data is an oxymoron. Granted, it is an...
/*****************
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 19, 2007 at 2:37 pm
I can't imagine ever wanting to use the XML data type. The only time I'd ever store XML of any sort in the database is if there is some kind...
/*****************
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 19, 2007 at 9:43 am
I don't believe there is a way to change the setting for the default trace. However, you can turn it off and then define your own custom trace. This would...
/*****************
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 14, 2007 at 9:51 am
Nope, every installation of 2005 I've ever seen will return Disabled. In a way it kind of makes sense.
In SQL 2000 LicenseType was not always reliable and it never had...
/*****************
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 13, 2007 at 2:37 pm
Like I said in SQL 2000 that would give you some indication of your license type, but it was not always correct. However, in SQL 2005, that query will always...
/*****************
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 13, 2007 at 11:01 am
If there is a hack to change the default auditing file size or number, I haven't found it. However, you can certainly define your own trace. That's what I have...
/*****************
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 12, 2007 at 10:25 am
Unfortunately Microsoft has gone from ugly to hideous in this area with 2005. 2000 used to give you some information about licensing model, although it was not terribly reliable. 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
*****************/
February 12, 2007 at 10:16 am
Sorry for the delayed response, I haven't been getting my email notifications for a few days...
Anyway, that is a great link thanks.
I think you are correct in that the 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
*****************/
February 6, 2007 at 12:44 pm
Call me naive, but I thought this is what a Primary Key was for...
/*****************
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 6, 2007 at 7:50 am
Ummm... did you read the discussion threads? There has been quite a bit of discussion of the Read Committed Snapshot (RCS) isolation level that is new with 2005. This new...
/*****************
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 30, 2007 at 4:02 pm
This may not be EXACT, but you launch the installer located in either the
\SQL Server Itanium\
\SQL Server x64\
or \SQL Server x86\
\tools\setup.exe
depending on your hardware. From there it should...
/*****************
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 30, 2007 at 1:45 pm
Viewing 15 posts - 106 through 120 (of 824 total)