Viewing 15 posts - 256 through 270 (of 824 total)
Just to clarify, the business rules that define what the data is should be in the database. The business rules that define how the data is used for a specific purpose...
/*****************
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 19, 2006 at 8:24 pm
When you get right down to it, SANs are not much different than any other I/O system. Performance is a relatively simple matter of the speed of the disks 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
*****************/
January 19, 2006 at 4:29 pm
There is no one answer to this question. Any properly designed database incorporates a great deal of business rules in it. However, there will always be some business logic 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
*****************/
January 19, 2006 at 9:02 am
I used dbcc freeproccache and dropcleanbuffers between tests. However, subsequent testing shows that they are actually much closer in speed than that initial test. The while loop is still about...
/*****************
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 17, 2006 at 4:14 pm
I guess proof is what you need...
create
table curstest (col1 int...
/*****************
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 17, 2006 at 2:00 pm
That's what I would do if you can afford the down time.
/*****************
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 17, 2006 at 11:49 am
We use Embarcadero Change Manager with good success. I was pretty impressed with dbghost too.
/*****************
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 17, 2006 at 11:45 am
The tables have to be dropped in the right order. Without rewriting your script for you, I did notice that you have to drop the Dependents table before you can...
/*****************
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 17, 2006 at 11:41 am
I have seen this approach many times and I must say that I hate it. Avoiding cursors is a good thing, but this approach should be called "roll your own cursor." 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
*****************/
January 17, 2006 at 11:33 am
David: I would hope that I haven't built quite that bad of a reputation for apoplexia!
I admit that I do tend to respond to certain topics rather forcefully, but...
/*****************
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 17, 2006 at 11:22 am
With the introduction of 2005 Standard Edition is no longer limited in the amount of RAM it can use
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
The page I referenced above seems to be removed, but if...
/*****************
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 10, 2006 at 9:52 am
They have actually done a really good job with Books Online from my experience, and there are certainly a bunch of specific recommendations there, but it's not in an easily...
/*****************
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 9, 2006 at 12:56 pm
It's not exactly a "best practices" guide but here is the link to the msdn operations guide (as it currently exists) for SQL Server 2005
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/operations.mspx
/*****************
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 9, 2006 at 12:44 pm
A good modeling tool such as ER Studio can help. It can reverse engineer the existing tables and infer relationships where the column names and data types are the same. ...
/*****************
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 4, 2006 at 3:16 pm
Yes, hardware virtualization has proven itself for many years in the mainframe environment and more recently in the *nix world, but the hardware was specifically built for it. CPU manufacturers...
/*****************
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 4, 2006 at 1:02 pm
Viewing 15 posts - 256 through 270 (of 824 total)