Viewing 15 posts - 766 through 780 (of 824 total)
The MOVE clause needs to refer to the logical filename, not the physical file name. If you don't know what the logical filename is you can execute sp_helpdb 'FuseTalk' on...
/*****************
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
*****************/
July 30, 2004 at 3:38 pm
Truncating and shrinking the log file ARE related, but they are not the same thing.
I thought the problem was that the log was getting too large after the nightly...
/*****************
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
*****************/
July 30, 2004 at 8:32 am
The culprit is the nightly reindexing job. Reindexing is a logged operation and will cause your t-log to grow.
Also don't confuse log truncation with file shrinking operations. They are not...
/*****************
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
*****************/
July 29, 2004 at 2:59 pm
Very useful script, but there is one thing that should be changed. As it is you are using the Host_Name() function to populate the ServerName column. Host_Name() returns the name 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
*****************/
July 29, 2004 at 2:51 pm
Assuming you have the dbase ODBC drivers installed you can setup a system DSN that points to you dbase file(s). Then configure the linked server to use the Microsoft OLE...
/*****************
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
*****************/
July 28, 2004 at 8:51 am
There are several methods you could use depending on what your requirements are. Since you are talking about resumes, as opposed to applications, there is no predetermined format with a known...
/*****************
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
*****************/
July 27, 2004 at 11:05 am
I guess I was wrong about the lack of debate. I must say I disagree somewhat with Steve's recommendation to purchase a server with more CPU capacity than you will 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
*****************/
July 27, 2004 at 10:36 am
2GB is the limit for Standard Edition. All the talk about AWE and the 3Gb switch applies to Enterprise Edition. Here is the official MS reference on the matter:
http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.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
*****************/
July 27, 2004 at 9:25 am
I don't think you'll get much debate on the subject. If you need to stay with 32bit go with the latest Xeon CPU.
If, as you indicate, you are going...
/*****************
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
*****************/
July 27, 2004 at 9:20 am
Generally a good article, but the author fell prey to one of the most common errors about clustered indexes. He states:
"Do not try to place a clustered index on...
/*****************
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
*****************/
June 17, 2004 at 9:21 am
We started developing a system along these lines of thought about a year ago, and despite my dislike of XML I initially thought that it might actually work?!?!?!
Sure enough...
/*****************
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, 2004 at 3:19 pm
Is the service set up to run under a user account? If so, has the password been changed or the user deleted from the domain?
/*****************
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 27, 2004 at 10:20 am
I think you meant DTC...?
/*****************
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 19, 2004 at 11:04 am
How about "Does the column make sense logically?" i.e. will the column take my BCNF table(s) and turn them into an unnormalized mess of redundancy and inconsistency?
This, of course, assumes...
/*****************
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 19, 2004 at 10:53 am
Unfortunately, MS has not provided us, the DBA's, a good way of actually seeing what SQL is actually being executed by sp_execute. This makes troubleshooting and optimization very difficult at...
/*****************
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 11, 2004 at 12:21 pm
Viewing 15 posts - 766 through 780 (of 824 total)