Viewing 15 posts - 571 through 585 (of 824 total)
DTS doesn't always do a good job of figuring out which objects need to be moved in what order based on dependencies. If this is going to be a repeating...
/*****************
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
*****************/
April 11, 2005 at 9:44 am
To further explain...the backup file contains a list of all the files that comprise the database along with their paths. If you just use RESTORE DATABASE SQL Server assumes that...
/*****************
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
*****************/
April 11, 2005 at 9:37 am
use RESTORE FILELISTONLY to get the logical file names in the backup file. Then use
RESTORE DATABASE dbname
FROM DISK = 'backupFileName'
WITH MOVE 'FirstlogicalFileName' TO 'NewLocationAndName',
MOVE ''SecondlogicalFileName' TO 'NewLocationAndName',
etc...
/*****************
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
*****************/
April 11, 2005 at 9:33 am
Yes, DDL can be placed in a transaction, and yes, it is prudent to do so. Just make sure that you are doing adequate error checking or else your transaction...
/*****************
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
*****************/
April 11, 2005 at 8:37 am
linked servers can be a real Godsend. You should exercise great care in setting up the security between them. I have seen several cases where the linked server login mapping leaves...
/*****************
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
*****************/
April 8, 2005 at 3:31 pm
Not a stupid suggestion at all. I try to do test restores on a regular basis, both to maintain my skills and to ensure the validity of our process and media.
/*****************
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
*****************/
April 8, 2005 at 3:25 pm
There are several variables that have to be taken into consideration here. Are you retiring the old server (meaning specifically the SQL Server instance(s) on it) completely or will it remain in...
/*****************
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
*****************/
April 8, 2005 at 3:20 pm
Thanks, that makes my point that whether or not the Person table is in 1NF depends on the business rules.
/*****************
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
*****************/
April 8, 2005 at 11:02 am
When you use a phrase like "it's more hypothesis and theory than law..." it sounds to me like you are equating the two; placing hypothesis and theory on one side...
/*****************
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
*****************/
April 8, 2005 at 11:01 am
Since sp_change_users_login does not work on Windows Logins the service account and it's privs should not make any difference.
/*****************
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
*****************/
April 8, 2005 at 10:54 am
I think Date, Darwen, and Pascal would only make the argument that your Person table is normalized if there were a rule that stated that a person must have 4...
/*****************
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
*****************/
April 8, 2005 at 10:49 am
OK, I tried, but I couldn't resist...
I totally agree with point A, but I think on B you missed the boat.
The science behind the Relational Model IS NOT evolving. ...
/*****************
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
*****************/
April 8, 2005 at 10:44 am
I largely agree with Jeremy's thoughts (and of course totally agree with his final conclusion) but would add a couple of things.
The Relational Model of Data IS based on science,...
/*****************
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
*****************/
April 8, 2005 at 10:22 am
We use ER Studio, and I have used ERWin in the past. First, ER Studio is not Java based. Second, as you stated, neither one is capable of being 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
*****************/
April 7, 2005 at 8:21 pm
DELETE
TableName
WHERE
ColumnName <= dateadd(d, /***************** 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 *****************/
April 7, 2005 at 8:11 pm
Viewing 15 posts - 571 through 585 (of 824 total)