Viewing 15 posts - 526 through 540 (of 824 total)
That's kind of a tough one... sp_who2 which just pulls the info from sysprocess reports on cpu usage, but it is cumulative, so it can't really tell you which process...
/*****************
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 27, 2005 at 2:19 pm
I don't use the ITW much, but I have used it in the manner you describe. I don't recall any problems at all.
/*****************
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 27, 2005 at 12:35 pm
you can also issue this command SET STATISTICS TIME ON and then do your queries...
/*****************
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 27, 2005 at 12:11 pm
Rudy, that may not be true, particularly if the different logs can't be separated onto different disks/arrays. If the transaction percentages are correct it might be better to have a...
/*****************
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 27, 2005 at 12:10 pm
Although SQL Server can split work in a single transaction over multiple processors, it is often more efficient NOT to. There is quite a bit of overhead incurred in coordinating...
/*****************
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 27, 2005 at 12:04 pm
Unfortunately, SQL Server has no built-in capability to help you here. There are several third party tools that can do this (or approximate this functionality) InDepth for SQL Server by...
/*****************
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 27, 2005 at 11:58 am
Another persistent myth of the database world. Make no mistake about it, it IS a myth that character data types necessarily offer inferrior performance to numeric data. Your search arguments...
/*****************
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 27, 2005 at 11:46 am
**disclaimer** I am not a MS employee and am certainly not authorized to provide definitive licensing answers***
I believe that if each of your developers have an MSDN license you are...
/*****************
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 26, 2005 at 7:48 pm
If you are doing the restores at the same time so that they will be synched up in case of a restore you may need to rethink things a bit. ...
/*****************
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 26, 2005 at 7:42 pm
IDENTITY columns are nothing more than a specific implementation of what are generally known as surrogate keys. There are several ways to generate surrogate keys, but for SQL Server the...
/*****************
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 26, 2005 at 7:29 pm
It sounds like you have servers that will give you a lot of room to grow... I doubt that the reboots either help or hurt performance. There will be a...
/*****************
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 26, 2005 at 7:00 pm
Of course the publishing world is where XML got its start. As you said David, it is a method to separate format from content.
I won't claim to be an expert...
/*****************
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 26, 2005 at 9:01 am
Wow! MS and IBM MUST know what they are doing! Thanks for opening my eyes man! I never would have thought of such a brilliant line of reasoning by myself! ...
/*****************
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 24, 2005 at 6:33 pm
I would laugh if it weren't so tragic... A "standard (XML) schema"?? Is that a bad attempt at a joke? That's what EDI tried to be, and XML will never...
/*****************
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 23, 2005 at 4:47 pm
The poster is obviously ignorant of data management fundamentals and sound system design (and hasn't carefully read the article or the other posts). Just how is XML necessary, sufficient, or even...
/*****************
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 22, 2005 at 6:14 pm
Viewing 15 posts - 526 through 540 (of 824 total)