Viewing 15 posts - 241 through 255 (of 824 total)
This issue might be related to parallelism. You also didn't mention how fast those 4 CPUs are...
Look at the execution plan and see how much of the cost is due...
/*****************
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
*****************/
January 26, 2006 at 1:58 pm
Yes, and I have seen several cases where the lack of a clustered index lead the optimizer to choose poor execution plans using the wrong index etc...
Put a clustered 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
*****************/
January 26, 2006 at 1:53 pm
It is possible to do this, but I prefer to handle most transactions at the data layer. Handling this at the application layer leads to lots of round trips.
/*****************
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
*****************/
January 26, 2006 at 1:46 pm
That should work, there is nothing about a cluster that changes the nature of tempdb.
The only possibility I can think of is that you should verify that the volume to which...
/*****************
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
*****************/
January 26, 2006 at 1:39 pm
208 sets quoted identifier on
See this article for more information:
http://www.sql-server-performance.com/rd_traceflags.asp
/*****************
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
*****************/
January 24, 2006 at 10:36 am
There also might be some benefit to backup/restore operations if the database is large.
/*****************
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
*****************/
January 24, 2006 at 9:21 am
Windows?
/*****************
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
*****************/
January 24, 2006 at 7:31 am
I have seen very few situations where Savepoints are truly useful, but Books Online has a pretty good discussion on when they might be useful.
The answer to your second question...
/*****************
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
*****************/
January 23, 2006 at 9:37 pm
What OS is the workstation running? And is it true 64 bit hardware or is it 32 bit with 64 bit extensions?
/*****************
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
*****************/
January 23, 2006 at 8:03 pm
I'm getting into my "Way back machine" here, but I think support for cursors was introduced in 6.5.
/*****************
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
*****************/
January 22, 2006 at 9:21 pm
Access ins't a database, to be charitable, it's a database management system. That isn't just a quibble, but leaving that aside, Access doesn't really even qualify as a SQL DBMS,...
/*****************
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
*****************/
January 22, 2006 at 9:15 pm
- Restricting unauthorized access to data.
- Providing multiple interfaces to different classes of users.
- Representing complex relationships among data.
- Enforcing integrity constraints on the database.
-...
/*****************
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
*****************/
January 22, 2006 at 9:06 pm
All of your DDL scripts should include the owner name just to avoid this kind of ambiguity. The only role that automatically aliases to dbo is the system admins or...
/*****************
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
*****************/
January 20, 2006 at 2:59 pm
By saying "data persists" I meant that data tends to live much longer than applications. Furthermore data is more important than applications. That chart, and countless others drawn from an application...
/*****************
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
*****************/
January 20, 2006 at 2:52 pm
You seem to be advocating using the database merely as a "persistence mechanism" for the application. In reality it is applications that come and go, while data tends to persist...
/*****************
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
*****************/
January 20, 2006 at 11:55 am
Viewing 15 posts - 241 through 255 (of 824 total)