Viewing 15 posts - 346 through 360 (of 824 total)
OK, I'll bite... PFM???
/*****************
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
*****************/
September 15, 2005 at 12:52 pm
The answer is that AS can definately impact the performance of a SQL instance, the inverse is, of course, also true.
Many people recommend running them on seperate servers, but it...
/*****************
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
*****************/
September 15, 2005 at 12:47 pm
I don't know of any links right off hand, but I would certainly NOT expect there to be "massive" improvements. Most of the improvements that you might expect from having...
/*****************
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
*****************/
September 15, 2005 at 12:33 pm
As long as there is an appropriate trust relatioship between the two domains you should be able to add the remote domain\user, or the appropriate group, to the logins.
/*****************
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
*****************/
September 14, 2005 at 2:30 pm
All the archive utility does is to copy the data files into a .cab file. We have the same issue and instead of using the archive utiltity we just schedule...
/*****************
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
*****************/
September 14, 2005 at 12:36 pm
I do agree with lowell's first suggestion however...
/*****************
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
*****************/
September 14, 2005 at 12:14 pm
I have to disagree with the name/value approach to inventory attributes. This at first looks very flexible (and it is) but there are several critical flaws. The first and foremost...
/*****************
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
*****************/
September 14, 2005 at 12:11 pm
My first response is why in the world are you using guids on "all tables" for a primary key?
Assuming you have your reasons... The ROWGUIDCOL property doesn't really add much,...
/*****************
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
*****************/
September 14, 2005 at 11:54 am
An even better solution to this is Lumigent's Log Explorer. I understand that LogPI does the same thing but I have used Log Explorer to recover from this kind of...
/*****************
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
*****************/
September 14, 2005 at 9:38 am
db_owner won't work if the database doesn't already exist on that instance of SQL Server. In that case the user must be in the dbcreator fixed server role.
/*****************
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
*****************/
September 14, 2005 at 7:08 am
I don't understand the need to BCP the tables out to files and then script all the databases and jobs.
Doing a database backup includes the data as well as structures...
/*****************
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
*****************/
September 13, 2005 at 2:02 pm
The only place we used VMWare was in our development and test areas. It worked fine there.
For production it didn't make sense because our SQL boxes were already a "shared"...
/*****************
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
*****************/
September 13, 2005 at 1:47 pm
I don't get it. You have a start and an end date and you need to plot the hours between them? But you haven't given any that you need to...
/*****************
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
*****************/
September 13, 2005 at 1:42 pm
BTW, I can certainly understand needing to shrink a production database once in a while, but I don't generally include that as part of normal maintenance. If you are 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
*****************/
September 13, 2005 at 1:36 pm
This depends largley on your I/O system and how it's configured, but even a horribly slow disk system should be able to accomplish this in just a few minutes.
/*****************
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
*****************/
September 13, 2005 at 1:32 pm
Viewing 15 posts - 346 through 360 (of 824 total)