Forum Replies Created

Viewing 15 posts - 61 through 75 (of 88 total)

  • RE: Finding the Correct Weekday Regardless of DateFirst

    Nice and well written article. Just however

    the week as per the English calendar as to be starting from Sunday and ending on Saturday.

    I have a little problem with...

  • RE: Safety in Numbers

    2 backups on disk (3 for system tables), 7 days on on site disk/tape, copies offsite.

    Restore of main database every month from Live to Dev environment to

    a) eliminate any baseline...

  • RE: What's a Toaster?

    Password Safe - nothing beats this little utility for remembering passwords.

    Firefox - just can be made easier seure than IE and works good.

    Google - search works fast, hits are good,...

  • RE: Arrogance Has No Place in Security

    Steve Jones - Editor (1/28/2010)


    ...The thing that struck me was that it seemed the tone of the military was that "no one could hack this or use it", which is...

  • RE: Arrogance Has No Place in Security

    Bruce Schneier's blog post is good but he only addresses the technical implications and not the political fallout. In this regard the Wired Danger Room article and David Axe's comment...

  • RE: Arrogance Has No Place in Security

    Is this really a problem with security? Or is it working as intended?

    The "big" story here is that someone unauthorised can (and does) use the feed from the camera of...

  • RE: Twenty tips to write a good stored procedure

    gfabbri (8/10/2009)


    sorry, it is better to put SET NOCOUNT ON, isn't it?

    Definitely - SET NOCOUNT ON suppresses the count messages. Kinda wrong way round - the code shown...

  • RE: Twenty tips to write a good stored procedure

    Very nice guidelines but with regards to performance point 11 doesn't make sense to me.

    "11. More WHERE clause hints - Avoid unnecessary conditions in the WHERE Clause. You can easily...

  • RE: A Dearth of Comments

    As for system changes there are tools out like MOM for Windows that can do this. Not sure how deep it goes as I never had to configure this.

    While MOM...

  • RE: A Dearth of Comments

    It's definitely the easy way out for developers to skip (or skimp) documentation. It's like the seventh red-haired (step) child that nobody likes because it sticks out so much, takes...

  • RE: Creating Databases

    One thing I would change almost always now that I've learned a bit is to create straight from the start a second filegroup. Call it Data. Then set Data as...

  • RE: Finding and Listing ALL Procedures, Functions, and Views in SQL Server 2005

    Sorry, but this part...

    One last note, if you want to create an SP and have it distributed (automatically included) with all databases you create then you will want to create...

  • RE: A Story of the Deleted Transaction Log

    I think James hasn't told us everything yet. 😀

    What I find curious is that the technician was able to detach the database (otherwise he wouldn't have been able to delete...

  • RE: A Story of the Deleted Transaction Log

    wolfen (7/14/2008)


    I am just wondering how the transaction log has been deleted during SQL server being running. The SQL server locks the data and log files and they cannot be...

  • RE: Data Rich and Information Poor

    What I came across in the last few years doing BI is that most companies don't know their requirements and this is one of the biggest obstacles implementing a BI...

Viewing 15 posts - 61 through 75 (of 88 total)