Forum Replies Created

Viewing 15 posts - 766 through 780 (of 823 total)

  • RE: Copying databases from one server to another.

    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...

  • RE: Problem with transaction log backup

    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...

  • RE: Problem with transaction log backup

    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...

  • RE: How to retrive Drive capacity in SQL Server

    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...

  • RE: How to make linked server to dbase files

    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...

  • RE: How to Store resumes in SS2000?

    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...

  • RE: Best Intel Processor

    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. ...

  • RE: Memory with Standard edition

    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

  • RE: Best Intel Processor

    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...

  • RE: Index Creation Guidelines

    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...

  • RE: Reducing Round Trips Part 4

    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...

  • RE: Cant auto start service!

    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?

  • RE: SQL server in fiber mode

    I think you meant DTC...?

  • RE: Worst Practice - Adding a Column Without Thinking!

    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...

  • RE: sp_execute ?

    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...

Viewing 15 posts - 766 through 780 (of 823 total)