Viewing 15 posts - 1,036 through 1,050 (of 1,413 total)
Thanks, maybe I'll get back to that part in another article then.
--
Chris Hedgate @ Extralives (http://www.extralives.com/)
Contributor to Best of SQL Server Central 2002 (http://www.sqlservercentral.com/bestof/)
Articles: http://www.sqlservercentral.com/columnists/chedgate/
December 20, 2003 at 1:07 am
I see that I have a slight error in the article text. The following part is not correct:
quote:
This means that data is...
December 19, 2003 at 4:55 am
Then, as I said, I would never go with the design proposed by your client. Tell him that if he wants it you will have to create extremely difficult integrity...
December 19, 2003 at 2:43 am
Hm, actually I saw now that the Edit user profile form did not have black background but a nice white one (though the extra login form to get there is...
December 18, 2003 at 12:29 pm
Do you need to maintain the relationships between the levels of aggregation? I mean, will the total sales of city1, city2 ... cityN in state1 add up to what is...
December 18, 2003 at 12:21 pm
Forgot to answer the initial question: sxg6023, I also agree with Steve and kknudson. What Steve mentions, forward-pointers, can really become a performance issue. There are other reasons as well...
December 18, 2003 at 12:15 pm
SmithDM: For Details table the index is probably a good choice. For the master table however I don't think it gives you any good advantage, you would probably be better...
December 18, 2003 at 12:11 pm
quote:
The following script gives me a list of tables without any clustered index. I cannot think
of any other way than to use...
December 17, 2003 at 8:38 am
You can use an INSTEAD OF trigger.
--
Chris Hedgate @ Extralives (http://www.extralives.com/)
Co-author of Best of SQL Server Central 2002 (http://www.sqlservercentral.com/bestof/)
Articles: http://www.sqlservercentral.com/columnists/chedgate/
December 16, 2003 at 7:12 am
quote:
quote:
SQL Server is based on the relational model ....but not a very good implementation...
December 16, 2003 at 5:48 am
quote:
Can someone tell me or direct me to a good article on why one should not use cursors in stored procedures?
December 16, 2003 at 3:31 am
I assume you are referring to the standard suggestion of detaching a database and then re-attaching it without the logfile(s), which will create a new clean log file and if...
December 15, 2003 at 3:07 am
The trappable error generated by ADO is more of a general error. The specific SQL error message (and number) is contained in the Connection.Errors collection.
--
Chris Hedgate @ Extralives (http://www.extralives.com/)
Co-author of...
December 15, 2003 at 2:57 am
And I would also suggest specifying which columns you are inserting, like this:
INSERT INTO tableA (a, b)
SELECT a, b FROM tableB
It is always a good thing to be explicit when...
December 5, 2003 at 2:35 am
Have you tried using SET NOCOUNT ON? Something like this might help:
CREATE PROC foo
AS
BEGIN
SET NOCOUNT ON
-- Do linked server SQL
SET NOCOUNT OFF
-- Do XML building SQL
END
--
Chris...
December 5, 2003 at 2:28 am
Viewing 15 posts - 1,036 through 1,050 (of 1,413 total)