Viewing 15 posts - 196 through 210 (of 824 total)
Now I'd love to see that! Especially since the highest TPC benchmark ever achieved by SQL Server is 1.2 Million per minute and that was using a 64 CPU Itanium...
/*****************
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 2, 2006 at 11:35 am
I have built systems in SQL Server that processed more than 2.5 million transactions per hour with DRI. That was on 32 bit hardware and SQL 2000, and the system...
/*****************
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 2, 2006 at 10:47 am
You've basically got it. I had to remove every last trace of the CTP before I could get the install to work properly.
/*****************
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 2, 2006 at 9:50 am
My thoughts exactly. It isn't a fair comparison.
I have a major problem with even the premise of the question though. If you are just concerned with throughput, then don't...
/*****************
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 2, 2006 at 9:44 am
Yes, and No... Microsoft Clustering provides ZERO load balancing capabilities for SQL Server, however, you could create an "active/active" cluster with some sort of partitioning or replication between them and...
/*****************
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 2, 2006 at 9:13 am
The things that you are used to doing in earlier versions are generally not a big problem in 2005, since MS did a pretty good job of keeping it backward compatible. ...
/*****************
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
*****************/
February 24, 2006 at 9:56 am
No, MS finally gave us a usable set of system views in 2005 and removed the ability to directly query or change the system tables. As I understand it, 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
*****************/
February 24, 2006 at 9:45 am
You need to do some serious reading... There are tons of posts here and Books Online has complete information on that subject.
However, the short answer is that if you don't...
/*****************
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
*****************/
February 23, 2006 at 4:57 pm
You can restore a database from a full backup (what you are creating) but if you aren't backing up the transaction log you will not be able to restore 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
*****************/
February 23, 2006 at 4:55 pm
See the article entitled "How to: Save an Execution Plan in XML Format" in BOL
/*****************
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
*****************/
February 23, 2006 at 4:51 pm
About the only way to control row level rights is through views. If you create a view that returns only rows that meet certain criteria, then grant a user permission...
/*****************
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
*****************/
February 23, 2006 at 4:48 pm
You can't manually update statistics on the system tables. Frankly I can't think of a reason you'd 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
*****************/
February 23, 2006 at 4:41 pm
Based on our testing, we are moving all new project development to 2005. Our current products will migrate individially as new releases come out.
We are well into development 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
*****************/
February 23, 2006 at 4:38 pm
Databases can be transfered back and forth between 64bit and 32bit servers the same way that they are between two 32bit 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
*****************/
February 23, 2006 at 4:33 pm
While virtualization is fine for development and testing environments (as long as you aren't trying to run benchmarks) I would never run a producton SQL Server on a virtual machine. ...
/*****************
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
*****************/
February 21, 2006 at 9:43 am
Viewing 15 posts - 196 through 210 (of 824 total)