Viewing 15 posts - 631 through 645 (of 824 total)
Defaults are more efficient, but they don't provide a true audit trail as they are easily overriden by supplying values. Triggers are harder to disable/override and so provide a more...
/*****************
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 23, 2005 at 3:05 pm
Good, glad I could help; but that doesn't explain why it was behaving differently on other servers.
/*****************
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 23, 2005 at 2:14 pm
How far off is it? Do you have any specific examples?
/*****************
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 23, 2005 at 11:41 am
Look at the execution plan to make sure that the query is using the index.
/*****************
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 23, 2005 at 10:05 am
Is the volume compressed?
/*****************
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 23, 2005 at 10:03 am
As long as you are in the sysadmin role, any objects you create will automatically be dbo unless you specify an owner. You should always specify an owner, but very...
/*****************
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 23, 2005 at 9:58 am
I had a similar problem a while ago and posted my findings.
HTH
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=19707
/*****************
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 23, 2005 at 9:50 am
When you save the DTS package you can specify an owner password. If you do this, even sysadmins won't be able to modify the package without it, but anyone who...
/*****************
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 23, 2005 at 9:10 am
I'm not sure exactly what Noel was referring to but I assume it's something like creating a new table with the proper column lengths, import the data from the original...
/*****************
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 18, 2005 at 2:10 pm
alter table <TableName>
alter column <ColName> varchar(100)
/*****************
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 18, 2005 at 1:28 pm
Proc cache is limited to 2GB (on 32 bit machines). The reason your cache hit ratio seems low is probably because you are looking at the "total" which is most...
/*****************
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 11, 2005 at 11:38 am
In my earlier post I pointed out that this data is NOT in a "hidden table" that is not accessible to the user. This information is in fact in sysproperties...
/*****************
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 11, 2005 at 9:03 am
First off, thank you for the article. It isn't very often that I get to read an article that really teaches me something new and explains something that has left...
/*****************
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 10, 2005 at 9:28 am
I have worked with document management and image management software for a few years and all of the systems that I have seen suffer from the issues raised by EdVassie. Some...
/*****************
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 4, 2005 at 3:16 pm
I've had this problem with a number of third-party applications over the years. Generally it's because they expect their product to be the only database on your server and they...
/*****************
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 4, 2005 at 2:59 pm
Viewing 15 posts - 631 through 645 (of 824 total)