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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy