Forum Replies Created

Viewing 13 posts - 31 through 43 (of 43 total)

  • RE: Not Just At Home

    To Matt's point, a previous employer of mine justified telecommuting based on building rent. They reduced their square footage by 33% and had the displaced workers telecomute. In...

  • RE: Not Just At Home

    My current company has been experimenting with virtual desktops which could help reduce costs even more -- it just assumes that people have a PC at home already 🙂 ...

  • RE: Deadlock Notifications in SQL Server 2005

    I haven't tried it yet, but could you also set up an Alert in SQL Server 2005 where the Object is SQL Server:Locks and the Counter is Number of Deadlocks/sec...

  • RE: Conditional Statements in WHERE Clauses

    To me its all about knowing your data. This is a great method to use some of the time, but it will cost you in performance in some cases....

  • RE: Creating a Script from a Stored Procedure

    I came across this article while looking for a size limit on the sp_OAMethod output vaiable.  It turns out that the 255 character limit that Ryan had in this article...

  • RE: Question of the Day for 02 Aug 2007

    I answered this one correctly as credited, but as soon as I read it I knew the wording would cause problems.  In reality, I would have checked Errorlog before the...

  • RE: Question of the Day for 30 Jul 2007

    Well I got this wrong, choosing option B with about 41% of other people.  I think we needed an option E - A real DBA would not use SMO for this...

  • RE: Preferred RAID

    At all of the companies I have been at we tend to use RAID 5.  Many times it has to do strictly with cost, and you get more usable disk for...

  • RE: Question of the Day for 13 Apr 2007

    I would say the answers are flawed.  The question as phrased should have had 2 possible answers A) Yes, or B) No.  For people who have been keeping up to...

  • RE: Views and Horizontal Portioning

    A good overview of views.  One area I would caution on the use of horizonal partitioning - if your views encompasses a lot of tables (60+ in our case) and...

  • RE: Question of the Day for 09 Apr 2007

    I've never used the option specified in the MSFT link below, but it seems to say that you can execute packages in 32-bit mode from a 64-bit install.  Specifically it...

  • RE: Question of the Day for 04 Apr 2007

    I would have to agree that D is more correct than B.  In addition to the points above, the referenced article even states that using a SELECT INTO will cause...

  • RE: Question of the Day for 23 Mar 2007

    I liked how it gave me the following response to my "incorrect" answer:

    Correct Answer: 2382

    You Answered: 2382

Viewing 13 posts - 31 through 43 (of 43 total)