Viewing 15 posts - 1 through 15 (of 81 total)
quote:
...Now, your (sic) telling me that you want to change the clustered index (primary key) from customer_id to last_order_dt to improve performance???
November 24, 2003 at 9:53 am
quote:
quote:
When I was listening to a good XML lecture by a really knowlegable XML...
October 22, 2003 at 12:55 pm
quote:
Since the big XML push of several years back, the first time I found a practical use for it was this year...
October 22, 2003 at 11:59 am
quote:
quote:
I agree with the article. I have to ask the possibly naive question: why...
October 14, 2003 at 10:22 am
I agree with the article. I have to ask the possibly naive question: why can't you do all that you can do with XML using a more efficient file format?
I...
October 13, 2003 at 6:25 pm
I guess I get to be one of the few to see a value in schemas. While there are probably far more scenarios where schemas can be a hinderance, scenarios...
May 21, 2003 at 3:19 pm
The fact that you're returning a NULL inside your aggregate function is why the warning (please note that it is a warning and not an error) is being generated. For...
February 14, 2003 at 4:03 pm
I think he means that at a binary level, your numeric field has a fixed set of bits assigned to it - an integer, for example, has 32 bits (4...
December 6, 2002 at 1:58 pm
You need to call sp_MS_MarkSystemObject @objectname on your stored procedure. Provide the name of your procedure as the value for @objectname.
December 6, 2002 at 1:38 pm
UPDATE MY_TAB1
SET acronym = (SELECT acronym
...
November 15, 2002 at 11:13 am
Yes, so far I believe that the second number is the database id, the third number is the object id, and the fourth number is an index id.
I found one...
November 12, 2002 at 11:00 pm
Some further investigation into DBCC AUTOPILOT seems to suggest to me that it is used to "configure" the environment for SET AUTOPILOT. I believe, but this is just inference, that...
November 12, 2002 at 2:27 pm
Interesting that you received an error. I tried using it and got back very interesting results. It basically showed me a breakdown of each command my query was executing, what...
November 12, 2002 at 1:50 pm
As far as your first question, if your procedures are using Linked Servers to accomplish the cross-server query, you may need to adjust your Linked Server to accomodate for the...
November 7, 2002 at 11:43 am
You're going to get different responses to this question because there isn't necessarily a "one size fits all" answer; the answer depends upon what you want SQL Server to be...
November 7, 2002 at 11:31 am
Viewing 15 posts - 1 through 15 (of 81 total)