Viewing 15 posts - 121 through 135 (of 824 total)
This is because by default the PK is the clustered index and hence the index IS the table. You will have to specify the PK as a nonclustered index for...
/*****************
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 30, 2007 at 11:01 am
Run this and see what the file sizes are.
RESTORE FILELISTONLY
FROM DISK = 'backupFilePathAndName'
If the combined file size of all the files in the backup exceed the amount of free space,...
/*****************
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 30, 2007 at 10:58 am
QA 2000 does work with 2005, but there will be some issues with syntax highlighting and with the object browser etc...
You can install Management Studio (Query Analyzer and Enterprise Manager...
/*****************
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 30, 2007 at 10:53 am
Agreed, this is the kind of conversation that is really great to have at the PASS Summit...
I'll also agree with the basic premise of your post, we should get 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
*****************/
January 30, 2007 at 8:58 am
Now I'm going back to my old curmudgeon self. I would counter that you aren't thinking about far too shallowly. The whole point of database management systems (not just SQL or Relational...
/*****************
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, 2007 at 3:59 pm
As a sometime author for this site, I really agree with Andy's sentiment. I hope that Wayne will continue to contribute his experience with the rest of us. As far...
/*****************
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, 2007 at 1:10 pm
Just a couple of points here:
In general I don't think that Read Committed Snapshot isolation would be all that beneficial in a DW/DSS system since you generally don't have concurrency...
/*****************
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 25, 2007 at 3:33 pm
Yes, I've used it and it works great. The Read Committed Snapshot (RCS) Isolation level prevents readers from blocking writers and vice versa. It CAN greatly enhance concurrency, but may actually...
/*****************
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 25, 2007 at 8:22 am
"I would add that a hint is just that "a hint" not 100% of the time you will get what you asked for"
This seems to be a fairly common misconception. ...
/*****************
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, 2007 at 2:14 pm
I second Collin here. NOLOCK is fine for some things (as Andy points out). However, it can be dangerous too and one MUST understand the tradeoffs involved before you use...
/*****************
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, 2007 at 9:28 am
The short answer is yes, SQL Server on the IA64 does have the same kind of backward compatibility that the x86 flavor does.
Longer answer: I've never been a big...
/*****************
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, 2007 at 7:56 am
Obviously, that was some time ago (an eternity in hardware years) but they were single core Itanium processors and of course the Xeons were x86 type architecture.
Since then 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
*****************/
January 17, 2007 at 8:18 am
Actually you can... (I know, it's weird) however running that command will have no effect since the database is already set to use the Simple recovery model.
/*****************
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, 2007 at 3:49 pm
OK, that should do the trick, however there are still several things to keep in mind.
1. Setting the recovery to Simple does not shrink the existing file. If you need...
/*****************
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 8, 2007 at 2:27 pm
Let me guess, Mrs. Dori is a DB2 DBA, that's the term that they use for this...
Anyway what she is talking about is setting the recovery model to "Simple". I...
/*****************
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 8, 2007 at 2:07 pm
Viewing 15 posts - 121 through 135 (of 824 total)