Viewing 15 posts - 766 through 780 (of 823 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...
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...
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...
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...
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...
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...
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. ...
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
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...
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...
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...
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?
February 27, 2004 at 10:20 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...
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...
February 11, 2004 at 12:21 pm
Viewing 15 posts - 766 through 780 (of 823 total)